7 Data Analyst Interview Questions (with Sample Answers)
Data analyst interviews emphasize SQL, dashboards, and stakeholder communication. The bar is being able to translate fuzzy business questions into precise queries and clear narratives.
What to expect
- Expect 1–2 SQL rounds, a case round, and behavioral.
- Strong candidates ask clarifying questions before writing SQL — the JOIN you need depends on what the stakeholder actually means.
- Practice explaining a chart in 30 seconds with a clear takeaway.
The questions
- 01 · Behavioral
Tell me about yourself.
Why interviewers ask this: For a data analyst, this is your 60-second pitch. The interviewer is screening for clarity, signal, and fit.
How to answer: Use a Past → Present → Future structure: 1 sentence on background, 1–2 on current scope and a relevant win, 1 on why you want this role.
- 02 · Cultural Fit
Why are you interested in this role?
Why interviewers ask this: They are checking that you have read the JD and understand what makes this role and company different from generic alternatives.
How to answer: Tie 2 specific aspects of the role (a project, a stack, a customer segment) to 2 things you have actually done. Avoid flattery.
- 03 · Behavioral
Tell me about a time you failed.
Why interviewers ask this: Interviewers want to see how you handle real situations using the STAR method (Situation, Task, Action, Result).
How to answer: Pick a real failure with measurable consequences. Spend most of the answer on what you learned and the change you made afterward.
- 04 · Situational
A stakeholder asks: “Why did revenue drop last week?” How do you respond?
Why interviewers ask this: Tests how you decompose a fuzzy question.
How to answer: Triangulate: which segment, which channel, which product, which day? Lay out the diagnostic tree before running queries.
- 05 · Technical
Write SQL to find the top 3 products by revenue per month.
Why interviewers ask this: Window functions are table-stakes for analysts.
How to answer: Use ROW_NUMBER() / RANK() in a CTE partitioned by month. Mention how ties are handled and what indexes the query relies on.
- 06 · Technical
How do you decide between mean and median for a metric?
Why interviewers ask this: Probes statistical judgment and awareness of distribution shape.
How to answer: Anchor on skew and outliers. Use median for distributions with long tails (revenue per user, latency). Use mean when the sum matters.
- 07 · Behavioral
Tell me about an analysis that changed a business decision.
Why interviewers ask this: Differentiator — most candidates can describe analyses, few drove decisions.
How to answer: Name the decision-maker, the call before your analysis, what changed because of your work, and the measurable result.
Score your own answer free
Paste an answer to any Data Analyst interview question. Odin scores it on STAR coverage and rebuilds it line-by-line. No signup. 5 free scores per hour.
Practice these with real AI feedback
Odin runs voice-first mock interviews tailored to your resume and the job posting. You get STAR-method scoring, transcript analysis, and concrete suggestions on every answer.