Technical screening questions
Ask for one example per question and listen for specifics.
- Write a query to find the second highest value per group. A good answer: Window functions such as ROW_NUMBER or DENSE_RANK.
- How do you validate a dashboard number? A good answer: Reconcile to source, check filters and joins.
- How do you handle missing or duplicate data? A good answer: Document assumptions and fix at the source where possible.
- Describe an analysis that changed a decision. A good answer: A clear question, method and business impact.
- How do you choose a chart for a message? A good answer: Match chart type to the comparison and audience.
Quick screening questions
Use these when you have only a few minutes.
- Show me a dashboard that changed a decision.
- How do you validate numbers before publishing?
- Which SQL window functions do you use most?
What separates the levels
Match the level to the requirement before you submit.
- Junior: builds reports from specs.
- Mid: owns metrics and analysis.
- Senior: frames questions and influences strategy.
Red flags
Any of these is a reason to probe further.
- Only built charts from provided extracts.
- Weak SQL joins.
- Cannot explain a metric definition.
Tools you should hear mentioned
A data analyst with real experience usually names several of these without prompting.
- SQL
- Excel
- Tableau or Power BI
- Python or R basics
- Google Analytics or similar
- Looker
Run the call well
Ask for the last project first, then dig into the second or third question. Take notes on versions, team size and outcomes, and record them with the submission so the vendor’s later technical interview does not surprise you.
Frequently asked questions
How long should a data analyst screening call take?
Fifteen to twenty minutes is enough to cover the project, three technical questions and availability, rate and work authorization.
Do recruiters need to know the technology?
Working vocabulary is enough. Use the sourcing guide for the role and listen for specifics instead of judging technical depth yourself.