
Health Catalyst Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 19 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Health Catalyst.
Data Engineer
I had a phone interview with HR first, then a screening interview with the hiring manager. After that, I traveled to Salt Lake City, Utah, for an in-person interview where I met with several hiring managers.
- Could you sketch some ERD diagrams on a white-board that show the data relationships between tables for a fictional company?
Data Analytics Engineer
The hiring process starts with a recruiter call, followed by an online SQL test, and then an on-site interview. The on-site consists of two parts: a role-playing case where you use a whiteboard to explain your solution design and thought process, and a more traditional interview covering your background, projects, and experiences like 'tell me about a time you worked hard'. I was told my skills didn't align with the salary target after passing the assessment and hearing they were eager to bring me in, which was frustrating as compensation was discussed early on. It felt like a waste of a day off.
- Can you share an instance where you put in significant effort?
- Tell me about yourself.
- Describe some projects you have worked on.
Analytics Engineer
The interview started with an HR call, then a technical skills test, and finally an in-person interview. The technical test involved a SQL assessment where I was given a physical diagram and asked to write queries for certain questions. During the 1:1 meeting, I was presented with a business scenario and tasked with designing an ERD and writing a query that used inner joins on three database tables.
- Can you explain your interest in Health Catalyst?
- What aspects of a work environment tend to frustrate you?
- Describe your approach to working with stakeholders.
Health Catalyst Data Engineer Interview Questions
Quoted word for word from Health Catalyst interview reports.
“What SQL function would be used to determine if and when a patient had a specific diagnosis recorded?”
Read reports →“How would you select the count of female patients from the database?”
Read reports →“Can you define what being hardworking means to you?”
Read reports →“Could you sketch some ERD diagrams on a white-board that show the data relationships between tables for a fictional company?”
Read reports →“Can you share an instance where providing feedback was unsuccessful?”
Read report →“What's something a coworker might do that would annoy you, and how would you handle it?”
Read report →“How do you deal with difficult people?”
Read report →“How do you deal with stakeholders?”
Read report →“What about the work environment gets under your skin?”
Read report →Formats, difficulty and experience
Across all 19 Health Catalyst interview reports.