4-5 stage interview process. - First you speak with an HR and the question often centers around your experience and what you have done relevant to the role. Typically, she will want to understand solutions or problems you have solved and the role it pertains. - Next is a technical oral interview with the person you will be reporting to if employed. She will typcially ask questions to test your understanding and knowledge of basic statistics as it pertains to product analysis, in my case specifically around A/B testing. - Next is another interview with another Lead that goes deeper into understanding of A/B tests, scenario based A/B question tests from hypothesis to set up that is more focused on the kind of challenges the company is looking to solve. - The next stage is then a SQL live tests around aggregation and use of Window functions etc. It was 7 SQL questions you had to solve in 30 minutes. Got 6/7 and didn't progress beyond this stage, which was supposed to be a python test. The SQL question are not really that difficuly. Easy - Medium Leetcode SQL questions. Just got undone by nerves at the final stage. The job was for £100k in London as an associate, so no surprises, it was very competitive.