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
Probe hands-on depth with SQL window functions, Spark or Flink jobs, dbt models, and orchestration in Airflow or Dagster; ask about partitioning and file formats like Parquet or Iceberg.
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
Names specific transformations they wrote, explains partition keys, cluster sizing, and why they chose Iceberg or Delta over plain Parquet.
02
Evaluation factor
Systems and trade-offs
25% weight
Ask how they chose batch versus streaming, handled late-arriving data and backfills, and sized warehouse spend in Snowflake, BigQuery, or Redshift.
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
Weighs freshness against cost with real numbers, describes idempotent backfills and schema evolution decisions they later had to live with.
03
Evaluation factor
Evidence and rigour
25% weight
Test data quality practice: Great Expectations or dbt tests, freshness SLAs, row count reconciliation, and how they traced a bad number back to source.
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
Cites concrete quality gates, alert thresholds, and a specific incident where lineage tooling isolated the broken upstream join.
04
Evaluation factor
Collaboration and communication
15% weight
Look for work with analysts, scientists, and source-system owners: contract negotiation on upstream schema changes, documenting models, and handling urgent requests for missing metrics.
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
Describes data contracts agreed with producers and documentation analysts actually used, without blaming stakeholders for messy requirements.
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.
