Amazon Business Analyst interview questions

The process was structured and aligned heavily with Amazon’s Leadership Principles. It consisted of four rounds over about 2–3 weeks: Phone Screen (Recruiter): The recruiter gave a solid overview of the role, team, and what to expect. No technical questions, but they asked about my experience with SQL, Excel, and business analytics tools. Technical Screen: This was a 45-minute session with a Business Analyst. It focused on SQL queries and interpreting data from tables. I was asked to write queries to join datasets and calculate key metrics like revenue and conversion rates. Some Excel questions were also asked (VLOOKUP, pivot tables, etc.). Case Study Round: I was presented with a real-world business problem involving customer behavior and was asked to propose a data-driven approach. I walked through how I’d gather data, structure analysis, and measure success. No coding—just logic and storytelling. Final Loop (3 interviews): One behavioral interview focused on Amazon’s Leadership Principles (e.g., "Tell me about a time you disagreed with a team decision..."). One technical/analytical deep dive. One interview with a hiring manager discussing stakeholder communication and prioritization.