Apparel Senior Analyst – Merchandising & Product

StrideLogic; Delhi; A distancia; INR 1.200.000 - 2.100.000; Jornada completa

Descripción de la vacante

Stride Logistics & Consultants is seeking a Senior Analyst – Merchandising & Product to support merchandising decisions across four U.S. apparel brands.

The role combines hands‑on merch Analytics with repeatable BI reporting and data models, delivered remotely from India. You will analyze sales by style, color and size, support open‑to‑buy planning, monitor inventory productivity, build Power BI dashboards, and reconcile data across ERP, ecommerce and order systems while collaborating with

Formación

• 4–7 years of experience in merchandise planning, buying, allocation or merchandising analytics within apparel or another seasonal, SKU‑intensive retail category.
• Strong working knowledge of OTB, sell‑through, receipts, weeks of supply, stock turn, markdowns, margins and size curves.
• Advanced Microsoft Excel skills, including PivotTables, Power Query, Power Pivot and complex planning workbooks.

Responsabilidades

• Analyze sales and product performance by style, color and size, including sell‑through, size curves and assortment productivity.
• Support open‑to‑buy (OTB) planning, receipt flow, on‑order tracking and plan‑versus‑actual analysis.
• Monitor inventory productivity, weeks of supply, stock turn, aging inventory and markdown exposure.
• Analyze gross‑to‑net margin, including landed costs, promotions, markdowns and returns; reconcile reporting with Finance.
• Evaluate return rates and reasons to support product development and size‑curve decisions.
• Contribute unit‑level demand forecasts and collaborate with marketing on traffic and conversion assumptions.
• Build and maintain Power BI dashboards, data models and automated weekly/monthly merchandising reporting.
• Investigate and reconcile discrepancies across ERP, ecommerce and order management systems.

Conocimientos

Power BI

SQL

Excel

Forecasting

Data modeling

Stakeholder comms

Merchandise analytics

Herramientas

Power Query

Power Pivot

Looker Studio

dbt

Anaplan

Descripción del empleo

Function: Analytics & Business Intelligence | Shared Services (4 apparel brands)

Employment Type: Contract

Experience: 4–7 years

Reporting To: Head of Analytics

Work Mode : Remote

We are seeking a Senior Analyst – Merchandising & Product to support merchandising and planning decisions across four U.S. apparel brands. The role combines hands‑on merchandise analysis with the development of repeatable reporting and business intelligence solutions.

What you will do

• Analyze sales and product performance by style, color and size, including sell‑through, size curves and assortment productivity.
• Support open‑to‑buy (OTB) planning, receipt flow, on‑order tracking and plan‑versus‑actual analysis.
• Monitor inventory productivity, weeks of supply, stock turn, aging inventory and markdown exposure.
• Analyze gross‑to‑net margin, including landed costs, promotions, markdowns and returns; reconcile reporting with Finance.
• Evaluate return rates and reasons to support product development and size‑curve decisions.
• Contribute unit‑level demand forecasts and collaborate with marketing on traffic and conversion assumptions.
• Build and maintain Power BI dashboards, data models and automated weekly/monthly merchandising reporting.
• Investigate and reconcile discrepancies across ERP, ecommerce and order management systems.

You are the right fit if

• 4–7 years of experience in merchandise planning, buying, allocation or merchandising analytics within apparel or another seasonal, SKU‑intensive retail category.
• Strong working knowledge of OTB, sell‑through, receipts, weeks of supply, stock turn, markdowns, margins and size curves.
• Advanced Microsoft Excel skills, including PivotTables, Power Query, Power Pivot and complex planning workbooks.
• Hands‑on Power BI development experience, including data modeling, relationships and DAX measures.
• Strong SQL skills, or demonstrated analytical capability with a clear ability to become proficient in SQL quickly.
• Experience reconciling product, sales or inventory data across multiple business systems.
• Ability to translate analysis into actionable buying, assortment or markdown recommendations.
• Strong stakeholder communication, analytical judgement and attention to detail.

Good to have

• Exposure to merchandise planning systems such as Anaplan, o9, RELEX, Blue Yonder or Oracle Retail.
• Experience with ERP platforms such as Microsoft Dynamics 365, NetSuite, SAP or BlueCherry.
• Experience in allocation, replenishment, forecasting, multi‑brand retail or both wholesale and D2C.
• Knowledge of Python, dbt, Looker Studio or related modeling and BI tools.

About the Client:

Our client is a U.S.-based apparel business supporting multiple brands through direct‑to‑consumer ecommerce, merchandising, marketing and analytics operations.

About Stride Logistics & Consultants:

Stride drives efficiency across the logistics industry through technology, digital transformation, and intelligent outsourcing, helping businesses operate smarter and scale faster.