Demand Supply Planner

24 Seven Talent; New York (NY); On-site; USD 65,000 - 90,000; Full time

Job summary

24 Seven Talent is seeking a detail-oriented Supply & Demand Planning Analyst to support demand planning, supply planning, and related supply chain operations. The role relies heavily on Excel, SAP, IBP, and BW to organize and validate data.

Ideal candidates will have advanced Excel skills, strong data-management capabilities, and the ability to collaborate with cross-functional teams to forecast and optimize inventory and replenishment processes.

Qualifications

• Advanced Excel data cleaning, analysis, reporting, and formula-driven workbooks.
• Strong data-management skills with high attention to detail.
• Working knowledge of supply chain, inventory, demand planning, or supply planning concepts.
• Experience with SAP, IBP, BW, or similar planning systems preferred.
• Power BI and/or Power Query experience is a plus.

Responsibilities

• Support SRP organization and data entry, including following up with Marketing and entering pricing into IBP and the master price file.
• Clean negative forecasts and manage set carryover activities.
• Refresh the repack file and communicate changes to ZCAT dates.
• Refresh the sellout forecast alert file and run monthly sellout statistical models in IBP.
• Refresh the forecast tool at the beginning of each month and provide ongoing demand forecasting support.
• Update ABC status in SAP and maintain accurate planning data.
• Assist with managing promotional allocations throughout the season.
• Clean and maintain historical sales data to support planning analysis.
• Contribute to planning and supply chain projects by collecting, organizing, and cleansing data.
• Prepare and distribute the weekly inventory report.
• Export supply data and complete weekly logistics status checks.
• Prepare monthly air shipment and outstanding purchase order reports.
• Track back orders and promotional supply to support timely issue identification and follow-up.

Skills

Excel proficiency

Data management

Supply chain knowledge

Communication

Cross-functional collaboration

Tools

SAP

IBP

BW

Power BI

Power Query

Job description

Our client in the beauty space is seeking a detail-oriented Supply & Demand Planning Analyst to provide temporary support across demand planning, supply planning, and related supply chain operations. Most work will be performed using Excel, SAP, IBP, and BW. The ideal candidate brings strong Excel and data-management capabilities, a solid understanding of supply chain fundamentals, and the ability to organize, validate, and interpret business data. Experience with Power BI and Power Query is a plus.

Responsibilities:

• Support SRP organization and data entry, including following up with Marketing and entering pricing into IBP and the master price file.
• Clean negative forecasts and manage set carryover activities.
• Refresh the repack file and communicate changes to ZCAT dates.
• Refresh the sellout forecast alert file and run monthly sellout statistical models in IBP.
• Refresh the forecast tool at the beginning of each month and provide ongoing demand forecasting support.
• Update ABC status in SAP and maintain accurate planning data.
• Assist with managing promotional allocations throughout the season.
• Clean and maintain historical sales data to support planning analysis.
• Contribute to planning and supply chain projects by collecting, organizing, and cleansing data.
• Prepare and distribute the weekly inventory report.
• Export supply data and complete weekly logistics status checks.
• Prepare monthly air shipment and outstanding purchase order reports.
• Track back orders and promotional supply to support timely issue identification and follow-up.

What You’ll Bring

• Advanced proficiency in Microsoft Excel, including data cleaning, analysis, reporting, and formula-driven workbooks.
• Strong data-management skills with exceptional attention to detail and accuracy.
• Working knowledge of supply chain, inventory, demand planning, or supply planning concepts.
• Experience with SAP, IBP, BW, or similar enterprise planning systems is preferred.
• Experience with Power BI and/or Power Query is a plus.
• Ability to manage recurring deliverables while adapting to changing priorities and project needs.
• Clear communication skills and a collaborative approach to working with cross-functional teams.