I applied online. The process took 4 weeks. I interviewed at Strava in Aug 2023
Interview
Overall the process was over 5 stages and one can expect to dedicate a total of 5 1/2 hours to all the interview stages. The first stage consists of a HackerRank SQL test asking advanced techniques such as self joins and unions. If successful, you will be invited to an interview with a member of the people team to discuss your motivation, experience and some situational questions. If there is a fit, you will progress to an interview with the Hiring Manager, to discuss the role and conduct a case study related to the onboarding journey for Strava. The next stage is a live SQL test (a bit redundant to the HackerRank assessment) where you will go through 4 SQL questions with increasing difficulty. If successful with this stage, you will progress to a panel interview where you will do another more in-depth case study with members of the analytical team, followed by a design and product interview.
Interview questions [1]
Question 1
How would you priortize opportunties? How would you assess the impact of X product decision for the PM? Given this graph, what is you hypothesis on the trend?
Recruiter screen, hiring manager screen, technical (SQL) screen, then move to final round with 3 additional interviews (technical, product, and collaboration). Overall, it was quite a long process that took 2+ months.