The interview process consisted of the following stages:
Initial Recruiter Screen – A 30-minute conversation to discuss my background, interest in the role, and high-level alignment with the team’s goals.
Technical Assessment – A timed SQL and data manipulation exercise conducted via HackerRank. The focus was on writing efficient queries, joining multiple datasets, and deriving insights from raw data.
Case Study / Take-Home Assignment – I was asked to analyze a dataset and produce a short report or dashboard with key insights, demonstrating my skills in SQL, data visualization, and storytelling.
Final Round Interviews – This included:
A technical deep dive with a current BIE, focusing on SQL, data modeling, and business logic.
A case review session to walk through my take-home assignment and explain my approach.
A cross-functional panel interview assessing communication skills, stakeholder management, and experience collaborating with product, engineering, or marketing teams.
The interview process was smooth and conversational. The interviewer was calmly asking questions about my previous work experiences and listened patiently. He even gave me ample time to frame my answers.
Interview questions [1]
Question 1
1. Tell me about your previous work experience.
2. Asked few SQL questions
few rounds of interviews ranging between technical and conversational. Mostly in the form of " tell a story of time where ..." to show how you relate to amazon LPs
The first interview is a technical phone interview that assesses your skills in SQL and Python, specifically data analysis with python. The interviewer pastes the description of an SQL problem on the code editor and asks you to write your answer while describing your thought process. They give you hints when you're stuck.
Interview questions [1]
Question 1
Could you tell me the steps involved in the data analysis process?