I applied through the company’s careers page and also received a referral via a LinkedIn connection. Round 1: Resume screening and past experience-based questions. Round 2: 3 SQL queries (joins, window functions, subqueries), 2 data interpretation questions (bar/line chart analysis), and 1 multiple-choice statistics question (confidence intervals). Round 3: Interview with the senior data analyst of the team.
Interview questions [1]
Question 1
Walk me through a project on your resume.
SQL: “Write a query to find the second-highest salary per department.”
How would you calculate customer churn?
Explain a time you handled messy or missing data.
How do you choose the right chart for a dashboard?