I applied online and got a response from an amazing recruiter about a month later (Ally who I worked with throughout the entire process). The recruiter did a great job coordinating the interview process. When she first reached out to me, I was already close to the offer stage with another company, but she managed to move me so quickly that I was able to get through the interview-to-offer process in just a couple of weeks. During the process, she had been very responsive to email/txt/call even during late evenings.
The interview process consists of four steps:
Step 1: A 30 min call with the recruiter to discuss my background/experience and interest in the role/company.
Step 2: Take-Home Analytics Challenge - I was given some datasets along with a list of questions that guided the analysis. I used Python to do the challenge, but you are free to use other tools as well. You should expect to be tested on the following skills with this exercise:
data manipulation
data visualization
analytical skills
presentation skills
Step 3: Hiring Manager Screening – first half of the call was about discussions around the responsibilities/expectations of the role. The second half was about answering a couple of case study questions that were intended to test my critical thinking skills.
Step 4: Virtual On-site Interview via Zoom – This step was quite lengthy and was split into two days (about 3- 4 hours per day with breaks in between). I interviewed with a total of 8 people which included the hiring manager, a few senior level BI/Data Analysts (some on the same team as this role and some from other teams at the company), and couple cross functional stakeholders. During one round of the virtual on-site, I was asked to present my take-home analytical challenge to a Senior BI/Data Analyst on the team and a cross functional stakeholder. There was also a live SQL coding test via hacker rank in another round of the on-site. The rest of the on-site were generally about answering some case/scenario analytical questions as well as some common behavioral questions.