software datadata governancedata modellinglakehousemaster data management
Complete evaluation framework
What to assess and how to score it
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 depth in dimensional and 3NF modelling, Data Vault, and platforms like Snowflake, Databricks, or Synapse; ask which catalogue and lineage tools they configured (Collibra, Purview, Alation).
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 concrete modelling patterns and platform internals, explaining why they chose Data Vault over star schema on a specific domain.
02
Evaluation factor
Systems and trade-offs
25% weight
Probe target-state architecture decisions: batch versus streaming, lakehouse versus warehouse, MDM hub style, and how they handled cost, latency, and vendor lock-in constraints.
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
Walks through a reference architecture they authored, naming rejected options and the cost or latency numbers behind each trade-off.
03
Evaluation factor
Evidence and rigour
25% weight
Assess how they proved architecture worked: data quality SLAs, reconciliation results, query performance benchmarks, GDPR or BCBS 239 lineage evidence presented to governance boards.
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 measured outcomes such as reduced pipeline runtime, quality rule pass rates, or audit findings closed after their design landed.
04
Evaluation factor
Collaboration and communication
15% weight
Look for evidence of aligning engineers, data stewards, and business owners: architecture review boards, standards documents adopted, and pushback handled from teams wanting to bypass the model.
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 running design authority forums and winning adoption of standards without formal authority, with named stakeholder groups and outcomes.
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.
