Business Analyst
Amazon
About the role
Amazon is a global e‑commerce and technology leader that has reshaped retail, cloud computing, digital streaming and AI. In India, Amazon operates one of the largest fulfillment networks, employing tens of thousands across fulfillment centres, sort centres, last‑mile stations and innovative micro‑fulfilment hubs. The company’s culture is built around customer obsession, ownership, and a relentless focus on invention, which fuels rapid growth and offers employees a platform to work on problems that impact millions of customers daily.
The Innovation Lab at Amazon’s Bangalore (BLR8) site is a fast‑moving, experimental hub where new automation solutions—such as autonomous mobile robots, smart packing equipment and home‑grown software tools—are piloted, validated and prepared for roll‑out across the broader network. The lab blends robotics, data science and operations expertise to create scalable, high‑impact solutions.
As a Business Analyst in the Innovation Lab, you will be the data backbone of every pilot. You will design, build and maintain the data pipelines, dashboards and alerting mechanisms that allow the team to measure success, spot defects early and make evidence‑based decisions about scaling. You will also get hands‑on exposure on the shop floor, collecting physical metrics, running test plans and ensuring safety compliance.
This role is ideal for candidates who love turning raw data into actionable insights while working in a high‑tempo, technology‑driven environment.
Key Responsibilities
- Write SQL queries and extracts to pull pilot data from Amazon’s operational systems and build a reliable data foundation for each trial.
- Design, develop and maintain interactive dashboards that visualise trial progress against defined success criteria.
- Set up real‑time alerts and exception reports to flag metric deviations, enabling the team to act within the same day.
- Monitor the health of data‑pipeline jobs, dashboards and source systems, targeting 100% availability.
- Diagnose and resolve root‑cause data issues, including failed jobs, missing or mismatched records.
- Define the data collection plan for each pilot – metrics, baselines, collection methods – before the trial begins.
- Own the lab scorecard and daily pilot report; prepare concise data packs for weekly business reviews and leadership updates.
- Analyse trends from dashboards and alerts to uncover defect patterns and recommend corrective actions.
- Support site‑readiness analysis when a solution is moved to a new location, ensuring data continuity.
- Participate in floor‑level pilot execution, conduct time‑studies, log downtime/faults and enforce safety controls in automation zones.
Tech Stack: SQL (Amazon Redshift/Presto), MS Excel (advanced functions, Power Query), data‑visualisation tools (Amazon QuickSight/Tableau), scripting in Python/R for data cleaning, familiarity with data‑pipeline orchestration (AWS Glue/Step Functions) and basic knowledge of statistical tools such as SAS/SPSS.
Growth Path: Starting as a Business Analyst, you can progress to Senior Business Analyst, Data Product Owner, Operations Analyst Manager, or move laterally into Data Science, Automation Engineering or Program Management roles within Amazon’s vast operations network.
Why Join Amazon Innovation Lab?
- Work on cutting‑edge automation projects that directly shape the future of Amazon’s fulfillment ecosystem.
- Gain exposure to large‑scale data engineering, analytics and robotics in a real‑world, high‑impact setting.
- Be part of a culture that rewards ownership, fast learning and customer‑centric problem solving.
- Access Amazon’s extensive learning resources, mentorship programs and clear career ladders.
- Competitive compensation, comprehensive benefits and the excitement of building solutions that scale globally.
Eligibility & process
Who can apply
Bachelor’s degree in Engineering, Science, Commerce or any quantitative discipline; minimum 60% aggregate (or CGPA 6.0/10); graduating batch 2022‑2026; no active backlogs; strong analytical mindset and proficiency in SQL and Excel.
Skills & stack
Selection process
- Round 1: Online Assessment (SQL/Excel based data analysis or coding test)
- Round 2: Technical Phone/Video Interview (SQL queries, data pipeline concepts, scenario based problem solving)
- Round 3: Onsite Interviews (4 rounds covering Business Analyst case study, Leadership Principles, Technical depth, HR discussion).
Prep kit
20 resourcesStudy material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Behavioural & HR questions 3
Highlight Amazon's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.