I passed the hr and hiring manager screens but failed at the technical interview round. Hiring manager asked a series of data related questions while technical round need to write the code to manipulate data. And they are using databrick notebook and remote zoom in to do the live coding which I was not expected, as I was told by hr it would be a leetcode style coding test.

I applied online and the recruiter reached out to me on LinkedIn and we got on a phone call quickly to discuss the role and next steps. Then I was given a 90 min challenge which consisted of a coding test - python and SQL and questions involving excel workbooks/pivot tables. Additional 10 minutes were provided for candidates who had working experience on Tableau. The SQL question were not medium difficulty and python coding problem was similar difficulty. Questions on excel and tableau were simple if one knew about pivot tables. After the test I was asked to speak with two quantitative analysts where they asked about my background and interests. They gave a case study based problem and asked what different metrics I would come up with. The final round was with the head of product and I had a very friendly chat with her followed by an offer. The recruiter coordinated all interviews via linkedin messages. While not conventional, I found it to be pretty efficient to schedule interviews rather than back and forth emails. Before the final round the recruiter pretty much gave me an idea that MScience was interested in hiring me and would offer me the position pretty soon.