Health Catalyst logo

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

2.6 Rounds average
Average Typical difficulty
78.9% Positive experience

Candidate interview experiences

First-hand accounts from people who interviewed at Health Catalyst.

Showing 3 of 19
Health Catalyst logo
Health Catalyst

Data Engineer

Engineering · a year ago

Senior Average Positive experience Accept offer 3 rounds
Interview process
Recruiter call Phone screen Onsite
Interview formats
Technical Coding

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.

Confirmed questions1 question
  • Could you sketch some ERD diagrams on a white-board that show the data relationships between tables for a fictional company?
Health Catalyst logo
Health Catalyst

Data Analytics Engineer

Analytics

Mid Difficult Negative experience No offer 3 rounds
Interview process
Recruiter call Technical screen Onsite Offer
Interview formats
Coding Case Behavioral

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.

Confirmed questions5 questions
  • Can you share an instance where you put in significant effort?
  • Tell me about yourself.
  • Describe some projects you have worked on.
Health Catalyst logo
Health Catalyst

Analytics Engineer

Analytics

Entry Easy Positive experience No offer 3 rounds
Interview process
Recruiter call Technical screen Onsite
Interview formats
Technical Coding Behavioral

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.

Confirmed questions7 questions
  • 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

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

Formats, difficulty and experience

Across all 19 Health Catalyst interview reports.

Interview formats

Technical 32.7%
Behavioral 26.9%
Coding 25%
Presentation 5.8%
Case 5.8%

Interview difficulty

Easy 15.8%
Average 73.7%
Difficult 10.5%

Candidate experience

Negative 21.1%
Positive 78.9%