CPFR Analyst

PepsiCo • Town/Village of Harrison, NY

3d • $80,700 - $135,100

About The Position

The CPFR Analyst drives forecast accuracy, inventory optimization, and collaborative planning across PepsiCo’s retail network. Working across supply chain, sales, and operations, the analyst leads joint business planning with retail partners to support product availability while minimizing excess inventory. The role also contributes retailer insights to Integrated Business Planning and supports improvements to planning processes, systems, and partner engagement.

Requirements

• Bachelor’s degree in supply chain, Business, Operations, or a related field; a high school diploma is required.
• At least 3 years of experience in demand planning, supply chain planning, or retail replenishment within consumer goods or retail.
• Hands-on experience with CPFR, VMI (Vendor Managed Inventory), or collaborative replenishment programs.
• Strong analytical skills and proficiency in Excel.
• Familiarity with retail metrics including POS data, weeks of supply, sell-through, and on-shelf availability.
• Excellent communication skills and ability to manage external partner relationships.
• Knowledge of EDI transactions and retail data portals.

Nice To Haves

• Experience with planning tools such as NetSuite, SAP, Oracle, Blue Yonder, or similar.
• Experience working with major retail accounts such as Walmart, Target, Kroger, or Costco.
• Knowledge of retail data portals such as Retail Link, Partner Online, or 1WorldSync.

Responsibilities

• Own the end-to-end CPFR process with assigned retail partners, including joint business planning, forecast sharing, and replenishment execution.
• Develop and maintain statistical baseline forecasts using historical sales data, seasonal trends, and promotional activity.
• Lead regular collaboration calls with retail partners to align on demand signals, promotional plans, and inventory targets.
• Identify and proactively resolve forecast exceptions and supply/demand imbalances.
• Analyze point-of-sale (POS) data, sell-through rates, and weeks-of-supply metrics to drive replenishment recommendations.
• Monitor in-stock levels, on-shelf availability, and inventory positions across the retail supply chain.
• Support new item setup, seasonal transitions, and product lifecycle management with trading partners.
• Partner with Sales, Trade Marketing, and Customer Service teams to incorporate promotional and event-driven demand into forecasts.
• Communicate supply constraints and risks to internal stakeholders and external partners in a timely manner.
• Contribute key retailer insights to the Integrated Business Planning (IBP) process.
• Build and maintain dashboards and scorecards tracking KPIs such as forecast accuracy (MAPE/BIAS), fill rate, and on-shelf availability.
• Identify opportunities to improve CPFR processes, tools, and partner engagement.
• Support implementation or enhancement of planning systems and EDI/VMI integrations.

Benefits

• Performance-based bonus with an eligibility target payout of 5% of annual salary, paid annually.
• Paid time off subject to eligibility, including paid parental leave, vacation, sick, and bereavement leave.
• Medical, dental, vision, disability, health, and dependent care reimbursement accounts, subject to elections and eligibility.
• Employee Assistance Program (EAP).
• Accident, group legal, and life insurance, subject to elections and eligibility.
• Defined Contribution Retirement Plan.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level