Senior Data Analyst Interview Questions

2,912 senior data analyst interview questions shared by candidates

The first step is an hour home test built with two sections. the first is a 40 minutes SQL test with 4 different questions. joins, aggregations, window functions, indexing. Later a 20 min business test with two assignments, in the first you need to record a video of yourself answering how can you predict a purchase of an iPhone based on the data you are given. And in the second you need to do a sanity check to a data table you are given, for example, the categories were not consistent during all months. The second stage is a Zoom interview where you are given a problem in python to solve, mine was transforming keys and values of a dictionary and avoid duplications during this transformation. later a question regarding how to solve it in SQL. The last stage is a 3 hour home test in SQL with research and business thinking.
avatar

Senior Data Analyst-R&D

Interviewed at SimilarWeb

3.5
Feb 20, 2022

The first step is an hour home test built with two sections. the first is a 40 minutes SQL test with 4 different questions. joins, aggregations, window functions, indexing. Later a 20 min business test with two assignments, in the first you need to record a video of yourself answering how can you predict a purchase of an iPhone based on the data you are given. And in the second you need to do a sanity check to a data table you are given, for example, the categories were not consistent during all months. The second stage is a Zoom interview where you are given a problem in python to solve, mine was transforming keys and values of a dictionary and avoid duplications during this transformation. later a question regarding how to solve it in SQL. The last stage is a 3 hour home test in SQL with research and business thinking.

Viewing 1751 - 1760 interview questions

Glassdoor has 2,912 interview questions and reports from Senior data analyst interviews. Prepare for your interview. Get hired. Love your job.