Data & analytics: interview questions by round
15 curated questions we wrote as practice material. For each question you get guidance on what a strong answer shows. Use it to structure answers from your own experience, never to memorise someone else's.
Hiring manager
How answers in this round are assessed
- Context: Sets up a specific, real situation briefly (who, where, stakes).
- Own actions: Explains what YOU did and why — decisions, trade-offs.
- Outcome: States the result, ideally measurable, and what changed.
- Reflection: Shows learning or what you'd do differently.
- Clarity: Structured, concise, easy to follow (≈1–3 minutes spoken).
What does a good data analyst do when a stakeholder asks a question that is badly framed?
Show how you clarify the underlying decision, agree on definitions and confirm what would change based on the answer.
Skills: Data Analysis, Stakeholder Management
Behavioral
How answers in this round are assessed
- Context: Sets up a specific, real situation briefly (who, where, stakes).
- Own actions: Explains what YOU did and why — decisions, trade-offs.
- Outcome: States the result, ideally measurable, and what changed.
- Reflection: Shows learning or what you'd do differently.
- Clarity: Structured, concise, easy to follow (≈1–3 minutes spoken).
Describe a time you discovered an error in your own analysis after sharing it.
Good answers show quick, transparent correction and a check that prevents repeats, rather than quiet fixes.
Skills: Data Analysis, Communication
Tell me about a time your analysis led to a decision that changed something.
Shows you linked analysis to action, communicated limits and followed up on results.
Skills: Data Analysis, Communication
Technical / domain
How answers in this round are assessed
- Problem understanding: Clarifies the question, assumptions and constraints.
- Approach: Explains a reasoned approach and alternatives.
- Trade-offs: Names trade-offs, risks and limits.
- Experience: Connects to real experience where relevant.
- Clarity: Structured and precise communication.
A metric dropped 15 percent week over week. How do you investigate?
Start with data quality and definition checks, then segment by dimensions and time, and form hypotheses to test before presenting a cause.
Skills: Data Analysis, Product Analytics
Describe how you would design a reliable daily data pipeline.
midCovers idempotency, validation, monitoring, backfills and failure handling, not only the happy path.
Skills: Data Engineering
Explain overfitting and how you would detect and reduce it.
midAccurately describes train versus validation behaviour, with options like regularisation, more data and simpler models.
Skills: Machine Learning, Statistics
Explain the difference between correlation and causation and how you would test for a causal effect.
Shows an accurate grasp of confounding and randomised experiments, plus alternatives when experiments are not possible.
Skills: Statistics, A/B Testing & Experimentation
How do you choose an evaluation metric for a classification model with imbalanced classes?
midExplains why accuracy misleads, then ties precision, recall or other metrics to the business cost of each error type.
Skills: Machine Learning, Statistics
What is a sensible way to handle missing values in a dataset?
No single rule: show you consider why data is missing, the impact on analysis and document the choice.
Skills: Data Analysis, Statistics
Write or describe a SQL query to find each customer's most recent order.
Demonstrates joins or window functions, correct handling of ties and nulls, and awareness of performance on large tables.
Skills: SQL
Coding or case study
How answers in this round are assessed
- Problem understanding: Clarifies the question, assumptions and constraints.
- Approach: Explains a reasoned approach and alternatives.
- Trade-offs: Names trade-offs, risks and limits.
- Experience: Connects to real experience where relevant.
- Clarity: Structured and precise communication.
Here is a dataset with a surprising result. Explore it and tell me what you would check before trusting it.
Checks for data quality, selection effects and confounding before offering explanations, and states confidence honestly.
Skills: Data Analysis, Statistics
You are given a table of user events. Write queries to compute daily active users and seven-day retention.
Shows correct date handling, cohort definition and clear statement of assumptions about what counts as active.
Skills: SQL, Product Analytics
System design
How answers in this round are assessed
- Problem understanding: Clarifies the question, assumptions and constraints.
- Approach: Explains a reasoned approach and alternatives.
- Trade-offs: Names trade-offs, risks and limits.
- Experience: Connects to real experience where relevant.
- Clarity: Structured and precise communication.
Design a data platform for a mid-sized company that wants reliable dashboards and some machine learning.
seniorCovers ingestion, storage layers, data quality, ownership and governance, matched to the company's size and skills.
Skills: Data Engineering, System Design
Panel
How answers in this round are assessed
- Context: Sets up a specific, real situation briefly (who, where, stakes).
- Own actions: Explains what YOU did and why — decisions, trade-offs.
- Outcome: States the result, ideally measurable, and what changed.
- Reflection: Shows learning or what you'd do differently.
- Clarity: Structured, concise, easy to follow (≈1–3 minutes spoken).
Present an analysis you did and explain its limitations to a mixed technical and non-technical audience.
Shows you tailor depth to the audience and state limitations and confidence clearly.
Skills: Data Analysis, Presentation Skills
Final
How answers in this round are assessed
- Relevance: Answers the actual question and links to the role.
- Specificity: Concrete facts instead of generic claims.
- Motivation: Credible, role-specific motivation.
- Clarity: Short and clear.
How do you make sure the insights you produce are actually used?
Shows early involvement of decision makers, clear recommendations, follow-up and feedback loops.
Skills: Data Analysis, Stakeholder Management
Practise these with your own stories and get structured feedback in a free workspace.
Create free account