Skip to content
CareersAble

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.

All data questions

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.

  1. How many reporting requests do you handle in a typical week?
  2. Which business teams do you produce dashboards for?
  3. Do you write your own SQL, or mostly work from prepared extracts?
  4. Which of your reports are used in a regular meeting, and by whom?
What this round scores

Hiring manager interview questions

The person you would report to, 45 to 60 minutes, sometimes with a team member.

  1. Tell me about a dashboard nobody used and what you did about it.
  2. How do you handle two reports that show different numbers for the same metric?
  3. A manager asks for "a quick report on sales". What do you ask before you start?
  4. Tell me about a time you found an error in a report that was already being used.
What this round scores

Final round questions

Senior leaders, a panel, or a case task, 60 minutes to half a day.

  1. Walk me through this dataset and tell us the three things you would report.
  2. Write a query that shows monthly retention for customers who signed up this year.
  3. Turn this spreadsheet of results into one chart and one sentence for an executive.
  4. Here is a dashboard our sales team uses: what would you remove, and why?
What this round scores

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?
See all 24 data questions, with scored example answers

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
Where are you in your search?

We email you the pack once. We never sell or share your details. Privacy policy

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?”

Weak30
“I'd just pull the sales data for the last few months and send it over. If they need more, they can ask.”
Why: Guesses the question and pushes the rework back onto the manager.
OK58
“I'd ask which time period, which products and whether they want revenue or units. Then I'd build it in our BI tool.”
Why: Good clarifying questions, but never asks what decision the report is for.
Strong85
“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.”
Why: Starts from the decision, shows how the question changed and the result.

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.