Senior Analytics Interview Questions

885 senior analytics interview questions shared by candidates

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

a basic SQL query scenario based . there are three tables related to each other with a anID they are loaded into target system . the future system auto-generates the id column . how will bring old value. in return I asked if I can used a custom field to being over old column interviewer said 'yes ' and interrupted me mid way saying oh ok you are almost there
avatar

Senior Analytics Consultant

Interviewed at LexisNexis Legal & Professional

3.7
Dec 22, 2022

a basic SQL query scenario based . there are three tables related to each other with a anID they are loaded into target system . the future system auto-generates the id column . how will bring old value. in return I asked if I can used a custom field to being over old column interviewer said 'yes ' and interrupted me mid way saying oh ok you are almost there

Viewing 241 - 250 interview questions

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