Retail Merchandiser & Business Analyst

Campus Activewear; Gurugram District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Campus Activewear seeks a commercially driven Inventory Planning professional to own end-to-end planning for ecommerce channels, optimizing replenishment and product availability. You will analyze performance, forecast demand, and manage inventory to maximize sales and profitability across marketplaces and Brand.com.

You will build dashboards, monitor KPIs, and collaborate with Merchandising, Manufacturing, Supply Chain, and Category teams to prioritize production and assortment decisions.

Qualifications

• Experience in Merchandise Planning, Inventory Planning, Buying, Category Management, or Ecommerce Planning.
• Strong product-first mindset with ability to understand product performance and gaps.
• Good commercial acumen to translate insights into inventory and production decisions.
• Advanced Microsoft Excel (Pivot Tables, XLOOKUP, INDEX-MATCH, SUMIFS); Power BI/Tableau knowledge preferred.
• Strong analytical, problem-solving, and stakeholder management skills.
• Experience with large datasets, ERP systems (SAP preferred), and cross-functional teams in a fast-paced Ecommerce environment.

Responsibilities

• Own end-to-end inventory planning and replenishment across all Ecommerce channels.
• Prioritize molding based on demand forecasts, inventory gaps, product potential, and business priorities.
• Monitor DOH, stock ageing, fill rate, stock-outs, sell-through, and excess inventory.
• Identify hero styles, fast movers, slow movers, and assortment gaps.
• Build dashboards to monitor inventory health, lost sales, OSA, short supply, KPIs.
• Generate leadership-ready insights to improve sales, inventory productivity, and working capital.
• Collaborate with Merchandising, Manufacturing, Supply Chain, Category, and Marketplace teams.
• Recommend replenishment, assortment optimization, liquidation, and production priorities.
• Support new launches, seasonal planning, and promotions with proactive inventory planning.
• Continuously improve planning processes through automation, analytics, and data-driven decisions.

Skills

Merchandise Planning

Inventory Planning

Category Management

Ecommerce Planning

Analytical thinking

Tools

Excel

Power BI

Tableau

SAP

Job description

Role Purpose

Drive end-to-end inventory planning for the Ecommerce business by owning inventory health, replenishment planning, molding prioritization, and product availability across marketplaces and Brand.com. Molding prioritization refers to aligning production focus with demand forecasts, inventory gaps, product potential, and business priorities. This is a product-first planning role that requires strong understanding of product performance, customer demand, and commercial opportunitiesnot just reporting and spreadsheet analysis. The ideal candidate should identify high-performing products, highlight assortment gaps, and translate data into actions that maximize sales, profitability, and inventory productivity.

Key Responsibilities

• Own end-to-end inventory planning and replenishment across all Ecommerce channels.
• Prioritize molding based on demand forecasts, inventory gaps, product potential, and business priorities.
• Ensure healthy inventory by monitoring Days of Inventory (DOH), stock ageing, fill rate, stock-outs, sell-through, and excess inventory.
• Develop a deep understanding of the product portfolio to identify hero styles, fast movers, slow movers, declining products, and assortment gaps.
• Build and maintain dashboards and trackers to monitor inventory health, lost sales, Online Stock Availability (OSA), short supply, and key business KPIs.
• Generate leadership-ready insights and recommendations to improve sales, inventory productivity, and working capital efficiency.
• Work closely with Merchandising, Manufacturing, Supply Chain, Category, and Marketplace teams to ensure the right products are available at the right time.
• Recommend replenishment, assortment optimization, liquidation, and production priorities based on product performance and market demand.
• Support new launches, seasonal planning, and promotional events through proactive inventory and product planning.
• Continuously improve planning processes through automation, analytics, and data-driven decision-making.

Key KPIs

• Inventory Health & Ageing
• Days of Inventory (DOH)
• OSA / Fill Rate
• Stock-out %
• Lost Sales
• Sell-through %
• Inventory Turnover
• Molding Adherence
• Forecast Accuracy
• Working Capital Efficiency

Desired Skills & Experience

• Experience in Merchandise Planning, Inventory Planning, Buying, Category Management, or Ecommerce Planning.
• Strong product-first mindset with the ability to understand which products are performing, underperforming, and where assortment gaps exist.
• Good commercial acumen with the ability to convert business insights into inventory and production decisions.
• Advanced Microsoft Excel (Pivot Tables, XLOOKUP, INDEX-MATCH, SUMIFS); Power BI/Tableau knowledge preferred.
• Strong analytical, problem-solving, and stakeholder management skills.
• Experience working with large datasets, ERP systems (SAP preferred), and cross-functional teams in a fast-paced Ecommerce environment.

Ideal Candidate

A commercially driven planner who combines strong product intuition with analytical excellence. The ideal candidate is comfortable reviewing dashboards and evaluating the product range, with the ability to understand consumer trends, identify assortment gaps, prioritize production, and make inventory decisions that accelerate Ecommerce growth. They should apply strong merchandising judgment and use data to validate and scale decisions, rather than relying on numbers alone.