Business Analyst- D2C Operations

Exotic Mile; Gurugram District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Exotic Mile seeks a data-driven Business Analyst with strong operations experience to support and optimize its D2C website business. You will analyze end-to-end operational data including inventory flow, fulfillment performance, RTO management, and delivery metrics.

The role involves building dashboards, monitoring KPIs, and partnering with cross-functional teams to translate business problems into analytical solutions, driving efficiency and better working capital utilization.

Qualifications

• Experience in Business Analytics, Supply Chain Analytics, Operations Analytics, or D2C Analytics.
• Exposure to D2C website operations, order lifecycle management, or logistics.
• Experience analyzing RTO metrics and COD-related challenges.
• Experience with large datasets and decision-support tools.

Responsibilities

• Analyze operational data across D2C logistics, warehousing, inventory flows, and website order management to identify trends and risks.
• Develop dashboards and automated reports to monitor KPIs such as inventory health, stock movement, fulfillment performance, RTO rates, delivery SLAs, and cost efficiency.
• Deep-dive into Return to Origin (RTO) performance to identify root causes and recommend actions.
• Support demand-supply alignment and inventory planning through data modeling and forecasting analysis.
• Track website funnel metrics in relation to COD vs Prepaid mix and RTO impact.
• Partner with Operations, Growth, CX, Finance, and Supply Chain to translate problems into analytics.
• Provide actionable insights to improve efficiency, service levels, and working capital.
• Standardize reporting frameworks and improve data accuracy and governance.

Skills

SQL

Excel/Sheets

Data analysis

Stakeholder communication

Forecasting

D2C metrics

Job description

Role Overview

We are looking for a data-driven Business Analyst with strong operations experience to support and optimize our D2C (website) business. This role will focus on end-to-end operational analytics including inventory flow, fulfillment performance, customer delivery metrics, and Return to Origin (RTO) management.

The ideal candidate should combine analytical rigor with hands‑on operational understanding and be comfortable working in a fast-paced D2C environment.

Key Responsibilities

• Analyze operational data across D2C logistics, warehousing, inventory flows, and website order management to identify trends, risks, and optimization opportunities.
  
• Develop dashboards and automated reports to monitor KPIs such as inventory health, stock movement, fulfillment performance, RTO rates, delivery SLAs, and cost efficiency.
  
• Deep-dive into Return to Origin (RTO) performance identify root causes, track trends by geography/partner/category, and recommend corrective actions.
  
• Support demand-supply alignment and inventory planning through data modeling and forecasting analysis.
  
• Track website funnel metrics in relation to operational outcomes (COD vs Prepaid mix, RTO impact, cancellation trends).
  
• Partner with cross-functional stakeholders (Operations, Growth, CX, Finance, Supply Chain) to translate business problems into analytical solutions.
  
• Provide actionable insights to improve operational efficiency, service levels, customer experience, and working capital utilization.
  
• Standardize reporting frameworks and improve data accuracy, reconciliation processes, and governance practices.

Preferred Experience

• 36 years of experience in Business Analytics, Supply Chain Analytics, Operations Analytics, or D2C Analytics.
  
• Prior exposure to D2C website operations, order lifecycle management, logistics, warehousing, or inventory management.
  
• Hands‑on experience analyzing and managing RTO metrics and COD-related operational challenges.
  
• Experience working with large datasets and building decision-support tools in a business environment.

Required Skills

• Strong analytical and problem-solving capability.
  
• Proficiency in SQL and Advanced Excel / Google Sheets.
  
• Strong understanding of D2C operational metrics, RTO drivers, and basic supply chain concepts.
  
• Ability to communicate insights clearly to business stakeholders and drive action.
  
• Basic knowledge of data modelling, forecasting, or statistical analysis is an advantage.
  
• High ownership mindset with ability to work in fast-paced, high-growth environments.