Forecast & Inventory Architect

Sietefoods 2; Austin (TX); On-site; USD 85,000 - 115,000; Full time

Job summary

PepsiCo in Austin, TX is seeking a Demand Planner to develop and maintain weekly sales order forecasts across customers and SKUs. You will collaborate with Sales, Supply Planning, and Production to align forecast timing with supply availability.

The role requires 2+ years in demand planning, strong Excel skills, and the ability to analyze historical data and marketing inputs to drive accurate forecasts.

Qualifications

• 2+ years of experience in demand planning or related fields is required.
• Strong Microsoft Excel skills including formulas, pivot tables, and data analysis is required.
• Knowledge of the consumer packaged goods industry is a plus but not required.
• Knowledge of data visualization tools or experience with demand planning software such as Anaplan or S&OP tools is a plus.

Responsibilities

• Develop and maintain accurate weekly sales order forecasts for all assigned customers and SKUs.
• Work with Sales, Supply Planning, and Production teams to align on sales order timing and supply availability.
• Understand and communicate the rationale and assumptions behind the sales order forecast as needed.
• Analyze historical data, channel inventory, and sales and marketing inputs to generate reliable sales order forecasts.
• Monitor and report on forecast accuracy, bias, and other key performance indicators.
• Support senior team members in cross-functional communication regarding forecast changes.
• Work with Supply Planning and Commercialization teams to develop inventory strategies for existing products, new launches, and phase-outs.
• Use planning tools and systems, suggesting potential improvements.
• Maintain the parameters and logic used by planning tools to convert the consumption forecast into the sales order forecast.
• Contribute to demand planning process improvement.
• Monitor and manage channel inventory levels.

Skills

Data analysis

Forecasting

Communication

Teamwork

Analytical thinking

Tools

Excel

Anaplan

S&OP tools

Job description

PepsiCo in Austin, TX is seeking a Demand Planner to develop and maintain weekly sales order forecasts across customers and SKUs. You will collaborate with Sales, Supply Planning, and Production to align forecast timing with supply availability.

The role requires 2+ years in demand planning, strong Excel skills, and the ability to analyze historical data and marketing inputs to drive accurate forecasts.