Deloitte Data Analyst candidates report an aptitude assessment followed by three interviews focused on practical SQL, business cases, dataframe basics, and explaining metric meaning.
$90K
Avg. Base Comp
$105K
Avg. Total Comp
3 rounds
Typical Rounds
3-6 weeks
Process Length
For Deloitte Data Analyst interviews, the clearest reported theme is practical analytics reasoning: one candidate described an aptitude and logical-reasoning assessment followed by three interviews that repeatedly paired SQL with business cases. Rather than treating query writing as a stand-alone skill, the discussions returned to whether the candidate could explain what a result meant for the business.
Prepare to work through SQL directly and clearly. The reported questions included calculating an order repeat rate and distinguishing inner from outer joins; joins and window functions also came up repeatedly. A strong response should state the calculation or query logic, define the metric carefully, and then interpret the result in business terms. The same account described basic dataframe questions in the first technical discussion, so be ready to translate simple analytical operations between a dataframe and SQL mindset.
The three reported interviews were not identical: the first mixed SQL, dataframe questions, and a business case; the second was mostly SQL; and the third returned to SQL plus a business case. Practice explaining assumptions aloud under time pressure, especially when a metric could have more than one reasonable definition. The available Data Analyst evidence is limited to one detailed account, so formats may vary by team and location.
Synthesized from 3 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 Deloitte 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 Deloitte
Select the 2nd highest salary in the engineering department
| Question | |
|---|---|
| Raining in Seattle | |
| Maximum Profit | |
| Bagging vs Boosting | |
| Size of Joins | |
| Normalize Grades | |
| Using R Squared | |
| Missing Housing Data | |
| Find Duplicate Numbers in a List | |
| Hurdles In Data Projects | |
| Assumptions of Linear Regression | |
| Duplicate Rows | |
| FAQ Matching | |
| Classification and Regression | |
| Slow SQL Query | |
| Swap Variables | |
| Data Pipelines and Aggregation | |
| Yelp-like System | |
| User Event Data Pipeline | |
| Bias vs. Variance Tradeoff | |
| Data Preparation for Imbalanced Data | |
| Multicollinearity in Regression | |
| String Palindromes | |
| Seller Type Modeling | |
| Open Source Reporting Pipeline | |
| Blob Indexing | |
| Scalable Data Pipelines | |
| Youtube Recommendations | |
| Digital Classroom System Design | |
| Client Solution Pushback |
Synthesized from candidate reports. Individual experiences may vary.
One candidate reported applying off campus and being shortlisted from the resume before assessments and interviews began. Keep your experience ready to discuss, but the account does not specify resume-screen questions or selection criteria.
The candidate reports clearing an online assessment with aptitude and logical-reasoning questions before being called to interviews. The available account does not identify the assessment length, platform, or exact question formats.
In the first reported interview, candidates encountered SQL and basic dataframe questions alongside a business case. Reported preparation should emphasize explaining a query or metric result in business terms, not only producing an answer.
The second reported interview was mostly SQL. The account specifically recalls joins, window functions, and an order repeat-rate calculation, suggesting candidates may need concise query reasoning and clear metric definitions.
The third reported interview again combined a business case with SQL. Candidates report that practical business intuition was a recurring focus, so they may be asked to connect analytical output to a decision or interpretation.
