picked.
Log inPost a role
picked.ai/hire/data-analyst/interview-questions
30 data analyst
interview questions that actually work.
Pulled from the Neuroworx item bank: nine years of calibration against twelve-month performance outcomes on 14,083 data analysts. Sorted by stage (screen, assessment, on-site) and level (IC1 to IC5). Each question comes with what to listen for, what to ignore, and the failure mode it is designed to catch.
30
questions
4
stages
5
levels
14k
hires of validity data
Screen ↓Role-fit ↓On-site ↓Anti-pattern questions ↓
Stage 01 · Screen
Twelve minutes. Ten questions.
The screening conversation. Picked runs this with an AI voice; this is what a human screen would look like with the same rubric. Time-box hard. 60 seconds per answer.
10 questions
01
Walk me through the last analysis you ran end-to-end. Question to recommendation.
scopespecificity
Listen for
A specific stakeholder, a specific question, the moment the data refused to answer cleanly and what they did about it.
Ignore
A list of tools. The stack is downstream of the question.
catches · Analysts who can describe the dashboard but not the decision it changed.
02
Tell me about a question a stakeholder asked you that you reshaped before answering.
question-shaping
Listen for
A real ask, a clean reframe, the conversation where they pushed back. They named what the stakeholder actually needed.
Ignore
"I always clarify requirements." We want the specific reshape.
catches · Analysts who answer the question on the ticket.
03
Describe a time you had to tell a leader "the data does not say that".
honesty
Listen for
A specific moment. The leader, the claim, what they said instead. How the leader took it.
Ignore
"I always speak truth to power" platitudes.
catches · Analysts who soften the answer until it agrees with the room.
04
What is a metric your last team relied on that you think was wrong, and why?
judgementtaste
Listen for
A specific metric. A clear reason. Whether they tried to change it and what happened.
Ignore
"Vanity metrics are bad." Generic.
catches · Analysts who cannot hold an opinion on what they measure.
05
Pick an SQL query in your last codebase you would rewrite. Why?
craft
Listen for
A real query. The actual smell (cartesian join, hidden filter, untrusted source). What they would do instead.
Ignore
Style preferences. CTE-vs-subquery does not move the world.
catches · Analysts who treat SQL as write-only.
06
Tell me about a dashboard you killed.
restraint
Listen for
A specific dashboard. Why it was the wrong answer. Who they had to convince.
Ignore
"We do not need so many dashboards." Generic.
catches · Analysts whose only output is more dashboards.
07
When was the last time a query you wrote returned a result that surprised you?
curiosity
Listen for
A specific number. The hour they spent figuring out why. What they did with the answer.
Ignore
Stories with no surprise. Often a sign nobody checks anything.
catches · Analysts who never get surprised by their own queries.
08
Walk me through how you would estimate the daily active users of an app you have never seen.
numerical judgement
Listen for
Stated assumptions, rough magnitudes, a number they would defend in a meeting.
Ignore
Refusal to estimate without data. The estimate is the test.
catches · Analysts who cannot reason without a query window.
09
How do you onboard onto a new data warehouse?
generality
Listen for
A sequence. Find the source of truth, find the most-queried tables, find the analyst nobody asks anymore, ask one stupid question.
Ignore
"I read the data dictionary." Rarely the right first move.
catches · Analysts who freeze without documentation.
10
One thing you want from the next role you would not have applied for if not.
stage fitseriousness
Listen for
A specific something. A specific kind of decision-maker. A specific company shape.
Ignore
"Impact". "Ownership". Vague.
catches · Analysts unsure why they are looking.
Stage 02 · Role-fit assessment
A scoped task. A scored rubric.
One realistic task. We score the writeup, not the polish. The candidate has the take-home equivalent of 60 minutes.
8 questions
01
Here is a one-paragraph ask from a CMO: "tell me which channels are working". You have one day. Write the question you will actually answer and the three cuts you will run.
question-shapingIC2+
Listen for
A sharper question. Three cuts that earn their place. They name what they will not do this round.
Ignore
A plan to run twenty cuts. We want restraint.
catches · Analysts who answer the literal ask.
02
Here is a sample of our event data with a known anomaly. Find it, write the post-mortem in three paragraphs.
craftIC2+
Listen for
How they reach the anomaly. What they ruled out first. A clean writeup that names the cause and the fix.
Ignore
Lengthy writeups. Three paragraphs means three paragraphs.
catches · Analysts who cannot tell signal from logging noise.
03
Refactor this 120-line SQL query. Tell me what you changed and why in three bullets.
SQLIC1+
Listen for
Real readability gains. A naming pass. They notice the silent filter.
Ignore
A rewrite that does the same thing in fewer characters.
catches · Analysts who clean for the look, not for the next reader.
04
Write the one-paragraph summary you would send the CEO after running the analysis from question 1.
commsIC2+
Listen for
A paragraph the CEO will read. A single recommendation. Honesty about what the data does not tell you.
Ignore
Five-paragraph emails with three asks.
catches · Analysts who cannot edit themselves down.
05
Pick one chart from the brief we sent and tell me what is wrong with it.
taste
Listen for
A real critique. The axis, the encoding, the comparison. What they would draw instead.
Ignore
A list of style fixes. We want the substantive one.
catches · Analysts without an eye.
06
A stakeholder asks for a daily-refreshed dashboard. Make the case for and against in 100 words each.
restraintIC2+
Listen for
A real case both ways. Cost, signal, the noise a daily refresh introduces. Their actual recommendation.
Ignore
A pure no. A pure yes. The exercise is the both-sides.
catches · Analysts who default to building.
07
Estimate the conversion rate of our signup funnel from the three numbers we will give you. Show your working.
numerical judgementIC2+
Listen for
A back-of-envelope. They name the assumption that matters most. They notice when the answer is off.
Ignore
A spreadsheet. We are measuring the head, not the keyboard.
catches · Analysts who cannot operate without a query window.
08
In 200 words: why might your answer to question 1 be wrong?
humilityIC3+
Listen for
A real engagement with the alternative cut. The bias they did not control for. The data they wish they had.
Ignore
A second pitch for the original answer.
catches · Analysts who cannot question their own work.
Stage 03 · On-site (after Picked)
Twelve questions you will still want to ask in person.
Picked screens, scores, and shortlists. These are the questions worth asking with a human in the room: the calibration questions, the dealbreakers, the chemistry probes.
12 questions
01
Where, in the work, do you want to grow most this year?
growth
Listen for
A specific gap. A plan, even tentative. A name of someone they would learn from.
Ignore
"I want to be a senior analyst." Title-laddering.
catches · Analysts without a learning agenda.
02
Tell me about a time you disagreed with a stakeholder on the metric definition.
authority
Listen for
A real disagreement. The mechanics, not the moral. How it resolved.
Ignore
"I always defer to the business." Suspicious.
catches · Analysts who cannot hold a definition under pressure.
03
What is the most uncomfortable feedback you have had on a piece of analysis?
self-awareness
Listen for
A specific piece of feedback. The change they made. The thing they still get wrong.
Ignore
"I take feedback well."
catches · Defended self-narrative.
04
Walk me through an analysis you wish you had killed earlier.
judgement
Listen for
A specific moment they could have called it. What stopped them.
Ignore
A pitch for the analysis being secretly worth it.
catches · Sunk-cost analysts.
05
What is a strong opinion you have recently changed about metrics?
intellectual humility
Listen for
A specific opinion. A specific reason. They name the person or paper that moved them.
Ignore
"My mind is always open."
catches · Closed-loop thinkers.
06
Pick two analysts you admire from your last role. What do they do differently?
taste
Listen for
Concrete habits. Habits adopted. Habits not yet adopted.
Ignore
Pure praise.
catches · Analysts without taste for other analysts.
07
Tell me the last technical thing you read outside your job.
curiosity
Listen for
A specific blog, paper, talk. What they thought of it.
Ignore
A textbook they always mean to get to.
catches · Analysts who do not read.
08
When are you most productive?
operating model
Listen for
A specific time-of-day. A self-aware answer about energy.
Ignore
"I am always productive."
catches · Analysts without self-instrumentation.
09
Where would you rather be in three years?
careerretention
Listen for
A direction (deeper IC vs analytics leadership) and a reason.
Ignore
"Wherever the company needs me."
catches · Drifting analysts.
10
If you join, what would you want to spend your first week doing?
agencyonboarding
Listen for
A specific plan. Often: shadow the CFO meeting, read the last five analyses, find the most-queried table.
Ignore
"Whatever you suggest."
catches · Analysts without an onboarding instinct.
11
What is the thing that would make you leave us within six months?
dealbreaker
Listen for
A specific irritant. A specific manager pattern.
Ignore
"As long as the work is good."
catches · Hidden dealbreakers, surfaced post-offer.
12
What would you want to ask our most cynical analyst?
probingcuriosity
Listen for
A real question, usually about a quiet thing. "Which metric do you trust least?"
Ignore
A softball.
catches · Candidates who do not want to know what is wrong.
The anti-pattern set
Eight questions that look smart
but tell you nothing.
"What is your biggest weakness?"
You will get a strength-shaped weakness. We have asked this 47,000 times. It catches no-one. Replace with: "What is the most uncomfortable feedback you have received?".
"Where do you see yourself in five years?"
Either a rehearsed answer or a stalled one. Both useless. Replace with: "Where would you want to be in three years?"
"Tell me about yourself."
Wastes the first three minutes on the CV they already gave you. Replace with: "Walk me through the most recent thing you shipped end-to-end."
"Why this company?"
Generates polished mission-talk. Replace with: "What about this role made you apply that would not have made you apply elsewhere?"
"Are you a team player?"
No-one says no. Replace with: "Tell me about a time a teammate disagreed with you and how you handled it."
"How do you handle stress?"
No-one says badly. Replace with: "Tell me about your last production incident and your precise role."
"How would you reverse a linked list?"
Probes nothing we care about. We removed it from the bank in 2019. Replace with: "Refactor this 200-line file and tell me what you changed and why."
"If you were an animal, which animal would you be?"
You know what we are going to say. Replace with: anything else.
Or, let us ask
We will ask these for you.
By Friday.
Picked runs the screen, the assessment, and the first-round interview against this exact item bank. You meet the three finalists in person, with these on-site questions in hand.
$0.99 per AI-vetted candidate. First 50 free.
Companion pages
picked.
The AI-native replacement for inbound hiring. For the hiring manager, not HR.
© 2026 Picked · Made in London · Three finalists in forty-eight hours.
Data analyst interview questions · Picked.ai