KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #3908
Applications open Full-Time Job

Business Analyst

Amazon

  • Bangalore, Karnataka
  • β‚Ή12 LPA - β‚Ή15 LPA
  • Fresher (0-1 Yrs)
  • Posted Yesterday
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

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

SQL Advanced Excel Data Visualization Python SAS SPSS Data Mining Dashboard Development

Selection process

  1. Round 1: Online Assessment (SQL/Excel based data analysis or coding test)
  2. Round 2: Technical Phone/Video Interview (SQL queries, data pipeline concepts, scenario based problem solving)
  3. Round 3: Onsite Interviews (4 rounds covering Business Analyst case study, Leadership Principles, Technical depth, HR discussion).

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (SQL, Advanced Excel, Data Visualization, Python, SAS, SPSS, Data Mining, Dashboard Development) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Amazon Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Amazon as a Business Analyst?
Highlight Amazon's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Amazon β‚Ή12 LPA - β‚Ή15 LPA
Recruiter Resume Apply
Chat Chat with Kashii