Data · Interview questions
Data Analyst interview questions
These questions test whether a candidate can answer real business questions from existing data and get people to act on the answers. Each links to a first-year outcome: agreed metrics, a used dashboard, fast and repeatable requests, analyses that change decisions and reliable data.
The questions
Ask every candidate the same questions in the same order, and score each answer against the notes before you talk it over with the panel.
Tell me about a time two teams reported different numbers for the same metric. How did you resolve it?
- What it tests
- One agreed definition per metric
- A strong answer
- They traced each number back to its source and logic, found the difference, such as date range or filters, and got both teams to agree one written definition.
- Watch for
- They picked the number they preferred without agreement.
Show me or describe a dashboard you built that people used every week. How do you know they used it?
- What it tests
- Self-serve dashboard
- A strong answer
- They describe a focused dashboard built around a few questions, with feedback from users and usage they can point to. They removed charts nobody used.
- Watch for
- They are proud of how many charts it had, not who used it.
Using this sample database of orders and customers, write a query for monthly revenue by customer region, and another for the share of customers who ordered again within 90 days.
- What it tests
- SQL and repeatable requests (work sample)
- A strong answer
- The queries are correct, handle edge cases like refunds or missing regions and are easy to read. They explain their assumptions.
- Watch for
- Joins that double-count rows without them noticing.
You receive five data requests on Monday morning and can only finish two this week. How do you decide, and what do you tell the others?
- What it tests
- Handling requests within 3 days (scenario)
- A strong answer
- They ask about the decision each request supports and its deadline, agree priorities with a manager if needed and give the others a clear date. Some requests may be pointed to an existing dashboard.
- Watch for
- They work in order of arrival or try to do everything badly.
Tell me about an analysis you did that changed a business decision. What was the question, what did you find and what happened next?
- What it tests
- Analyses that lead to decisions
- A strong answer
- They describe a clear question, a sound method and a specific decision that followed, such as stopping a channel. They mention how they measured the result afterwards.
- Watch for
- The analysis was interesting but nothing changed.
Sign-ups dropped 30 percent last week. Walk me through how you would find out why.
- What it tests
- Investigating with existing data (scenario)
- A strong answer
- They first check whether the data or tracking broke, then break the drop down by channel, device, region and page. They test likely causes, such as a release or ad change, before drawing conclusions.
- Watch for
- They jump to a cause without checking the data first.
Tell me about a time a report you produced showed wrong numbers. How did you find out and what did you change?
- What it tests
- Data quality checks
- A strong answer
- They explain how the error was found, owned it and traced the cause. They added an automated check or test so the same problem would be caught before reaching a report.
- Watch for
- They fixed the number once and added no check.
Explain a finding from your past work to me as if I were a sales manager with no data background. Include how confident you were.
- What it tests
- Plain-language communication (essential requirement)
- A strong answer
- They lead with the answer and what it means for the listener, use one clear example and state limits honestly, such as sample size.
- Watch for
- They talk mainly about methods and tools.
New to structured interviews? Read how to run structured interviews and how to build an interview scorecard.
Start from the job description
These questions follow the first-year outcomes in the matching template.
Data Analyst job description templateSimilar roles
Your next hire, start to finish, in one place.
Free workspace. No card. Full scoring free for 7 days.