Skip to contentSkip to footer

Senior Data Analyst Interview Questions

Salaries
Interviews

2,900 senior data analyst interview questions shared by candidates

**Business Case & Additional Business Questions:** 1. What additional data features/data columns/data series could have been useful for forecasting and predictive modeling? 2. What are things that can give you a better overall estimate of the order value? 3. How to ensure experimenting with adding more orders per courier (batching) with the intention of reducing costs doesn’t harm customer satisfaction? 4. Regarding the A/B test used to experiment with batching, how would you deal with the following segmentation challenge: I'm dividing users randomly, some of the final users of the same batch might end up in the control and others in the treatment group. So your segmentation between control and treatment wouldn’t be really working. 5. Let’s say to deal with the issue from the last question you segment your users into north and south. But then which other issues do you face? 6. A senior decision maker comes and asks you “Okay, you guys at the data department are quite smart, but how confident are you on your prediction model’s forecast?” I understand you used metrics to evaluate model performance and that the model is usually off by 10%, but how confident are you in your model’s forecast? How would you arrive at this metric. --- **SQL Questions:** 1. How to pivot the structure of a table for better aggregation? 2. What qualities make a good SQL Analyst?
avatar

Senior Data Analyst

Interviewed at Bolt

3.4★
Oct 21, 2023

**Business Case & Additional Business Questions:** 1. What additional data features/data columns/data series could have been useful for forecasting and predictive modeling? 2. What are things that can give you a better overall estimate of the order value? 3. How to ensure experimenting with adding more orders per courier (batching) with the intention of reducing costs doesn’t harm customer satisfaction? 4. Regarding the A/B test used to experiment with batching, how would you deal with the following segmentation challenge: I'm dividing users randomly, some of the final users of the same batch might end up in the control and others in the treatment group. So your segmentation between control and treatment wouldn’t be really working. 5. Let’s say to deal with the issue from the last question you segment your users into north and south. But then which other issues do you face? 6. A senior decision maker comes and asks you “Okay, you guys at the data department are quite smart, but how confident are you on your prediction model’s forecast?” I understand you used metrics to evaluate model performance and that the model is usually off by 10%, but how confident are you in your model’s forecast? How would you arrive at this metric. --- **SQL Questions:** 1. How to pivot the structure of a table for better aggregation? 2. What qualities make a good SQL Analyst?

Viewing 841 - 850 interview questions

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