Apparel Senior Analyst Merchandising & Product

About the job

Senior Analyst – Merchandising & Product

Industry: Merchandising & Product Analytics – Apparel

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

For expedited review, please reach out to [Confidential Information]