Strategic CPFR & Forecasting Analyst

PepsiCo Inc.; Purchase (NY); On-site; USD 81,000 - 135,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Paid time off

Retirement plan

Job summary

PepsiCo is seeking a CPFR Analyst to drive forecast accuracy, optimize inventory, and lead joint business planning with major retail partners. You will develop statistical baseline forecasts from historical sales, seasonality, and promotions, and coordinate cross-functional teams to align demand with supply.

The role emphasizes data analysis, collaboration with Sales and Trade Marketing, and proactive exception management to ensure product availability while minimizing excess stock across the

Qualifications

• Bachelor's degree in supply chain, business, operations, or related field.
• 3+ years of experience in demand planning, supply chain planning, or retail replenishment.
• Hands-on CPFR, VMI, or collaborative replenishment experience.
• Proficiency in Excel and planning tools (NetSuite, SAP, Oracle, Blue Yonder).
• Familiarity with POS data, weeks of supply, sell-through, and on-shelf availability.
• Strong communication to manage external partner relationships.
• Experience with major retail accounts (e.g., Walmart, Target, Kroger, Costco).
• Knowledge of EDI transactions and retail data portals (Retail Link, Partner Online, 1WorldSync).

Responsibilities

• Own end-to-end CPFR process with retail partners, including joint business planning and replenishment execution.
• Develop and maintain baseline forecasts using historical data, seasonality, and promotions.
• Lead collaboration calls to align demand signals, promotional plans, and inventory targets.
• Identify and resolve forecast exceptions and supply/demand imbalances.
• Analyze POS data, sell-through, and weeks of supply to drive replenishment recommendations.
• Monitor in-stock levels and on-shelf availability across the retail chain.
• Support new item setup, seasonal transitions, and product lifecycle with partners.
• Collaborate with Sales, Trade Marketing, and Customer Service to include promo-driven demand in forecasts.
• Communicate supply constraints and risks to internal and external stakeholders.
• Contribute to IBP with retailer insights and dashboards tracking KPIs (MAPE, BIAS, fill rate).
• Identify opportunities to improve CPFR processes, tools, and partner engagement.
• Assist implementation or enhancement of planning systems and EDI/VMI integrations.

Skills

CPFR

VMI

Excel

Retail data analysis

Vendor relations

Forecasting

Inventory management

EDI knowledge

Education

Bachelor's degree in supply chain or related field

High School diploma required

Tools

NetSuite

SAP

Oracle

Blue Yonder

Job description

PepsiCo is seeking a CPFR Analyst to drive forecast accuracy, optimize inventory, and lead joint business planning with major retail partners. You will develop statistical baseline forecasts from historical sales, seasonality, and promotions, and coordinate cross-functional teams to align demand with supply.

The role emphasizes data analysis, collaboration with Sales and Trade Marketing, and proactive exception management to ensure product availability while minimizing excess stock across the