Analytics Senior Interview Questions

887 analytics senior interview questions shared by candidates

PWC recruiter walked me through the interview process and the position itself. 2 directors asked questions on quantitative finance (stochastic, my project, coding), and some business-related questions (give an example you noticed an opportunity to improve the business, model risk governance, etc). Both interviewers are nice.

PWC recruiter walked me through the interview process and the position itself. 2 directors asked questions on quantitative finance (stochastic, my project, coding), and some business-related questions (give an example you noticed an opportunity to improve the business, model risk governance, etc). Both interviewers are nice.

At 2nd stage: 1. Difference between left and full join - example to explain 2. Window functions 3. Sum over vs sum - example to explain why and what we would get from given query 4.Rate your SQL skills -0-10 Complete 0 questions about BI skills or knowledge, so basically SQL more important than BI. As long as SQL is right you do not need any BI skills :)
avatar

Senior Analytics Engineer

Interviewed at Monzo Bank

3.9
Nov 9, 2022

At 2nd stage: 1. Difference between left and full join - example to explain 2. Window functions 3. Sum over vs sum - example to explain why and what we would get from given query 4.Rate your SQL skills -0-10 Complete 0 questions about BI skills or knowledge, so basically SQL more important than BI. As long as SQL is right you do not need any BI skills :)

One of the key questions involved data modeling. I was given a set of database tables and asked to design a data model that would enable the business to answer specific analytical and reporting questions. The task required identifying relationships between the tables, defining appropriate entities and dimensions, and structuring the data in a way that supported efficient querying and business insights.
avatar

Senior Analytics Engineer

Interviewed at Treatwell

4.1
Jun 9, 2026

One of the key questions involved data modeling. I was given a set of database tables and asked to design a data model that would enable the business to answer specific analytical and reporting questions. The task required identifying relationships between the tables, defining appropriate entities and dimensions, and structuring the data in a way that supported efficient querying and business insights.

Viewing 251 - 260 interview questions

Glassdoor has 887 interview questions and reports from Analytics senior interviews. Prepare for your interview. Get hired. Love your job.