Deloitte Data Analyst Interview Guide

Deloitte Data Analyst candidates describe a practical, mostly SQL-driven loop, though the exact steps change from office to office and team to team. The technical conversation most often centers on SQL joins, window functions and ranking. Reported questions include inner versus outer joins, finding the second highest salary, ranking records, and calculating the repeat rate of orders. One candidate said the interviewers cared as much about what the result meant for the business as about whether the query ran.

Interviewers also want to hear about your own work. Several candidates were asked to walk through resume projects, explain the challenges they hit, and describe how they pulled insight from large datasets. Others were asked how they would clean messy data, how they would check that data can be trusted, and how they would diagnose a drop in product sales. Excel lookups, Python or pandas basics, and Power BI each came up in individual reports.

Case work shows up in different forms: a business case alongside SQL, a consulting-style case study with a director, or a scenario laid out in a video round. The mix is not uniform. One candidate found the video and IQ-style items had little to do with analytics, and another was opened with a broad question about what success means to them.

Timelines vary widely. Several candidates report about a week to two weeks from first contact to offer, one describes about a month across manager, senior manager and director interviews, and one reports a wait of more than three months across three rounds. Practice explaining your SQL reasoning out loud, rehearse two or three project stories, and keep a simple framework ready for unfamiliar business problems.