I applied online. I interviewed at Health Catalyst in Oct 2024
Average interview
Application
I interviewed at Health Catalyst
Interview
They really seem to only care about your SQL skills. Every interview had questions about it, along with a specific SQL take home test. The job description makes it seem like the position is much more than just SQL, but the interview makes it seem like all you will be is a SQL analyst.
Interview questions [1]
Question 1
What SQL function will you use to see if and when a specific diagnosis was recorded for a patient?
The initial interview was with HR. I was asked to schedule a day and time that fit my schedule, which was great. During the call, they were up front with the level of the role and the pay-range for it so that no one's time was wasted. I appreciated that a lot. The interview was very casual and focused on the role, team, and client it was with. After that discussion, I was asked to complete a SQL test at my convenience and to let them know when I was done. A few days later I was asked to interview with a couple of the team members. This was much more of a traditional interview, but via Zoom, and was told to allow for 50-60 minutes. I was asked a lot of question about my background and experience and was given the opportunity to ask as many questions as I had. I was a very pleasurable experience from start to finish.
I applied online. I interviewed at Health Catalyst
Interview
First round with HR was great. My contact had a depth of knowledge about the position that most HR contacts don't have. Followup steps were well-defined, which is also nice.
I applied through an employee referral. I interviewed at Health Catalyst
Interview
Very good. Initial phone call with basic availability questions followed by a technical round + behavioral round. The technical interview is like a role play where you will get a business case and solution to write an SQL query