Demand & Supply Planning Analyst - Excel & SAP Expert

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

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.