Review the evidence signals before interviewing. Then use the anchored descriptions—not instinct alone—to choose the score that best matches each answer.
01
Evaluation factor
Technical proficiency
35% weight
Test SQL depth beyond joins: window functions, CTEs, query plans, incremental models in dbt, plus DAX or MDX measures and semantic layer design in Power BI, Tableau or Looker.
Evidence to listen for
Command of the languages, frameworks, and data tools the role actually uses
Understands correctness, performance, and failure modes, not just syntax
Has opinions on testing and can justify them
Reads and reasons about code they did not write
Five-point scoring guide
1
Poor
Cannot work independently; fundamentals are missing.
2
Needs Improvement
Weak fundamentals; output needs heavy review.
3
Satisfactory
Competent for the role; needs guidance on complex or unfamiliar work.
4
Very Good
Strong practitioner; handles hard problems with little guidance.
5
Excellent
Writes tuned SQL against warehouses like Snowflake or BigQuery, explains star schema grain choices, and debugs DAX filter context fluently.
02
Evaluation factor
Systems and trade-offs
25% weight
Probe how they chose between wide denormalised tables, aggregate extracts and live connections, and what they did about slow dashboards, row-level security and cost per query.
Evidence to listen for
Reasons about scale, latency, cost, and failure before writing code
Names the trade-off they chose and what they gave up
Understands the data lifecycle end to end
Anticipates what breaks at ten times the volume
Five-point scoring guide
1
Poor
No thinking beyond the immediate task; no awareness of scale or failure.
2
Needs Improvement
Limited architectural awareness; struggles with design decisions.
3
Satisfactory
Works within an existing design; makes sound local decisions.
4
Very Good
Designs for scale and maintainability; articulates trade-offs clearly.
5
Excellent
Names a concrete trade-off, for example moving from direct query to imported aggregates, with the refresh and cost consequences they accepted.
03
Evaluation factor
Evidence and rigour
25% weight
Assess how they validate numbers: reconciliation against source systems, unit tests on models, data quality checks, and what happened when finance disputed a reported figure.
Evidence to listen for
Validates results rather than trusting output
Knows how their work is measured and what a bad result looks like
Can describe a time their own analysis or model was wrong and how they caught it
Careful about data quality, leakage, and silent failure
Five-point scoring guide
1
Poor
Ships unvalidated work; no notion of how correctness is checked.
2
Needs Improvement
Validates superficially; misses obvious quality or leakage issues.
3
Satisfactory
Reasonable checks in place; rigour drops under time pressure.
4
Very Good
Validates thoroughly; can name a real error they caught in their own work.
5
Excellent
Describes reconciliation routines and tests that caught discrepancies before stakeholders did, with named checks and the defect they prevented.
04
Evaluation factor
Collaboration and communication
15% weight
Look for evidence of requirements gathering with non-technical users: metric definition workshops, dashboard adoption rates, documentation in a data catalogue, and training or handover to analysts.
Evidence to listen for
Explains technical work to non-technical stakeholders
Gives and takes code or peer review constructively
Documents enough that the work survives their absence
Aligns with team process rather than working around it
Five-point scoring guide
1
Poor
Cannot work in a team; resistant to feedback.
2
Needs Improvement
Communication issues create rework; lone-wolf tendencies.
3
Satisfactory
Adequate team member; documentation and review participation are light.
4
Very Good
Communicates well; reliable reviewer and collaborator.
5
Excellent
Shows dashboards people actually use, agreed metric definitions written down, and a habit of pushing back on vague reporting requests.
Put this rubric to work
Score every candidate against the same standard
Add these weighted factors to Hirevire and let AI evaluate recorded answers against your rubric.
