Amazon Data Analyst interviews typically pair SQL with Leadership Principles behavioral questions. Candidate reports range from mostly behavioral two-round processes to multi-round loops with an assessment and a Bar Raiser.
$118K
Avg. Base Comp
$175K
Avg. Total Comp
2-6 rounds
Typical Rounds
2-3 months
Process Length
Amazon Data Analyst candidates describe two consistent threads: Leadership Principles stories matter in nearly every loop, and SQL shows up often. The formats vary a lot, so prepare for a range rather than one fixed script.
At the lighter end, one candidate had an HR screen followed by a hiring manager conversation that was mostly behavioral. It covered a self-introduction, strengths and weaknesses, a resume gap, handling customer complaints and presenting to senior people. Others reported a heavier technical mix. One described an assessment with SQL and Python, then a written test that added statistics, three loop rounds and a Bar Raiser. Another had a one-on-one behavioral round, an SQL test and a further behavioral round.
The SQL questions candidates mention are practical. One technical screen had six easy-to-medium SQL questions and a numerical Python question in about an hour. Another candidate was asked to find the top-selling product in each category. Business judgment also came up: defining KPIs, handling missing data, analyzing customer churn and prioritizing competing requests. One candidate was asked to explain AWS and its services, and another faced questions on databases and data pipelines.
Reported behavioral prompts include a time you struggled, why Amazon should choose you, and using data to influence decisions. Interviewers often tie questions back to specific Leadership Principles, so keep your STAR stories concise and grounded in your own work.
Outcomes were mixed, with more rejections than offers. Timing was reported once, at roughly two to three months from first recruiter contact to the final result.
Synthesized from 38 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Amazon process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Amazon
Write a query that returns all neighborhoods that have 0 users.
| Question | |
|---|---|
| 2nd Highest Salary | |
| Rolling Bank Transactions | |
| Customer Orders | |
| Comments Histogram | |
| Closest SAT Scores | |
| Top Three Salaries | |
| Monthly Customer Report | |
| Compute Deviation | |
| Experiment Validity | |
| Download Facts | |
| Random SQL Sample | |
| Subscription Overlap | |
| Month Over Month | |
| Button AB Test | |
| Prime to N | |
| Paired Products | |
| Upsell Transactions | |
| Top 3 Users | |
| Swipe Precision | |
| Longest Streak Users | |
| Bank Fraud Model | |
| Encoding Categorical Features | |
| Rolling Average Steps | |
| Identifying User Sessions | |
| Exam Scores | |
| Weekly Aggregation | |
| Bagging vs Boosting | |
| Network Experiment Design | |
| Daily Retention Summary |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report an initial conversation about background, motivation for the role and sometimes career gaps. One candidate said it was conversational with no tricky technical questions. Another described the recruiter screen as setting expectations and helping them prepare for later steps. Prepare a concise self-introduction.
One candidate reported an assessment covering SQL and Python, followed by a written test that added statistics. Other candidates did not mention an assessment, so this stage may not apply to every team.
Candidates report technical rounds centered on SQL. One screen lasted about an hour, with six easy-to-medium SQL questions and one numerical Python question. Another candidate described a 60-minute phone screen covering data analyst basics, databases and data pipelines. Interviewers were described as friendly and willing to guide candidates who got stuck.
Some candidates report a conversation with a hiring manager or team lead about whether they understand the analyst role. Reported questions covered resume walkthroughs, the business impact of analysis, communication style and presenting to senior people. Prepare to explain how your analysis created business value.
Candidates report later rounds that lean heavily on Leadership Principles. One described a loop with three senior interviewers, and another described three loop rounds plus a Bar Raiser. Business questions on churn, KPIs and prioritization also appeared. Prepare several STAR stories that map to Leadership Principles and show your personal contribution.
