Apparel Planning & Forecasting Specialist

Dana-co LLC; New York (NY); On-site; USD 55,000 - 75,000; Full time

Job summary

Dana-co LLC seeks a Planning Associate to support inventory planning, forecasting, sales analysis, and reporting for a high-volume apparel business. You will work with Planning, Sales, Merchandising, and Operations to turn SKU-level data into actionable recommendations.

The role requires 2–3 years of planning/analysis experience, strong Excel skills, and comfort with large datasets. You will help automate reporting and communicate insights to stakeholders across teams.

Qualifications

• 2–3 years of planning, merchandising, or analytical experience.
• Strong Excel skills required.
• Experience handling large datasets and high SKU counts.

Responsibilities

• Support weekly, monthly, and seasonal sales, inventory, and demand planning across brands and sales channels.
• Maintain and analyze forecasts at the style, color, size, and SKU level using historical sales trends and current performance.
• Monitor sales, inventory, weeks of supply, sell-through, receipts, and forecast performance.
• Identify inventory shortages, overstock, replenishment opportunities, and emerging sales trends.
• Analyze SKU, style, color, and size productivity to support buying, replenishment, allocation, and inventory recommendations.
• Maintain recurring weekly and monthly reporting and develop ad hoc analyses to answer business questions.
• Work with large datasets from multiple sources, ensuring data is accurate, consistent, and actionable.
• Use Excel to build and maintain PivotTables, formulas, lookups, and repeatable analytical tools.
• Translate detailed analysis into clear findings, risks, opportunities, and recommended actions.
• Help improve and automate recurring planning and reporting processes to increase efficiency and accuracy.
• Partner with Sales and Merchandising teams to understand product performance and upcoming business needs.
• Work with Operations to monitor inventory availability and incoming receipts.
• Assist with seasonal buys, forecasts, product launches, and inventory reviews.
• Ensure planning reports and underlying data are accurate and delivered on schedule.
• Communicate inventory risks and opportunities clearly to appropriate stakeholders.

Skills

Planning analytics

Excel proficiency

Data analysis

Cross-functional

Tools

Excel

Job description

Dana-co LLC seeks a Planning Associate to support inventory planning, forecasting, sales analysis, and reporting for a high-volume apparel business. You will work with Planning, Sales, Merchandising, and Operations to turn SKU-level data into actionable recommendations.

The role requires 2–3 years of planning/analysis experience, strong Excel skills, and comfort with large datasets. You will help automate reporting and communicate insights to stakeholders across teams.