Analytics Engineer Interview Questions

1,259 analytics engineer interview questions shared by candidates

Generally the take home assignment was about data modelling and dbt. They asked to create a data model based on entities important to the company, but the problem is that the process was only fictional without any real dataset given to me.
avatar

Senior Analytics Engineer

Interviewed at DocPlanner

4.2
Mar 26, 2025

Generally the take home assignment was about data modelling and dbt. They asked to create a data model based on entities important to the company, but the problem is that the process was only fictional without any real dataset given to me.

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 :)

Viewing 321 - 330 interview questions

Glassdoor has 1,259 interview questions and reports from Analytics engineer interviews. Prepare for your interview. Get hired. Love your job.