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.