Top 49
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

49questions
~7htotal time
Track your progressSign up free to work through all 49 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 5 questions · ~42 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
Recently asked

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAmazon Services
More Pipelines questions with a free account
2
SQL & Data Manipulation15 questions + 1 drill · ~137 min
Window Ranking in Ticket QueuesMedium
Recently asked

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

Window FunctionsRankingrow_numberAmazon Services
Audit Data AnomaliesMedium

Tests ability to detect, validate, and reason about data quality issues in analytics pipelines.

Data WranglingCase WhenAggregationsAmazon Services
SQL Plan Upgrade DetectionMedium
Practice
Practice drill

Identify customers with at least two plan upgrades in the same calendar month using PostgreSQL CTEs and aggregations.

Window FunctionsDate FunctionsJoinsMongoDBAmazon 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
Metrics13 questions · ~110 min
Define Success Metrics for Vague PromptsMedium

Tests metrics design and alignment to business outcomes under uncertainty.

North Star MetricKPIsDiagnosisAmazon Services
Identify Root Cause of Metric ChangeHard

Tests causal-style decomposition of metric deltas and disciplined use of evidence.

Leading IndicatorsDiagnosisTime SeriesAmazon Services
More Metrics questions with a free account
4
Product Sense10 questions · ~85 min
Inventory Health Dashboard DesignMedium

Tests dashboard design thinking and selection of metrics and views for operational decision-making.

User NeedsPain PointsUse CasesAmazon Services
More Product Sense questions with a free account
5
Statistics & Probability5 questions · ~42 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 49 questions plus 1 hands-on drill to finish this plan.