Dataford
Top 48
Prep plan
Updated weekly · Last refresh Aug 30

Amazon Services Data Analyst Interview Questions

The questions to prepare for a Amazon Services Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

48questions
~6htotal time
Track your progressSign up free to work through all 48 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 5 questions · ~40 min
Automating Manual Financial ReportingMedium

Discuss automating a manual reporting workflow with code, focusing on batch ETL, orchestration, and data quality.

Data WranglingETLAutomationAmazon Services
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAmazon Services
More Pipelines questions with a free account
2
SQL & Data Manipulation14 questions + 3 drills · ~142 min
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberAmazon Services
Create Daily Summary of Purchases and LoginsEasy

Tests SQL aggregation and building reliable daily rollups from raw event tables.

Date FunctionsGroup ByAggregationsAmazon Services
Calculate 30-Day User RetentionHard
Practice
Practice drill

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregationsCurefitReachMobiIndeed
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
SQL for Missed ProductivityHard
Practice
Practice drill

Use joins, aggregation, and CASE expressions to find Amazon Services shifts missing hourly productivity thresholds over 30 days.

sql queryData AnalysisAmazon Services
More SQL & Data Manipulation 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
Product Sense10 questions · ~80 min
Improve Customer Experience with DataMedium

Tests product sense and impact measurement using data-driven decisions.

User NeedsValue PropositionPain PointsAmazon Services
Dealing With Buyer AmbiguityMedium

Tests how you translate ambiguous buyer needs into measurable analytics work.

Jobs to Be DoneUser NeedsProduct VisionAmazon Services
More Product Sense questions with a free account
4
Metrics13 questions · ~104 min
Define Success Metrics for Vague PromptsMedium

Tests metrics design and alignment to business outcomes under uncertainty.

North Star MetricKPIsDiagnosisAmazon Services
More Metrics questions with a free account
5
Statistics & Probability5 questions · ~40 min
Determine the Right Control GroupMedium

Tests experimental rigor and ability to prevent bias when selecting controls.

ExperimentationCausal InferenceA/B TestingAmazon Services
More Statistics & Probability questions with a free account
6
More topics1 question · ~8 min
More questions with a free account
The finish line: interview-readyComplete all 48 questions plus 3 hands-on drills to finish this plan.