Data analyst interview questions and answers
Data analyst interview questions and answers usually mix SQL or spreadsheet tests, a case or take-home task, and behavioral questions about explaining findings. Interviewers care less about clever tricks than about clean logic, careful checking and a clear recommendation. Practice writing queries by hand, and prepare a story where your analysis changed a decision.
At a glance
- Expect four parts: screening call, technical test, case or portfolio review, team interview.
- Show how you check your work, not only how you compute.
- Explain every answer in plain language.
- Prepare one project from start to finish.
- Ask which tools, data sources and stakeholders you would work with.
Technical topics to review
| Area | What to be ready for |
|---|---|
| SQL | Joins, grouping, filtering, window functions, handling nulls and duplicates |
| Spreadsheets | Lookups, pivot tables, cleaning data |
| Statistics | Averages and medians, distributions, sampling, correlation versus causation, basic hypothesis tests |
| Visualization | Picking a chart, labelling, avoiding misleading scales |
| Data quality | Missing data, outliers, definitions that differ between teams |
Common data analyst interview questions with answer outlines
Walk me through a project from raw data to recommendation. State the question, the data and its limits, how you cleaned it, the method, the result and the decision it supported.
How do you check your numbers are right? Reconcile totals with a known source, test edge cases, compare with a prior period, ask a colleague to review.
Explain a statistical idea to a non-technical person. Use a plain example, such as the difference between the average and the median in a small set of salaries.
What would you do if two reports show different revenue figures? Compare definitions, date ranges, filters and data sources; find the difference before choosing a number.
Tell me about a time your analysis was wrong. Be honest about the cause and the fix. See STAR answers.
How do you handle a vague request? Ask what decision it supports, who will use it and by when.
Take-home task checklist
- Restate the question in one sentence.
- List assumptions and limits.
- Show the steps so a reviewer can reproduce them.
- Lead with the answer, then the evidence.
- Keep the visuals few and clear.
- Respect the time limit you were given.
Questions to ask
Which data tools does the team use? Who owns data definitions? How are analyses requested and reviewed? How does the team know a report was useful?
What interviewers are checking
Data analyst titles vary by employer, so the closest official descriptions are for related occupations. The U.S. Bureau of Labor Statistics (BLS) Occupational Outlook Handbook, as accessed 31 October 2026, says data scientists collect, categorize and analyze data, use data visualization software to present findings, and make business recommendations to stakeholders. For operations research analysts it lists collecting data, building and testing quantitative models, and writing reports that advise decision makers.
Both pages list the same core qualities: analytical skills, communication skills (explaining results to technical and nontechnical audiences), math skills, and problem-solving. Expect each interview round to test one of them.
| Quality (BLS) | How it shows up in an interview |
|---|---|
| Analytical skills | SQL test, case study, reading a chart |
| Communication skills | "Explain this to a manager" questions |
| Math and statistics | Averages, sampling, simple tests |
| Problem solving | Messy data and vague requests |
More questions to practice
- Find the second highest value in a column. Say how you would handle ties before you write the query.
- A key metric dropped sharply last week. How do you investigate? Check data pipeline problems first, then segment by time, product and user group.
- When would you use a median instead of an average? When outliers would pull the average away from a typical value.
- How do you decide which chart to use? Match it to the question: trend over time, comparison, or share of a whole.
- How would you explain a confidence interval to a manager? Use a plain-language range example and state what it does not tell you.
How to answer a case study, step by step
- Restate the question and confirm the decision it supports.
- Ask what data exists and how it is defined.
- State assumptions out loud.
- Describe the checks you would run before trusting the data.
- Give the answer first, then two or three supporting facts.
- Name what you would do next and what could change your mind.
Common mistakes
- Jumping to the query without clarifying the question.
- Presenting a number with no sanity check.
- Using jargon with a nontechnical interviewer.
- Claiming causation from a correlation.
- Describing a team project without saying what you personally did.
- Sharing confidential data from a past employer.
Frequently asked questions
How good must my SQL be? Enough to write joins, aggregations and a window function without help. Ask the recruiter what the test will cover.
Do I need a portfolio? It helps. Use public or anonymized data and never share confidential employer data.
Is there a practice set? The Professional plan includes a Data and analytics set. See mock interviews.
Do analysts need a degree? The BLS says data scientists typically need at least a bachelor's degree, and operations research analysts typically need at least a bachelor's degree too. Analyst job posts vary, so check the one you are applying to.
Which should I learn first, SQL or Python? Read the job post. Most analyst screens test SQL, so confirm with the recruiter.
How long should my project explanation be? About three minutes, with the question, the method, the result and the decision.
Next step
Prepare one end-to-end project and practise explaining it in three minutes.
This page is general career information.