Data analyst interview questions, with a scoring guide
Turns business data into accurate reports and dashboards that help managers make decisions. Here are 19 questions for a data analyst interview. Each comes with a follow-up and a 1 to 5 scoring guide so you can compare candidates fairly.
Use these as a free interview guide
Writing the job ad too? Start from our data analyst job description template.
Questions specific to the data analyst role
Role-specific
Walk me through how you check a dataset before you trust it for a report.
1 WeakUses the data as-is.
3 SolidLooks for blanks and obvious errors.
5 StrongChecks row counts and totals against the source, duplicates, missing values, formats and outliers, and notes any limits in the report.
Role-specific
A manager says a number in your report doesn't match what they see in the accounting system. What do you do?
Follow-up: How do you explain the difference to them?
1 WeakInsists their number is wrong.
3 SolidRechecks their own query.
5 StrongCompares definitions, date ranges and filters, finds the exact difference, explains it plainly, and updates the metric definition so it's clear next time.
Role-specific
Tell me about a report you automated. What did it replace, and how did you make sure it stayed right?
1 WeakHasn't automated anything.
3 SolidBuilt a spreadsheet with formulas that still needs manual steps.
5 StrongReplaced a manual process using SQL, Power Query or similar, with built-in checks, documentation and a clear time saving.
Role-specific
A supervisor asks you to email them a spreadsheet of their team's hours and pay rates. How do you handle it?
1 WeakEmails the full file.
3 SolidSends it, but only to that supervisor.
5 StrongConfirms they're authorized, shares only what they need through a secure location rather than an attachment, and follows the privacy policy.
Behavioural questions by skill
Behavioural questions ask about something the person actually did. Past behaviour is a better guide than "what would you do" answers alone.
Attention to detail
Gets the small things right.
Tell me about a time you caught a mistake before it caused a problem.
Follow-up: How did you spot it?
1 WeakNo example.
3 SolidCaught one by chance.
5 StrongCaught it because of a habit or check they always do.
Walk me through how you check your own work before calling it done.
Follow-up: Has that check ever caught something?
1 WeakThey don't.
3 SolidA quick look over.
5 StrongA clear routine that fits the task.
Describe a task where getting the small details right really mattered.
Follow-up: What would have happened if they were wrong?
1 WeakCan't name one.
3 SolidNames one, but light on how.
5 StrongExplains the details, why they mattered, and how they got them right.
Problem solving
Works out the cause and fixes it properly.
Tell me about a problem at work that you solved without being told how.
Follow-up: How did you work out what was wrong?
1 WeakWaited to be told what to do.
3 SolidSolved it with a common fix.
5 StrongFound the cause and fixed it so it stayed fixed.
Describe a time something went wrong in the middle of a busy day. What did you do first?
Follow-up: Who did you tell, and when?
1 WeakPanicked or froze.
3 SolidCalled for help right away without trying anything.
5 StrongMade it safe, tried the obvious fixes, and escalated with clear information.
Tell me about a time you noticed a better way to do a routine task.
Follow-up: What happened when you raised it?
1 WeakNever looked for one.
3 SolidNoticed it but didn't act.
5 StrongSuggested or tested it and can describe the result.
Communication
Explains clearly and keeps people in the loop.
Tell me about a time you had to explain something complicated to someone who was new to it.
Follow-up: How did you know they understood?
1 WeakCan't explain clearly, even in the interview.
3 SolidExplained it but didn't check understanding.
5 StrongUsed plain words or examples and checked they got it.
Describe a time you had to give bad news to a customer, coworker or manager.
Follow-up: What did you say first?
1 WeakAvoided it or left it to someone else.
3 SolidDelivered it, but bluntly or late.
5 StrongDelivered it early and clearly, with a next step.
Tell me about a time a misunderstanding caused a problem at work. What did you learn?
Follow-up: What do you do differently now?
1 WeakBlames the other person entirely.
3 SolidFixed the issue with little reflection.
5 StrongFixed it and changed how they communicate, such as confirming in writing.
Honesty and integrity
Does the right thing, including when nobody's looking.
Tell me about a time you were asked to do something at work that you felt wasn't right.
Follow-up: What happened afterwards?
1 WeakDid it without question.
3 SolidDid it but felt uneasy.
5 StrongRaised it respectfully and did the right thing.
Describe a time you handled cash, stock or private information. How did you keep it secure?
Follow-up: Did anything ever go missing?
1 WeakVague answer.
3 SolidFollowed the basics.
5 StrongSpecific precautions and an example.
Tell me about a time you admitted you didn't know something.
Follow-up: What did you do next?
1 WeakNever has.
3 SolidAdmitted it when pressed.
5 StrongAdmitted it early and found the answer.
Organizing and time management
Plans the work and meets deadlines.
Walk me through how you plan a typical work day.
Follow-up: What do you do when the plan falls apart?
1 WeakNo plan.
3 SolidA loose plan.
5 StrongA clear system, such as a list or calendar, and how they adjust it.
Tell me about a time you had several deadlines at once.
Follow-up: How did you decide the order?
1 WeakMissed some without warning.
3 SolidMet them by working late.
5 StrongPrioritized, planned, and met them or flagged early.
Describe a system you use to keep track of tasks, orders or paperwork.
Follow-up: Show me how you'd use it on your first day here.
1 WeakNone.
3 SolidMostly memory.
5 StrongA reliable system with an example.
Prescreen questions for data analyst candidates
Ask these on a five-minute phone call or send them as a form before you book interviews.
- Are you legally entitled to work in Canada? (Yes / No)
- Which days and times are you available to work?
- When could you start?
- What pay are you looking for?
- What interests you about this job?
- How would you describe your SQL skills? (I regularly write queries with joins and grouping / Basic queries only / I haven't used SQL)
- Which reporting tools have you used (for example Excel, Power BI or Tableau)?
How to score the answers
- Ask every candidate the same questions in the same order. That's what makes scores comparable.
- Write down what they did, not your impression. "Closed alone on a Saturday and restocked for the morning" beats "seems reliable".
- Score each answer from 1 to 5 against the guide under the question. A 3 is a solid, acceptable answer.
- Average the scores and read the notes behind any big gap between interviewers.
- Check references on the areas where you're least sure.
Questions to avoid
In Canada, hiring questions should be about the job. Human rights laws protect people from being treated differently because of things like their age, family status, disability, religion, race, place of origin, sex, sexual orientation or gender identity. Stay away from questions like these:
- "How old are you?" or "When did you finish high school?"
- "Do you have kids?" or "Are you planning a family?"
- "Where are you from originally?" (You can ask: "Are you legally entitled to work in Canada?")
- "Do you have any health problems?" (You can ask: "This job involves [a real duty]. Can you do that, with or without accommodation?")
This is general information, not legal advice. Rules vary by province.
Questions
What should I ask in a data analyst interview?
Ask about the parts of the job that matter most: attention to detail, problem solving, communication, honesty and integrity, plus role-specific questions such as "Walk me through how you check a dataset before you trust it for a report." Ask every candidate the same questions so you can compare them fairly.
How do I score a data analyst interview?
Score each answer from 1 to 5 against a short guide that describes a weak, solid and strong answer. Score what the person actually did in their example, not how confident they sounded. Then average the scores and read the notes behind any big differences.
What should I ask before interviewing a data analyst?
Use a short prescreen: work eligibility, availability, start date, pay expectations and the must-haves for the role, such as "How would you describe your SQL skills?"
Turn this page into a ready-to-use interview guide
Staffkin builds a data analyst prescreen and interview guide in one click, gives you a fillable PDF, and lets you score candidates side by side. Free for your first job.
Start freeRelated roles