Sr Data Analyst Interview Questions

2,956 sr data analyst interview questions shared by candidates

Home assignment - Building an ERD - Building 3 different SQL queries based on the tables provided - Solve 3 problems related to gaming strategy/metrics in marketing. Some fairly nice questions In-person interviews: - Questions were mostly on my gaming/mobile experience as it seems this company only values people with previous experience there (despite mine being in a very close industry) - Other questions on previous projects and trying to understand what you did in the workplace in the past - Some challenges/questioning on the output of my home assignment we discussed in the 3rd interview (both the SQL and marketing part)
avatar

Senior Marketing Data Analyst

Interviewed at MadBox

4.8
Mar 19, 2024

Home assignment - Building an ERD - Building 3 different SQL queries based on the tables provided - Solve 3 problems related to gaming strategy/metrics in marketing. Some fairly nice questions In-person interviews: - Questions were mostly on my gaming/mobile experience as it seems this company only values people with previous experience there (despite mine being in a very close industry) - Other questions on previous projects and trying to understand what you did in the workplace in the past - Some challenges/questioning on the output of my home assignment we discussed in the 3rd interview (both the SQL and marketing part)

It was more relate with my experience and mainly about how I was able to manage clients. You should show them that your able to show all the good points of your product and also able handle difficul situations.It also have some technical component but not so important as the commercial skills.
avatar

Senior Data Analyst

Interviewed at BioCatch

4.6
Feb 28, 2021

It was more relate with my experience and mainly about how I was able to manage clients. You should show them that your able to show all the good points of your product and also able handle difficul situations.It also have some technical component but not so important as the commercial skills.

Assume that we have the following tables, with columns as indicated: Rides ride_id start_time end_time passenger_id driver_id ride_region is_completed (Y/N) Drivers driver_id onboarding_time home_region 1) Write a query that we could use to create a plot of the total count of rides completed in our San Francisco region, in each week over the last 12 weeks. 2) For each week over the last 12 weeks, write a query that will return a count of the total drivers who gave at least one ride. And only for driver’s based in San Francisco.
avatar

Senior Data Analyst

Interviewed at Lyft

3.8
Mar 15, 2024

Assume that we have the following tables, with columns as indicated: Rides ride_id start_time end_time passenger_id driver_id ride_region is_completed (Y/N) Drivers driver_id onboarding_time home_region 1) Write a query that we could use to create a plot of the total count of rides completed in our San Francisco region, in each week over the last 12 weeks. 2) For each week over the last 12 weeks, write a query that will return a count of the total drivers who gave at least one ride. And only for driver’s based in San Francisco.

Viewing 1071 - 1080 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 2,956 interview questions and reports from Sr data analyst interviews. Prepare for your interview. Get hired. Love your job.