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

Amazon Services Financial Analyst Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 9 questions · ~72 min
Calculate Customer Lifetime ValueMedium

Walk through the math of customer lifetime value using retention, churn, and margin assumptions.

CACRetentionLTVAmazon Services
Calculate Self-Serve LTV to CACMedium

Define and calculate LTV to CAC for self-serve customers, then interpret what the ratio says about growth efficiency.

CACLTVfinancial metricsAmazon Services
Measure Financial Success of FeaturesEasy

Choose metrics that show whether a feature creates incremental profit, not just usage.

KPIsLeading IndicatorsDiagnosisAmazon Services
More Metrics questions with a free account
2
Strategy28 questions · ~224 min
Sizing an Untapped Product MarketHard

Framework for estimating TAM, adoption, and revenue for a new product launch in an untapped market.

revenue modelnew product launchMarket SizingAmazon Services
Evaluating Profitability of a New AWS ServiceHard

Tests your ability to assess unit economics, costs, and profitability drivers for AWS offerings.

EstimationPricing StrategyMarket SizingAmazon Services
Identifying Missed Cost-Saving OpportunitiesMedium

Tests your analytical rigor and ability to uncover and drive actionable cost improvements.

EstimationCompetitive AnalysisEconomies of ScaleAmazon Services
More Strategy questions with a free account
3
Behavioral & Leadership11 questions · ~88 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Summarizing Financial Data in SQLEasy

Explain how you use SQL aggregations and grouping to analyze financial data and prepare outputs for tools like Excel or FastBI.

Data WranglingCase WhenAggregationsAmazon Services
Financial Projection ProjectMedium

Assesses your ability to build and explain financial projections and assumptions.

Amazon Services

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
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
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.