Amazon Business Intelligence Analyst interview questions

I applied online. Got an initial screening call, then had a 1 hour one-on-one interview with hiring manager. Had 3 SQL questions which were of Leetcode easy and medium levels(window functions). Had a surprise case study on pricing. Then was asked behavioural question on "dig deep" principle

I recently interviewed for the BIE-II position at Amazon. The process was straightforward and focused primarily on practical skills. Interview Format: 2 SQL questions: One focused on basic joins and filtering; the other involved aggregation and window functions. Both were solvable but required accuracy and speed. 1 Leadership Principle (LP) question: Behavioral-based, focused on ownership and problem-solving in ambiguous situations. Feedback: The difficulty level was moderate, but time management is crucial. Make sure to practice SQL under timed conditions and prepare structured STAR-format responses for LPs. I wasn’t selected, but it was a fair and professionally conducted process. Tips: Practice SQL queries with real datasets (like LeetCode or StrataScratch). Prepare LP stories in advance and align them with Amazon’s core principles. Be concise and manage your time well during the interview. Good learning experience overall.