Capital One·Data Scientist·Technical Phone Screen
Jun 2026
Capital One data scientist interview, SQL-heavy technical screen. One big multi-part query question that covered joins, window logic, conditional aggregation, and nulls all at once. Felt like a take-home but it was live.
- Write a single SQL query or CTE pipeline across a students/classes/exams/scores schema that: filters to exams in calendar year 2024, creates an adjusted score (NULL if below 60, else the raw score), fills NULLs with zero for display and averaging, and aggregates per class to get pass count, fail count, honors student count, average adjusted score, and distinct exam count. Students with no scores must still appear via LEFT JOIN, and results should be ordered by class name.
“This one had a lot of moving parts and I kept second-guessing the LEFT JOIN placement.” The rest of the author's notes on Data Scientist interview at Capital One, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post