Data analyst behavioural interview questions

As asked

Tell me about a time a stakeholder disagreed with what the data was telling them. How did you handle it?

Sample answer outline

Describe staying curious rather than defensive: understanding why the stakeholder expected a different result often surfaces a real data gap or a genuine context you missed. Walk through how you validated the figure together, separated emotion from evidence, and reached a shared understanding. The strong answer shows the relationship survived intact and the outcome was a better decision, not a won argument.

Expect these follow-ups

• What if it turned out the stakeholder was right and your data was wrong?
• How do you keep these conversations from becoming personal?
• How do you handle a stakeholder who only wants confirming data?

As asked

Describe a time you made an error in an analysis that other people relied on. What happened and what did you do?

Sample answer outline

Pick a real, specific error such as a wrong filter, a join fan-out, or a misread metric. Show that you owned it quickly, communicated the correction transparently to everyone affected, and assessed the impact of any decisions made on the bad number. End with the process change you put in place, such as peer review or an automated check, so the same class of mistake cannot recur.

Expect these follow-ups

• How did you tell the people who had acted on the wrong number?
• What check would have caught it earlier?
• How do you balance moving fast with avoiding these errors?

As asked

Describe a time you made a data backed recommendation and the business chose to ignore it. What did you do?

Sample answer outline

Show maturity rather than resentment. Explain whether the decision makers had context you lacked, such as strategy, timing, or risk appetite, and whether you communicated the recommendation in terms they cared about. Describe how you followed the outcome, whether your analysis was vindicated, and what you changed about how you influence. The interviewer wants ownership and a willingness to learn, not someone who was simply right and overruled.

Expect these follow-ups

• On reflection, was the business right to ignore it?
• How did you change how you present recommendations afterwards?
• How do you decide when to escalate versus let it go?

As asked

It is month end, three stakeholders each say their request is the priority, and you cannot do all of them today. How do you decide what to work on?

Sample answer outline

Make the prioritisation transparent: clarify the deadline and the decision each request feeds, weigh impact and reversibility, and surface trade offs to the requesters rather than silently picking. Look for quick wins or existing assets that satisfy a request cheaply, and communicate clear expectations on what will be late. The interviewer wants structured judgement and proactive communication, not heroics or silent overload.

Expect these follow-ups

• What do you do when two senior people both insist they are first?
• How do you say no to a request without damaging the relationship?
• How do you prevent this crunch from recurring every month?

As asked

Tell me about a time you needed another team to act on your analysis but had no authority over them. How did you get it done?

Sample answer outline

Show how you built credibility and framed the analysis around the other team's goals rather than your own. Describe bringing a clear, quantified case, anticipating objections, finding an internal champion, and making the recommended action easy to take. The strong answer demonstrates persuasion through evidence and relationships, and a concrete outcome where the other team changed what they did.

Expect these follow-ups

• What did you do when the first attempt did not land?
• How do you build credibility with a team that does not report to you?
• How do you tell the difference between resistance and a real objection?

As asked

Walk me through an analysis you owned from the vague question all the way to the decision it drove. What made it yours?

Sample answer outline

Describe taking an ambiguous request, scoping it into a sharp question, sourcing and validating the data, doing the analysis, and presenting a recommendation that landed. Highlight the judgement calls you made without being told and how you carried it through to impact. The interviewer is checking for genuine ownership rather than executing someone else's spec.

Expect these follow-ups

• Where did you have to push back on the original framing of the question?
• What would you do differently if you ran it again?
• How did you keep stakeholders aligned along the way?