Asst. Business Analyst , Now LM

Amazon Now is one of India's fastest-growing quick commerce platforms, and our Last Mile (LM) network is the engine that powers every delivery. We are looking for a curious, detail-oriented Assistant Business Analyst to join the Amazon Now LM team, to build the data insight and reporting backbone that will drive cost and performance decisions across our 1P and 3P last mile channels.

In this role, you will own data aggregation, reporting, and insight generation across key LM metrics — including cost per delivery (CPD), rate cards, payout structures, and Delivery Partner performance indicators such as orders delivered, service hours, and distance traveled. You will work at the intersection of data and operations, turning raw numbers into clear, actionable insights that shape how we manage our delivery partner network and control costs.

This is an ideal role for someone who is intellectually curious about quick commerce and data science, has a strong instinct to simplify complex data problems, and thrives on delivering results through data-driven insights.

Key job responsibilities
LM Cost Reporting: Own end-to-end team-level reporting on cost per delivery (CPD) across 1P and 3P last mile channels — tracking actuals vs. targets, identifying cost drivers, and flagging anomalies for review. Prepare and publish regular performance reports for LM operations, finance, and 3P partner management teams. Translate complex data into clear narratives for non-technical stakeholders.

Rate Card & Payout Tracking: Maintain and update store-level rate card and payout data across the network. Ensure accuracy of payout computations and flag discrepancies between contracted rates and actuals.

DP Performance Metrics: Build and maintain dashboards tracking delivery partner (DP) level performance — including orders delivered, service hours logged, distance travelled, and productivity indices — across both 1P and 3P channels.

Data Aggregation & Pipeline Management: Aggregate data from multiple internal and external sources using SQL, S3-based data pipelines, and Excel (including Macros) to create clean, reliable datasets that power weekly, monthly, and ad hoc reporting.

JSON Data Management: Leverage JSON to parse, manage, and transform complex nested data structures — particularly for 3P partner data feeds, API outputs, and pipeline payloads — ensuring data is accurately flattened and integrated into reporting workflows.


A day in the life
Your day starts with a check on overnight data pipelines — validating that CPD and DP performance dashboards have refreshed correctly, including 3P data feeds ingested via S3. You spend the morning writing SQL queries to pull the latest payout data, parsing JSON outputs from a 3P partner pipeline, and cross-checking actuals against rate cards. By midday, you're refining an Excel Macro to automate a weekly cost summary. The afternoon brings a sync with the LM ops team — you come prepared with clean visuals and a clear point of view. You close the day updating dashboards and queuing up the next reporting pack.

About the team
The Amazon Now Last Mile team is responsible for building and operating one of India's fastest-growing quick commerce delivery networks. We obsess over speed, reliability, and cost — and we do it at scale, across hundreds of dark stores and millions of deliveries every month.

Our LM Pricing team sits at the core of this engine. We define how delivery partners are compensated, how capacity is planned and flexed, and how the network responds to demand volatility. We are a small, high-ownership team that values intellectual curiosity, operational rigor, and a bias for simplification. If you love turning messy data into clean insights — and want your work to directly shape how millions of customers receive their orders — this is the team for you.

Basic Qualifications

- 1+ years of data analytics or automation experience
- 1+ years of capacity planning, operations planning, business analysis or similar experience
- Bachelor's degree
- Knowledge of data pipelining and extraction using SQL
- Knowledge of SQL and Excel at a moderate or advanced level
- Experience with data mining tools like SQL, SAS, SPSS, or similar

Preferred Qualifications

- Knowledge of SQL/Python/R, scripting, MS Excel, table joins, and aggregate analytical functions

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.