Top 35
Prep plan
Updated weekly · Last refresh Oct 17

Catalist Analytics Engineer Interview Questions

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

35questions
~5htotal time
Track your progressSign up free to work through all 35 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 18 questions + 3 drills · ~174 min
SQL Function for Diagnosis RecordingMedium

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

Catalist
Writing SQL Code Under ConstraintsMedium

Assesses your ability to translate requirements into correct, executable SQL.

CodingsqlCatalist
SQL and Data Modeling PracticeMedium

Assesses your end-to-end thinking across modeling and SQL query construction.

sqlData ModelingCatalist
Scoping Requests Beyond the SchemaMedium

Assesses requirements scoping and your approach to extending data models safely.

Stakeholder Managementdata visualizationimplementationCatalist
Filtering Patients by GenderEasy

Tests your ability to write basic SQL filters correctly for patient cohort selection.

sql queriesCatalist
Returning Multiple Rows in One QueryMedium

Assesses your ability to structure SQL to produce the correct row-level results.

sql queryCatalist
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
Professor-Course Cross-Department QueryEasy
Practice
Practice drill

Use joins, inequality filtering, and DISTINCT to find professors teaching courses outside their departments.

JoinssqlCatalist
SQL Joins and Conditional AggregationsHard
Practice
Practice drill

Use multiple joins and conditional aggregation to summarize completed, positive, and total outreach activity by Catalist campaign.

Joinssql queryAggregationsCatalistJ.P. Morgan
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
2
Behavioral & Leadership17 questions · ~136 min
Handling Irritating Coworker BehaviorsMedium

Assesses conflict management and professionalism when dealing with frustrating work behaviors.

Conflict ResolutionCatalist
Handling AdversityMedium

Assesses resilience and problem-solving under pressure or setbacks.

resilienceCatalist
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 35 questions plus 3 hands-on drills to finish this plan.