
Google Business Analyst interview typically runs 5–6 rounds: recruiter screen, SQL/HackerRank assessment, live technical, business scenarios, Googleyness/leadership, and a hiring manager round. The process spans 2–6 weeks and is distinguished by its emphasis on structured thinking, GCA-style questions, and role alignment over pure technical depth.
$90K
Avg. Base Comp
$223K
Avg. Total Comp
4-5
Typical Rounds
3-5 weeks
Process Length
Our candidates report that Google's Business Analyst interviews are structured around three distinct lenses — role-related knowledge, general cognitive ability (GCA), and Googleyness — and the experiences we've collected make clear that all three carry real weight. The GCA component surprises people most. Multiple candidates described moments where the interviewer stopped caring about the answer itself and started probing the reasoning behind it: "why this approach?" and "how would this scale?" were common follow-ups. One candidate blanked on a window function syntax mid-interview and recovered by talking through the logic — and it worked. That tells us Google is watching for how you think when you're uncomfortable, not just when you're confident.
A second pattern we've seen consistently is how much business translation ability shapes the final evaluation. The candidates who felt strongest were the ones who could move fluidly between a technical choice and its business implication — explaining a dashboard decision to a non-technical stakeholder, or framing a retail KPI problem in terms of customer behavior rather than query structure. The scenario-based questions around SMB digital marketing and customer management weren't soft filler; they were the actual test. Candidates who treated them as such fared better than those who saved their energy for the SQL rounds.
The non-obvious make-or-break factor here is communication style. One accepted candidate specifically noted how jargon-heavy the supervisor interview felt, and that alignment with how Google expects you to talk about your work mattered as much as the substance. The estimation question about fitting balls in a 747 — which stumped one rejected candidate — is a reminder that structured ambiguity handling is baked into the process at every level, not just the technical rounds.
Synthesized from 6 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Google process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Google
Write a query that returns all neighborhoods that have 0 users.
| Question | |
|---|---|
| 2nd Highest Salary | |
| 500 Cards | |
| Button AB Test | |
| Top Three Salaries | |
| First Touch Attribution | |
| Top 3 Users | |
| Minimum Change | |
| Jars and Coins | |
| Experiment Validity | |
| WAU vs Open Rates | |
| Complete Addresses | |
| Last Transaction | |
| Daily Retention Summary | |
| Size of Joins | |
| P-value to a Layman | |
| Google Maps Improvement | |
| Fair Coin | |
| Cyclic Detection | |
| Sort Strings | |
| Comparing Search Engines | |
| Expected Tests | |
| Hurdles In Data Projects | |
| Three Zebras | |
| Bucket Test Scores | |
| Network Experiment Design | |
| Delivery Estimate Model | |
| Random Bucketing | |
| Reducing Error Margin | |
| Target Indices |
Synthesized from candidate reports. Individual experiences may vary.
An initial call with a recruiter covering your background, motivation for the Business Analyst role, and whether you understand the business side of data analytics. Expect questions about your experience, why Google, and a high-level check on role fit. Some candidates also completed a written questionnaire or email exchange at this stage.
A timed online assessment focused on SQL skills including joins, aggregations, window functions, and ranking/filtering problems. The questions are manageable conceptually but time pressure is a real factor, so practicing under timed conditions is strongly recommended.
A live SQL and analytics round that emphasizes thought process over perfect syntax. Interviewers probe with follow-ups like 'why this approach?' and 'how would this scale to billions of rows?', so structured reasoning and communication matter as much as correctness.
Scenario-based and situational questions assessing Googleyness, leadership, and general cognitive ability (GCA). Interviewers look for structured responses using the STAR method, comfort with ambiguity, and clear communication. Topics include customer management, team coordination, and handling difficult situations.
A business-focused interview with the hiring manager or a senior leader covering role-related knowledge, business scenarios (e.g., retail KPIs, digital marketing strategy, dashboarding for non-technical stakeholders), and your understanding of the team's mission. Some candidates had two hiring manager rounds due to team reorganizations.