Merchandise Planning Analyst

Merchandise Planning Analyst Dunhams Sports - 3.0 Troy, MI Job Details Full-time 1 day ago Benefits Store discount Disability insurance Health insurance Dental insurance 401(k) Paid time off Vision insurance Qualifications Performance dashboard reports VLOOKUP function Dashboard development Assortment planning Statistics Inventory optimization Bachelor's degree in statistics Bachelor's degree in finance Merchandising Bachelor's degree in business Data reporting Mid-level Finance Demand forecasting Bachelor's degree Retail math 1 year Cross-functional collaboration Business Supply Chain Management Communication skills Cross-functional communication Excel data analysis

Full Job Description 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