Top 34
Prep plan
Updated weekly · Last refresh Oct 17

Amazon Analytics Engineer Interview Questions

The questions to prepare for a Amazon Analytics Engineer interview. Questions from real interview reports rank first. Updated daily.

34questions
~9htotal time
Track your progressSign up free to work through all 34 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 13 questions · ~216 min
Previous City Most CommonMedium
Practice

Identify the most common previous city for customers currently living in Seattle.

JoinsCTEsAggregationsAmazon
Prime Sharing PercentageMedium
Practice

Calculate the percentage of Prime customers with more than one Prime Video profile, including customers with no profiles.

null handlingJoinsAggregationsAmazon
Rolling 3 Day DemandMedium
Practice

Calculate each date's three-day demand using the current and two preceding daily unit values.

Date FunctionsData ManipulationAggregationsAmazon
More SQL & Data Manipulation questions with a free account
2
Coding8 questions · ~133 min
Three-Month GrowthMedium
Practice

Compute year-over-year growth for each three-month rolling window using a sliding window.

aggregationArraysAlgorithmsAmazon
Compare Highest and Lowest Selling CategoriesMedium
Practice

Aggregate category sales in a date range, then divide the highest total by the lowest total.

aggregationArraysAlgorithmsAmazon
Average Spend Per CustomerMedium
Practice

Calculate average customer spend while including customers with no purchases, using customer membership filtering and aggregation.

aggregationArraysAlgorithmsAmazon
More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership12 questions · ~199 min
Data Recommendations ImpactEasy

Tests data-driven influence, stakeholder alignment, and ownership of recommendations.

analytical skillsaccountabilityanalytical judgmentAmazon
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~17 min
Retention Metric for PrimeHard

Define monthly Prime subscription retention, identify data limitations, and explain regional and demographic cohort breakdowns.

KPI developmentmetric selectionCohort AnalysisAmazon
The finish line: interview-readyComplete all 34 questions to finish this plan.