The process took about 3 weeks: Recruiter Screen → Technical Screen → HM → Take-home Presentation → 1:1
The Technical Screen was about 1 hour.
SQL: 3 questions, all related to streaming data. They covered aggregation, join, date filtering, and window function / cumulative sum. The difficulty was not especially high.
Python/Pandas: data filtering plus creating a new column based on a condition. Pretty basic.
Stats: A/B testing. They give you alpha and a p-value and ask you to explain the result. It is not just the technical interpretation; they also ask how you would explain it to a PM / business stakeholder, and what you would do next.
The HM round was mainly a deep dive into my previous projects. They asked about experimentation, attribution, and quasi-experiment / causal inference, and we also talked about cross-platform experiments and product/business thinking.
For the take-home I was given 5 business days to prepare, and then I gave a panel presentation. My personal feeling is that this round puts a lot of weight on storytelling: it is not only whether the analysis is correct, you also have to be able to explain your conclusions clearly.
I made it all the way to the 1:1 round and was rejected afterwards. They did not give any specific feedback, only said that in the end they wanted someone with more experience.
Overall, the SQL/Python was not hard. The focus is still experimentation + product sense + communication.
Discussion
Loading comments…