Senior Analytics Consultant Interview Questions

149 senior analytics consultant interview questions shared by candidates

-Tell me about a time you had to solve for a problem but didn't have enough information - Calculate 3 month moving average using pandas - 3 tables and 3 SQL questions to solve for - joins, window function , aggregation, etc.
avatar

Senior Analytics Consultant

Interviewed at CVS Health

3.2
May 31, 2023

-Tell me about a time you had to solve for a problem but didn't have enough information - Calculate 3 month moving average using pandas - 3 tables and 3 SQL questions to solve for - joins, window function , aggregation, etc.

What steps would you take to migrate a client's on premise data warehouse to cloud? ( Topics : Atomicity, STAR schema, Snowflake schema, Data warehouse system design, data governance, data privacy, access issues, road maps etc) Leet code medium level SQL questions. Leet code easy level python questions. NLP, Traditional ML Algos, Guesstimates, Behavior questions and situational questions.
avatar

Senior Analytics Consultant

Interviewed at EXL Service

3.5
Feb 29, 2024

What steps would you take to migrate a client's on premise data warehouse to cloud? ( Topics : Atomicity, STAR schema, Snowflake schema, Data warehouse system design, data governance, data privacy, access issues, road maps etc) Leet code medium level SQL questions. Leet code easy level python questions. NLP, Traditional ML Algos, Guesstimates, Behavior questions and situational questions.

Viewing 81 - 90 interview questions

Glassdoor has 149 interview questions and reports from Senior analytics consultant interviews. Prepare for your interview. Get hired. Love your job.