Data Analyst Interview Questions at Goldman Sachs — What to Expect in 2026
Meta description: Goldman Sachs Data Analyst interview: 6 rounds over ~8 weeks including SQL, stats, case study, and a Superday onsite. Format and sample questions.
Goldman Sachs' Data Analyst process runs about six rounds over roughly 8 weeks: a recruiter screen, a hiring-manager screen, a SQL and data-modeling round, a statistics and probability round, a case study, and a behavioral interview. The final two technical/case rounds are frequently bundled into a "Superday"-style onsite with three to five back-to-back interviews in one day. Nearly every round is conducted by video, and the bar leans heavily on live SQL fluency (joins, window functions, schema design) plus the ability to reason about ambiguous business problems out loud.
Interview Process at a Glance
| Round | Format | Focus | Typical Length |
|---|---|---|---|
| Recruiter screen | Video | Background, role fit, location/visa | 30 min |
| Hiring manager screen | Video | Turning ambiguous asks into measurable work | 30 min |
| SQL & data modeling | Video, live | Joins, aggregations, window functions, schema design | 60 min |
| Statistics & probability | Video, live | Distributions, hypothesis testing, A/B testing | 45 min |
| Case study | Live (Superday) | Business problem sizing, metric definition | 45 min |
| Behavioral | Live (Superday) | Judgment, integrity, teamwork, conflict | 30 min |
Timeline: ~8 weeks end to end. Difficulty: Candidates describe the SQL round as the main filter — live, timed, and expected to be near error-free.
Sample Interview Questions by Round
SQL & data modeling
- Write a query using window functions to rank trades or transactions within a region.
- Use a LAG function to compute day-over-day change in a time series table.
- Identify data-quality issues across a transaction table and a status table joined on temporal keys.
- Reconcile ledger postings against bank transaction records — what joins and checks would you run?
- Design a dimensional model: what's the grain and key for a trade fact table?
InterviewBoost approach: Live SQL under time pressure is a rehearsal problem, not a knowledge problem. InterviewBoost's coding interview assist lets you practice timed SQL prompts and get feedback on query structure before the real round.
Statistics & probability 6. How would you choose a metric for an A/B test when the underlying distribution is heavy-tailed? 7. Explain the difference between a Type I and Type II error in a business context, with an example from financial data.
Case study 8. How would you define and track growth in assets under management (AUM), including edge cases like transfers between accounts? 9. A stakeholder asks for "more engagement" as a goal — how do you turn that into a measurable analysis plan?
InterviewBoost approach: Case rounds reward a repeatable framework: clarify → define the metric → outline the analysis → flag risks. Rehearse this structure in an InterviewBoost AI mock interview so it becomes automatic under pressure.
Behavioral 10. Tell me about a time you had to push back on a stakeholder's request. 11. Describe a situation where you found an error in your own analysis after presenting it — what did you do?
FAQs
How many rounds does the Goldman Sachs Data Analyst interview have? Candidates typically report six: recruiter screen, hiring manager screen, SQL/data modeling, statistics/probability, case study, and behavioral — with the last two often part of a Superday onsite.
Is the SQL round live coding? Yes — it's reported as a live, timed round covering joins, aggregations, window functions, and schema design questions.
How long does the process take? Around 8 weeks from recruiter screen to offer, based on candidate reports.
Does Goldman Sachs ask take-home assignments for Data Analyst roles? Reports point to live, video-based rounds rather than take-home projects, with the SQL and case rounds conducted in real time.
What's the hardest part of the Goldman Sachs Data Analyst interview? Most candidates flag the live SQL round and the pace of the Superday (multiple back-to-back interviews in one day) as the toughest parts.
Keep Preparing
Compare with related pages: Goldman Sachs Product Manager interview questions, JPMorgan Data Analyst interview questions, Senior Data Analyst interview questions, Goldman Sachs Financial Analyst interview questions, and Goldman Sachs Data Scientist interview questions.
Practice live SQL and case rounds with real-time guidance — InterviewBoost.ai offers coding interview assist and AI mock interviews built for exactly this format. Start your free 1-week trial.