Interview questions
Data Analyst interview questions
Data Analyst interview questions for each round, from the screening call to the SQL test, with what each round is scoring.
Answer one Data Analyst question out loud today and time yourself.
How Data Analyst interviews are scored
Data analyst interviews score how you turn a vague question into a precise one. Clarifying the metric and time period before writing any SQL earns more credit than a fast query that answers the wrong thing.
What hiring managers check in Data Analyst interviews
- Whether you clarify the question before writing SQL, because a fast answer to the wrong question costs a week.
- Whether you can explain why two numbers differ, which is most of the job once dashboards exist.
- Whether your output leads to a decision, so the test task is marked on the sentence, not only the chart.
Pick the check you are weakest on and prepare one Data Analyst story for it tonight.
Questions Data Analyst candidates get
On top of the questions every role in this field is asked, these come up for this title in particular.
Screening interview questions
Usually a recruiter or talent partner, 15 to 30 minutes, often by phone or video.
- How many reporting requests do you handle in a typical week?
- Which business teams do you produce dashboards for?
- Do you write your own SQL, or mostly work from prepared extracts?
- Which of your reports are used in a regular meeting, and by whom?
Hiring manager interview questions
The person you would report to, 45 to 60 minutes, sometimes with a team member.
- Tell me about a dashboard nobody used and what you did about it.
- How do you handle two reports that show different numbers for the same metric?
- A manager asks for "a quick report on sales". What do you ask before you start?
- Tell me about a time you found an error in a report that was already being used.
Final round questions
Senior leaders, a panel, or a case task, 60 minutes to half a day.
- Walk me through this dataset and tell us the three things you would report.
- Write a query that shows monthly retention for customers who signed up this year.
- Turn this spreadsheet of results into one chart and one sentence for an executive.
- Here is a dashboard our sales team uses: what would you remove, and why?
Plus the data questions every round asks
- Walk me through your data background in two minutes.
- Which tools do you use most: SQL, Python, R or a BI tool?
- What kind of data and business questions do you work on now?
- Tell me about an analysis that changed a business decision.
- Tell me about a time the data was messy or wrong and what you did.
- How do you explain a technical result to someone non-technical?
- Sign-ups dropped 15 per cent last month: walk us through how you would investigate.
- How would you design an experiment to test a new pricing page?
- How would you set up a reporting layer for a team with no data culture?
Get the data question pack by email
Every question on this page in one email, grouped by round. Plus three things that are not on the page:
- 12 more questions, 4 per round, that only go out by email
- What a strong answer covers in each round, to check yourself against
- A 7-day prep plan that matches where you are in your search
Hiring manager interview
One question, three answers, three scores
The same question answered three ways, scored the way an interviewer would mark it.
“A manager asks for "a quick report on sales". What do you ask before you start?”
“I'd just pull the sales data for the last few months and send it over. If they need more, they can ask.”
“I'd ask which time period, which products and whether they want revenue or units. Then I'd build it in our BI tool.”
“I'd ask what decision it's for first. Last time this came up, the manager was deciding whether to cut a product line, so the real question was margin by product over 12 months, not total sales. I sent one chart and two lines of commentary the same day, and the line was cut the next week.”
Example scores on the 0 to 100 scale CareersAble uses. Your own answer gets its own score.
Reading the questions is not the same as answering them.
CareersAble writes the questions your actual job ad will ask, records your answers, scores each one three times and tells you plainly what to fix.
Free to start. No card needed.