Merchandise Planning Analyst
Overview:
Dunham’s Sports Corporate Office is located in Troy, MI has an immediate opening for a Merchandise Planning Analyst. We are looking for a curious and innovative team player to join our growing Analytics team, in-person at our headquarters.
Position Summary:
As a Merchandise Planning Analyst, you will bring the financial strategy of our product vision to life by providing insights and guidance for our largest financial asset – our inventory. You will drive the success of our product lines by simulating data discoveries for profitability and productivity roadmaps.
Job Duties & Responsibilities
- Performance Analysis: Analyze historical performance and current trends to identify risks and opportunities by style, category and department.
- Forecasting & Planning: Create sales and inventory ladder plans (weekly/monthly/quarterly) that align with company budgets.
- Inventory Optimization: Manage Open-to-Buy (OTB) reports, forecasting receipt flow to ensure optimal inventory levels and maximize inventory turn while minimizing markdowns.
- Assortment Planning: Collaborate with Buying teams to develop assortment strategies that marry brand vision with customer needs.
- Reporting: Build and maintain comprehensive reporting dashboards tracking key performance indicators (KPIs) such as sell-through, inventory turn, and margin.
- Cross-functional Collaboration: Partner with Buying and Planning to align inventory needs with sales opportunities.
Qualifications
- Experience: 1–3+ years of experience in retail planning, allocation, inventory management, or merchandise analysis.
- Education: Bachelor’s degree in Business, Finance, Statistics, Supply Chain, or a related field.
- Technical Skills: Advanced proficiency in Microsoft Excel (pivot tables, v-lookups, complex formulas) is essential.
- Analytical Aptitude: Strong retail math skills with the ability to translate data into actionable business recommendations.
- Communication: Excellent communication skills, with the ability to present findings to cross-functional partners and senior management.
Benefits Include
- Merchandise discount
- Health, dental, and vision coverage
- Prescription plan
- Life, STD, LTD Insurance
- Vacation and PTO days
- 401 (K) Savings plan
