Top 37
Prep plan
Updated weekly · Last refresh Oct 17

Health Catalyst Analytics Engineer Interview Questions

The questions to prepare for a Health Catalyst Analytics Engineer interview. Questions from real interview reports rank first. Updated daily.

37questions
~5htotal time
Track your progressSign up free to work through all 37 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 14 questions + 1 drill · ~131 min
SQL Query for Female PatientsEasy
Practice

Use a filtered COUNT query to return the number of female patients.

sql queriesAggregationsdata extractionHealth Catalyst
SQL Function for Diagnosis RecordingMedium

Tests SQL knowledge for patient event detection and time-based diagnosis tracking.

Health Catalyst
Writing SQL Code in PracticeMedium

Evaluates your ability to translate requirements into correct SQL logic.

sql queriessqlData ModelingHealth Catalyst
Most Recent Record With WindowsMedium

Assesses your ability to use window functions for deduping and recency logic.

Window FunctionsData AnalysissqlHealth Catalyst
Optimizing Slow or Complex QueriesMedium

Tests your query optimization approach and debugging methodology.

performancequery optimizationsqlHealth Catalyst
SQL Proficiency and PracticeMedium
Practice

Demonstrate SQL proficiency by summarizing completed consultant assignments, project counts, workload totals, and workload bands.

JoinsData Manipulationtechnical challengeHealth Catalyst
Employees Reporting to One ManagerEasy
Practice
Practice drill

Use a self-join to find all direct employees reporting to one Health Catalyst manager.

sqlHealth CatalystCatalistCatalyst Labs
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership22 questions · ~190 min
Using Analytics to Solve a ProblemMedium

Evaluates your ability to apply analytics to real problems and drive outcomes.

analyticsProblem SolvingHealth Catalyst
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~9 min
The finish line: interview-readyComplete all 37 questions plus 1 hands-on drill to finish this plan.