Skip to content
uxerhub

Data analyst interview questions, and a way to see who fits your team

A SQL test tells you who can write the query. A few minutes of everyday analyst decisions shows you what they do with the answer, set against what your team needs.

Two men working at large monitors side by side in an open office.

What a data analyst does

A data analyst turns the company’s data into answers people can act on.
  • Pulls and cleans data from the warehouse
  • Answers questions from other teams
  • Builds and keeps up dashboards and reports
  • Explains what the numbers mean, and what they don’t

What you can’t see when you hire a data analyst

Two analysts who pass the same SQL test can work in opposite ways. One answers what was asked, fast; the other asks what decision it’s for first. One builds dashboards so teams serve themselves; the other does the analysis by hand. One shows the numbers; the other says what to do. Neither is wrong. Only one fits how your teams use data.

What you choose when you create the link

Answers the question asked or questions the question
Delivers what was requested, quickly. Or: asks what decision it’s for first.
Builds for self-serve or does the analysis
Dashboards so people find their own answers. Or: hands-on work on each question.
Lets the numbers speak or makes the recommendation
Shows the data, leaves the call to others. Or: says what to do, from the data.

And what every role shares

  • Ships and corrects, or validates first
  • Takes things at face value, or reads between the lines
  • Decides and informs, or builds consensus
  • Says it right away, or picks the moment
  • Hands the first pass to AI, or works it out first

A decision a data analyst makes

Short choices like this one, from everyday work. Both options have a cost, and neither is the right answer. The live ones stay private, so nobody can rehearse them.

The numbers you sent yesterday had an error. Nobody has noticed.

  • Send a correction to everyone now

    People trust the next report a little less.

  • Fix it quietly in the next update

    Someone may decide on the wrong number this week.

Interview questions for a data analyst

Each one asks about something two good candidates do in opposite ways. Listen for what they did, not what they’d do.
  1. When did you change the question someone brought you? How did they take it?
  2. What’s a dashboard you built that people stopped using, and why?
  3. When did you recommend something the data only half supported?
  4. Tell me about an analysis that changed a decision. How did you get people to act on it?
  5. When did the data say something your stakeholder didn’t want to hear?
  6. How do you check a number before you send it?

What you get back

Candidates ordered by how close they are to what you asked for, the things you marked as must-haves first. For each one: where they match, where they differ, and the questions to ask in the interview.

Hiring a data analyst, in practice

No. It doesn’t test technical skills: use a take-home or a live query for that. It shows how someone works with the people asking the questions, which a technical test can’t.

About 6 minutes, on any device. At the end they see their own profile and can keep it.

For BI analysts, yes. For analytics engineers it reads well on how they serve other teams; add a technical interview on modelling.

Candidates ordered by how close they are to what you asked for, where each one matches and differs, and the interview questions to ask them.

Hiring a data analyst right now?

Send one link and read each report the moment they finish. The first five candidates are free, with no card.