Asst. Business Analyst , Now LM

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. 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

Amazon is a global technology company operating in e-commerce, cloud computing (AWS), digital streaming, advertising and artificial intelligence. Its India operations span development centres in Bengaluru, Hyderabad, Chennai, Pune, Gurugram and Mumbai, covering retail technology, AWS infrastructure, Alexa, advertising, payments and supply-chain systems.