Health Catalyst Data Analytics Engineer interview questions

Hiring process involves initial interview with a recruiter, an online SQL assessment, then an on-site interview. You’ll interview with a technical expert and an analytics director. My tech expert was great, but the analytics director was clearly mentally checked out about 15 minutes in. The on-site interview is a 2 part process. First you’ll have a role playing case that the interviewers will ask you to walk through. You’ll be asked to use a whiteboard and walk through your thought process in designing a solution. KNOW YOUR SQL and don’t let the interviewers derail thought process. It happened to me. The second part was a more standard interview - tell me about yourself, projects you’ve worked on, tell me about a time you worked hard, etc. According to the recruiter my skills weren’t in alignment with salary target, despite the fact that I passed their assessment and they were “eager to bring me out.” Comp was discussed in the first conversation with the recruiter, and it sounded like we were in the same ballpark. It was only after the on-site interview that they decided I was too expensive. It was frustrating to take a day off for travel all for nothing. If sql skill is that important, the online assessment should be more difficult to match their expectation.