Analytics Engineer Interview Questions

1,255 analytics engineer interview questions shared by candidates

HR interview: motivations, leave & join reasons; collaboration with business people; salary expectation Manager interview: conflict and disagreement management; project and time management skills (synergy); salary expectation Technical exercises: Data modelling on Carpool, python coding of an ELT pipeline to load data from API to DB. Technical interviews: Presentation of your work. your modelling logic, pros and cons of different data modelling methods (Kimball, OBT, data vault, according to your choice); Special focus on analysing leg of journeys and trip stops ; difference of append/truncate data & dbt incremental models, when to use different methods; how to handle slowly changing dimensions; your pipeline alerting methods; Schema changes handling (order of columns; new columns etc.); SQL questions based on your answer (window functions etc.) VP data interview: your understanding of the position; disagreement and conflict management; your career planning
avatar

Analytics Engineer

Interviewed at BlaBlaCar

4.2
Feb 15, 2024

HR interview: motivations, leave & join reasons; collaboration with business people; salary expectation Manager interview: conflict and disagreement management; project and time management skills (synergy); salary expectation Technical exercises: Data modelling on Carpool, python coding of an ELT pipeline to load data from API to DB. Technical interviews: Presentation of your work. your modelling logic, pros and cons of different data modelling methods (Kimball, OBT, data vault, according to your choice); Special focus on analysing leg of journeys and trip stops ; difference of append/truncate data & dbt incremental models, when to use different methods; how to handle slowly changing dimensions; your pipeline alerting methods; Schema changes handling (order of columns; new columns etc.); SQL questions based on your answer (window functions etc.) VP data interview: your understanding of the position; disagreement and conflict management; your career planning

Viewing 651 - 660 interview questions

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