Inventory Optimization & Replenishment Planner

Prism Public Affairs; Mechanicsburg (Cumberland County); On-site; USD 65,000 - 85,000; Full time

Job summary

Prism Public Affairs is seeking a Supply Chain Planner to own inventory replenishment across locations, translating demand signals into actionable purchasing decisions. You will balance working capital with service levels while collaborating with Sales, Operations, and suppliers to optimize inventory turns.

The role requires strong analytical skills, advanced Excel usage, and ERP experience (Sage X3). You will manage reorder points, safety stock, and buy plans while driving KPI improvements and

Qualifications

• Strong analytical and problem-solving ability to balance demand and inventory decisions.
• Comfortable making decisions with imperfect data and aligning cross-functional teams.
• Must be highly organized and able to manage multiple priorities in a fast-paced environment.

Responsibilities

• Own inventory replenishment strategy and execution across product lines and locations.
• Set and manage reorder points, safety stock levels, and order quantities.
• Make daily/weekly purchasing and transfer decisions based on demand and constraints.
• Monitor stockouts, excess, and slow-moving items to optimize turns.
• Collaborate with Sales and Operations to align on priorities and constraints.
• Develop reporting and insights to improve replenishment decisions and forecasting.

Skills

Analytical thinking

Problem-solving

Decision-making

Cross-functional collaboration

Ownership mindset

Ambiguity tolerance

Organizational skills

Education

High school degree / GED

Bachelor’s degree in business administration / supply chain / related field

2–5+ years in supply chain, inventory planning, replenishment, or demand planning

Experience in distribution, manufacturing, multi-location inventory environments

Tools

Sage X3

Excel

Job description

Prism Public Affairs is seeking a Supply Chain Planner to own inventory replenishment across locations, translating demand signals into actionable purchasing decisions. You will balance working capital with service levels while collaborating with Sales, Operations, and suppliers to optimize inventory turns.

The role requires strong analytical skills, advanced Excel usage, and ERP experience (Sage X3). You will manage reorder points, safety stock, and buy plans while driving KPI improvements and