
Goldman Sachs Data Analyst candidates report SQL-focused screens, data-cleaning and dashboard questions, project walkthroughs and behavioral questions. Here is what to prepare and what to expect.
$98K
Avg. Base Comp
$110K
Avg. Total Comp
2 rounds
Typical Rounds
Not reported
Process Length
Candidates who interviewed specifically for the Goldman Sachs Data Analyst role describe a process anchored in practical analytics work rather than heavy algorithm drills. Both Data Analyst reports start with a screening conversation about background, motivation and SQL experience. One candidate then faced a technical round on writing SQL queries, cleaning data, building dashboard reports and presenting insights to stakeholders, including how they would work through a large dataset to find useful business insights. The other describes two screening rounds in which basic SQL, join types and a walkthrough of a past data project were central. The second round placed more weight on SQL and closed with two situational questions. Neither candidate received an offer, and two reports is a thin base, so treat this as a likely shape rather than a fixed format.
Reports from Summer Analyst tracks at Goldman Sachs mention HireVue videos, Superdays and coding or math assessments. Those are different tracks, so use them only as loose context.
For preparation, be able to explain each join type and when you would use it, not just its definition. Rehearse one end-to-end project story: the question, data cleaning, analysis, visualization and the decision it supported. Prepare behavioral examples on teamwork, deadlines and explaining results to non-technical stakeholders. Keep your answers about motivation and experience consistent and specific, since one candidate noticed the same questions repeated across rounds.
Synthesized from 13 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 Goldman Sachs 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 Goldman Sachs
Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.
| Question | |
|---|---|
| Bagging vs Boosting | |
| Size of Joins | |
| Google Maps Improvement | |
| Append Frequency | |
| Comparing Search Engines | |
| Minimum Absolute Distance | |
| Production Model Monitoring | |
| Success Measurement | |
| Target Indices | |
| The Longest Journey | |
| SageMaker Deployment Architecture | |
| Deciding Between Solutions | |
| Shortest Path Algorithms | |
| Company Acquisition Choice | |
| Alternative Vendor Tradeoff | |
| Client Solution Pushback | |
| Credit Score Estimation | |
| Using APIs for Downstream Tasks | |
| Direct Mail | |
| Analyzing Multiple Data Sources | |
| Risk Model for a Mortgage Bank | |
| 2nd Highest Salary | |
| Empty Neighborhoods | |
| Rolling Bank Transactions | |
| Employee Salaries | |
| Comments Histogram | |
| Closest SAT Scores | |
| Top Three Salaries | |
| Monthly Customer Report |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report applying online and then having a screening call. One candidate says it covered their background and SQL and analytics experience. Another describes a first round mixing basic SQL with motivation questions and a data project walkthrough. Expect to explain why you want the role and how past work fits.
Candidates report technical questions on SQL queries, join types, data cleaning, dashboard reporting and walking through a data project. One was asked how to analyze a large dataset and present findings to stakeholders. Another said a second round emphasized SQL joins and ended with situational questions.
Behavioral questions appear in both Data Analyst reports. They cover teamwork, managing deadlines, motivation for the role and communicating with stakeholders. Prepare concise stories with a concrete result.