There was an initial short call from the CTO, then a ~30 minute call from the data engineer. After that was a 60-90 minute test from HackerRank, and then an on-site 3-4 hour interview. The on-site interview was 4 parts - first was technical whiteboard questions with a 4 person interviewing team - a couple SQL questions, a couple general questions to write in pseudo-code. Next was a short meeting with the CTO, then the head of culture. The last meeting was with the VP of Engineering with a few more technical questions.

Applied online. First was a 30 min phone screen, then a take home technical coding challenge with some SQL. If pass, go on-site for some more technical challenges with whiteboarding and some cultural aspects.