I got a little caught off guard because I was expecting only 25% coding but it was like 75% SQL coding (5-6 questions related to a business case) followed by a full research design of an A/B experiment. All of this was expected to be complete in 40 minutes so you need to be able to work really fast.
Interview questions [1]
Question 1
One SQL problem required calculating correlation from scratch using SQL, was not expecting that.
Started with a recruiter/screening round and then moved into the full loop. The full loop had four rounds focused on analytical execution, analytical reasoning, technical skills, and behavioral. SQL was a major part of the process, along with product metrics, experiments, stats, and communication. The process was structured but still challenging because the questions were open-ended and required clear thinking, not just memorized answers.
Recruiter screening then 1 hr technical screen on sql and business case. The interviews were focused heavily on product thinking: defining clear success metrics, interpreting metric trade-offs, and designing solid experiments. The SQL portion was straightforward but expected clean logic and structured thinking. The case rounds really test how well you connect metrics to real business impact.