Amazon Business Analyst candidates report an online assessment, a SQL or Excel screen, and a loop where Leadership Principles stories carry most of the weight. Formats vary by team, so prepare both behavioral and technical material.
$109K
Avg. Base Comp
$140K
Avg. Total Comp
Not reported
Typical Rounds
Not reported
Process Length
Amazon Business Analyst interviews center on Leadership Principles stories, usually backed by a SQL, Excel or business-case check. Several candidates describe an online assessment first. One describes it as a work simulation that gave a useful preview of the day-to-day job. Later stages reported include a phone interview with a manager and an analyst, a technical screen, and a loop of interviews. One candidate had four Zoom interviews of about 45 minutes each, including a Bar Raiser.
Behavioral depth is the most repeated theme. Candidates were pushed past polished summaries into follow-ups about what they personally did, why they made certain decisions and how they handled ambiguity. Reported prompts include why Amazon, a difficult customer, trusting your gut without all the data, and handling multiple payment requests under a tight deadline. Others include a time you innovated and creating something a stakeholder didn't know they needed. Have several distinct STAR stories ready, since one candidate was told to expect two or three principle-based questions.
Technical depth varies by team. One candidate reports an hour-long SQL round on a whiteboard that included window functions. Another had an hour-long screen mixing SQL with behavioral questions. Others saw an Excel task, a business case with on-the-spot profit and percentage calculations, a financial-modeling-style case, or a question about analytics tools in the market. Outcomes were mixed, with offers and rejections both reported, so rehearse explaining your reasoning aloud. Scheduling speed and recruiter communication also varied widely between candidates.
Synthesized from 83 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 | |
| Customer Orders | |
| Rolling Bank Transactions | |
| Comments Histogram | |
| Closest SAT Scores | |
| Subscription Overlap | |
| Month Over Month | |
| Button AB Test | |
| Top Three Salaries | |
| Prime to N | |
| Monthly Customer Report | |
| Paired Products | |
| Upsell Transactions | |
| Top 3 Users | |
| Recurring Character | |
| Longest Streak Users | |
| Jars and Coins | |
| Compute Deviation | |
| Retailer Data Warehouse | |
| Download Facts | |
| Experiment Validity | |
| Weekly Aggregation | |
| Bagging vs Boosting | |
| Daily Retention Summary | |
| Average Quantity | |
| Size of Joins | |
| Random SQL Sample | |
| Post Composer Drop | |
| Manager Team Sizes |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report an initial online assessment. One describes a work simulation that previewed the day-to-day job, and others mention receiving an assessment invite about two weeks after applying. Plan for the format to vary by team and role.
Several candidates describe an early screen, such as a phone interview with a manager and an analyst or a general screening interview. Reported content includes a walkthrough of a recent project, scenario questions and how your past experience fits the role. Expect to explain your past work concisely.
Candidates report live SQL, including whiteboard problems with window functions and an hour-long screen mixing SQL and behavioral questions. Others describe an Excel task, a business case with quick profit and percentage calculations, or a financial-modeling-style case. The technical depth typically depends on the team.
Most candidates describe a loop of several interviews built around STAR answers tied to Leadership Principles. One candidate had four Zoom interviews of about 45 minutes each, including a Bar Raiser. Follow-up questions probe your own contribution, decisions and judgment.
Candidates report both offers and rejections. Some describe quick follow-up after the interview, while others report slow scheduling, slow results or recruiter communication gaps. Build in patience and keep your STAR stories ready while you wait.
