Decision Matrix — Structured Interview Scorecard
An anonymised structured-interview scorecard for a senior data engineer: seven competencies in two groups scored on a 1–5 rubric, with the coding exercise and data-quality testing as must-haves. Candidate D's 2 on the coding exercise ends their process; Candidate C ranks first at 3.95, only 0.10 ahead of Candidate B — a fragile lead that flips if system design's weight rises from 20% to 23.8%. Illustrative values.
Make it your own.
title "Senior data engineer — structured interview scorecard"
subtitle "Each competency scored independently by its interviewer before the debrief · 1–5 rubric"
note "Illustrative scores for fictional, anonymised candidates."
note "Two competencies are must-haves: a 2 on either ends the process, however strong the rest."
options "Candidate A" | "Candidate B" | "Candidate C" | "Candidate D"
group "Technical"
"System design interview" weight 20 : 4 5 3 4
"Data modelling & SQL" weight 15 : 5 4 4 3
"Pipeline coding exercise" weight 15 must >= 3 : 4 4 5 2
"Data quality & testing" weight 10 must >= 3 : 3 4 4 4
group "Ways of working"
"Communication" weight 15 : 4 3 4 5
"Ownership & collaboration" weight 15 : 3 4 4 4
"Mentoring others" weight 10 : 3 2 4 4