picked.ai/hire/bi-analyst/interview-questions
30 bi analyst
interview questions that actually work.
Pulled from the Neuroworx item bank: nine years of calibration against twelve-month performance outcomes on 14,083 bi 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
ScreenRole-fitOn-siteAnti-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 dashboard you shipped that got used.
scope
Listen for
A specific dashboard, a specific audience, the decision it shaped. How they knew it was being used.
Ignore
A list of tools. Looker vs Tableau is downstream.
catches · Candidates whose only evidence is the dashboard URL.
02
Tell me about a dashboard you killed.
restraint
Listen for
A specific dashboard. Why it was the wrong answer. Who they had to convince to let it go.
Ignore
"We had too many dashboards." Generic.
catches · Candidates who have never killed one.
03
A stakeholder asks for a new dashboard for a question the last one half-answers. What do you do?
stakeholder management
Listen for
A real conversation. The question behind the question. They sometimes say no.
Ignore
"I always build what the stakeholder asks for." Suspicious.
catches · Candidates whose default is to build.
04
Describe a metric definition fight you have been in.
stakeholder managementhonesty
Listen for
A real disagreement (revenue net of refunds, active vs logged in, billable vs paid). How it resolved. Who owns the definition now.
Ignore
"We have a metric dictionary." Has not always been used.
catches · Candidates who never noticed the fight.
05
Pick a SQL query in your last codebase you would rewrite. Why?
SQL
Listen for
A real query. The actual smell. What they would change.
Ignore
Style preferences.
catches · Candidates who treat SQL as write-only.
06
Tell me about the dashboard graveyard at your last company. What did you do about it?
restraint
Listen for
A real cleanup. The decision about what to keep. How they got buy-in.
Ignore
"We have too many dashboards" without a cleanup.
catches · Candidates who have never tried.
07
Walk me through a data model refactor you have led or watched.
modelling
Listen for
A specific change (grain change, conformed dimension, slowly-changing). What broke first. What they would do differently.
Ignore
A pure theory answer.
catches · Candidates who do not know what grain their tables live at.
08
How do you onboard onto a new BI codebase?
generality
Listen for
A sequence. Find the most-viewed dashboards, find the most-edited models, find the analyst nobody asks anymore.
Ignore
"I read the docs first."
catches · Candidates who freeze without a tutorial.
09
What is one BI tool habit you stopped doing in the last year?
self-instrumentation
Listen for
A specific habit. A specific reason.
Ignore
Performative answers.
catches · Candidates without self-instrumentation.
10
One thing you want from the next role you would not have applied for if not.
stage fit
Listen for
A specific something. A specific kind of business.
Ignore
"Impact." Vague.
catches · Candidates 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 real stakeholder ask: "build me a dashboard for marketing performance". Write the three questions you would ask before opening Looker.
question-shapingIC1+
Listen for
Questions that surface the real decision. They are willing to push back.
Ignore
Three questions about the data source.
catches · Candidates who say yes to the literal ask.
02
Here is one of our existing dashboards. Critique it in 200 words.
tasteIC2+
Listen for
A real critique. Substance, not styling. The one change that would move it most.
Ignore
A list of cosmetic fixes.
catches · Candidates without an eye.
03
Refactor this 100-line SQL query that lives behind one of our dashboards. Tell me what you changed in three bullets.
SQLIC1+
Listen for
Readability, performance, naming. They notice the silent filter.
Ignore
Stylistic shortenings.
catches · Candidates who refactor without thinking about the next reader.
04
Draft the metric definition for "active customer" given this set of edge cases.
modellingIC2+
Listen for
A definition that handles the edge case head-on. They name what they exclude and why.
Ignore
A definition that pretends the edge case does not exist.
catches · Candidates who write definitions that fall apart on month-end.
05
A senior stakeholder demands a daily-refreshed dashboard. Make the case for and against in 100 words each.
restraintIC2+
Listen for
A real case both ways. Their actual recommendation.
Ignore
A pure no or a pure yes.
catches · Candidates who default to building.
06
Sketch a conformed-dimension change you would make to a data model with five misaligned customer tables.
modellingIC3+
Listen for
A real plan. Migration order, dual-running, the dashboards that break. The conversation they would have.
Ignore
A blueprint with no migration path.
catches · Candidates who design the model and forget the rollout.
07
Pick one chart from our last board pack. Tell me what is wrong with it.
commsIC2+
Listen for
A real critique. Encoding, axis, comparison. What they would draw instead.
Ignore
Style fixes.
catches · Candidates without an eye.
08
In 200 words: why might your approach to the dashboard graveyard cleanup be the wrong one?
humilityIC3+
Listen for
A real engagement with the alternative. The risk they take by deleting.
Ignore
A second pitch for the original plan.
catches · Candidates who cannot question their own approach.
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 BI work, do you want to grow most this year?
growth
Listen for
A specific gap. A plan. A name of someone they would learn from.
Ignore
"I want to be a head of BI." Title-laddering.
catches · Candidates without a learning agenda.
02
Tell me about a time you disagreed with a stakeholder on whether to build a dashboard.
authority
Listen for
A real disagreement. The mechanics. How it resolved.
Ignore
"I always defer to the business."
catches · Candidates who cannot say no.
03
What is the most uncomfortable feedback you have had on a dashboard?
self-awareness
Listen for
A specific piece. The change they made.
Ignore
"I take feedback well."
catches · Defended self-narrative.
04
Walk me through a dashboard build you wish you had killed earlier.
judgement
Listen for
A specific moment they could have called it.
Ignore
A pitch for the dashboard being secretly worth it.
catches · Sunk-cost BI.
05
What is a strong opinion you have changed recently about data modelling?
intellectual humility
Listen for
A specific opinion. A specific reason.
Ignore
"My mind is always open."
catches · Closed-loop thinkers.
06
Pick two BI analysts you admire. What do they do differently?
taste
Listen for
Concrete habits. Habits adopted. Habits not.
Ignore
Pure praise.
catches · Candidates without taste for other BI 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 · Candidates 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 · Candidates without self-instrumentation.
09
Where would you rather be in three years?
careerretention
Listen for
A direction (IC craft vs leading BI) and a reason.
Ignore
"Wherever the company needs me."
catches · Drifting candidates.
10
If you join, what would you want to spend your first week doing?
agencyonboarding
Listen for
A specific plan. Often: audit dashboard usage, sit with three stakeholders, find the most-edited model.
Ignore
"Whatever you suggest."
catches · Candidates without onboarding instinct.
11
What is the thing that would make you leave us within six months?
dealbreaker
Listen for
A specific irritant.
Ignore
"As long as the work is good."
catches · Hidden dealbreakers.
12
What would you want to ask our most heavily-burned stakeholder?
probingcuriosity
Listen for
A real question. "Which dashboard do you open and then close?"
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.
BI analyst interview questions · Picked.ai