Deloitte Data Analyst candidates report an aptitude assessment followed by three interviews focused on practical SQL, business cases, dataframe basics, and explaining metric meaning.
$75K
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 | |
| Using R Squared | |
| Hurdles In Data Projects | |
| Missing Housing Data | |
| Find Duplicate Numbers in a List | |
| Assumptions of Linear Regression | |
| Duplicate Rows | |
| FAQ Matching | |
| Classification and Regression | |
| Slow SQL Query | |
| Swap Variables | |
| Yelp-like System | |
| Bias vs. Variance Tradeoff | |
| Data Preparation for Imbalanced Data | |
| Multicollinearity in Regression | |
| String Palindromes | |
| Seller Type Modeling | |
| Digital Classroom System Design | |
| Youtube Recommendations | |
| Client Solution Pushback | |
| Blob Indexing | |
| Simple Explanations | |
| Why Do You Want to Work With Us | |
| Justify a Neural Network | |
| Your Strengths and Weaknesses | |
| Data Cleaning Experiences |
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.