16 Oct
|
StrideLogic
|
India
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
· Apparel industry experience is mandatory,
with 4–7 years of hands-on experience in apparel merchandising, merchandise planning, buying, allocation, or product analytics within an apparel brand, fashion retailer, or apparel-focused e-commerce business.
· Strong technical and analytical background is essential, with advanced Microsoft Excel proficiency, including PivotTables, Power Query, Power Pivot, and complex planning workbooks.
· Hands-on Power BI development experience is mandatory, including dashboard development, data modeling, relationships, DAX measures, and automated reporting.
· Solid SQL proficiency with the ability to independently extract, analyze, validate, and reconcile large datasets.
· Excellent spoken and written English communication skills are mandatory, with clear articulation, strong comprehension, and the confidence to present analytical findings to U.S.-based stakeholders.
· In-depth practical knowledge of apparel merchandising KPIs, including style-color-size analysis, size curves, sell-through, open-to-buy (OTB), receipts, weeks of supply, stock turn, markdowns, and margins.
· Experience in merchandise planning, inventory analysis, demand forecasting, assortment optimization, and product performance evaluation.
· Proven ability to reconcile product, sales, inventory, and financial data across ERP, e-commerce, and order management systems.
· Ability to independently develop, validate, troubleshoot, and maintain merchandising dashboards, analytical models, and recurring business reports.
· Strong commercial understanding with the ability to translate complex data into actionable buying, assortment, inventory, and markdown recommendations.
· Excellent analytical judgment, problem-solving abilities, attention to detail, and cross-functional collaboration skills.
· Comfortable working remotely and coordinating effectively with U.S.-based teams across different time zones.
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.
📌 Apparel Senior Analyst – Merchandising & Product (India)
🏢 StrideLogic
📍 India