Merchandise Planning Analyst

Overview Dunham's Sports Corporate Office, 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. Responsibilities 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

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