Amazon Business Analyst Interview Guide

The short answer: At Amazon, a business analyst is an analytics and reporting role: the postings ask for SQL, deep Excel and Tableau, and the job is building metrics, reports and dashboards for a business team. Amazon publishes no interview prep page for business analysts, so the official steps come from its general hiring pages: an online assessment for some roles, one or two phone screens, and a loop with two to seven interviewers who all ask Leadership Principles questions. Candidate reports add a SQL screen and a loop of four to six rounds that mixes SQL, a business case and behavioral questions, but that evidence is thin. Amazon does not publish a candidate AI rule on its careers pages. Last reviewed October 2026.

Amazon business analyst interview: quick answers

The Amazon business analyst role

What Amazon business analysts work on, the skills its job postings ask for, and what a week can look like. Amazon posts the role as Business Analyst, Business Analyst II, Business Analyst III and Senior Business Analyst.

Amazon business analyst levels and pay

Your level sets the bar you are interviewed against and the pay band of the offer.

Amazon's BA postings state no L levels, and titles alone do not show level: a Whole Foods posting titled Sr Business Analyst says it is hiring a Business Analyst II, and both post the same range as plain BA postings. Candidate guides map BA to L4, BA II to L5 and BA III to L6; Amazon does not confirm this.

Pay in Amazon's US job postings

Amazon's US BA postings list a base salary range for each city. Standard postings say the package also includes sign-on payments and RSUs.

Most BA, BA II and Sr BA postings share one range per city, so the merged rows cover several teams. The two AMZ-coded postings state the range in the description. Business System Analyst postings are a different role and are left out. Ranges seen October 29, 2026.

Amazon business analyst interview process

Amazon has no business analyst prep page, so these steps come from its general How We Hire pages and its articles on phone screens, loops and the Bar Raiser. The SQL content of the screens and the round mix in the loop come from candidate reports, which are few.

Based on Amazon's own pages and candidate reports.

Amazon says loop results come within five business days and the whole process usually takes three to six weeks. It avoids brain teasers. Candidate sources disagree on loop size: most describe four to six rounds, while one guide that cites no sources describes only three. Last reviewed October 2026.

What is different at Amazon

• Business analyst at Amazon means analytics and reporting. Postings ask for SQL, 5+ years of Excel (VBA, pivot tables, array functions and power pivots) and Tableau, and the work is recurring metrics, dashboards and recommendations for a business team. Excel depth is stated more strongly than in BIE postings. The Business System Analyst title is a separate requirements and systems role.
• The role is spread across Amazon. Current BA postings come from Fulfillment by Amazon, Selling Partner Services, Amazon Logistics, Amazon Air, Whole Foods Market, AWS Global Network Delivery, Healthcare Finance Operations and re:Cycle Reverse Logistics, so the business case you get may be about any of them.
• BA, BIE and Data Scientist are separate job families. BIE postings ask for data modeling, warehousing, ETL pipelines and Python, and BIE has its own prep page with an online assessment and a five-interview loop. Data Scientist postings sit in the Science family and ask for statistical or ML modeling, often with a Master's or above. Amazon publishes nothing equivalent for BA, so do not assume the BIE format applies.
• Every interviewer asks Leadership Principles questions, and one may be a Bar Raiser from outside the team who runs the debrief. Amazon writes one-to-six-page narrative memos instead of slide decks, which is why some roles ask for a writing sample.
• All US BA postings we read list the location type as on-site. Amazon's CEO set an in-office expectation from January 2, 2025, except for approved exceptions.
• Amazon does not publish a candidate AI rule on its careers pages. Its assessments page says "All assessments must be completed solely by the applicant." A March 2025 news report quoted internal guidance asking candidates not to use generative AI tools during interviews unless explicitly permitted; that is press reporting. Many 2026 BA postings list using generative AI tools, and checking their output, as a preferred skill for the job itself.

Amazon business analyst interview questions

Questions from our bank, then practice prompts we wrote for this guide around Amazon's work.

1from typing import List, Optional, Tuple
2
3def wow_report(rows: List[Tuple[int, str, int, int]], threshold_pp: float
4               ) -> List[Tuple[str, float, Optional[float], bool]]:
5    """Return (station, rate, change, flagged) for the latest week, sorted by station."""
6    pass

1from typing import List, Optional, Tuple
2
3def wow_report(rows: List[Tuple[int, str, int, int]], threshold_pp: float
4               ) -> List[Tuple[str, float, Optional[float], bool]]:
5    totals = {}
6    for week, station, packages, on_time in rows:
7        if packages < 0 or on_time < 0 or on_time > packages:
8            raise ValueError("bad row")
9        p, o = totals.get((week, station), (0, 0))
10        totals[(week, station)] = (p + packages, o + on_time)
11    if not totals:
12        return []
13    latest = max(week for week, _ in totals)
14
15    def rate(week, station):
16        p, o = totals.get((week, station), (0, 0))
17        return o / p * 100 if p else None
18
19    report = []
20    for station in sorted({s for w, s in totals if w == latest}):
21        now = rate(latest, station)
22        if now is None:
23            continue
24        before = rate(latest - 1, station)
25        change = None if before is None else round(now - before, 1)
26        report.append((station, round(now, 1), change, change is not None and change <= -threshold_pp))
27    return report
28
29# Complexity: O(n + s log s) time for n rows and s stations, O(n) space.

How to prepare

A plan for the Amazon loop, most important first:

1. Prepare two or three stories per Leadership Principle with metrics, covering risk, success, failure and growth. Every interviewer asks these.
2. Practice SQL by hand: joins and how filters change them, GROUP BY, CTEs, window functions such as RANK and LAG, and date ranges.
3. Practice open-ended metric cases: a metric moved, find out why, size it and recommend an action.
4. Refresh Excel: pivot tables, lookups, Power Query and a simple VBA macro, since postings ask for 5+ years of it.
5. Read the posting's team (FBA, Logistics, Whole Foods, AWS and others) and prepare a view on the metrics that team runs on.
6. Ask your recruiter whether there is an online assessment, whether the screens include SQL, how many loop interviews to expect and what the rules on AI tools are.

Practice path

Courses that cover the rounds above:

• SQL
• Data Visualization
• Product Opportunity Sizing
• Applied Statistics
• Python Pandas for Data Analysis