S&OP Forecasting & Analytics Lead

Caterpillar Inc.; Peoria (IL); On-site; USD 98,000 - 146,000; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401(k) savings plans

Paid time off

Job summary

Caterpillar Inc. is seeking a data-driven professional for its Peoria, IL area to lead forecasting and S&OP activities within the Supply Chain and Logistics function.

You will build monthly forecasts, analyze variances, and align plans with the financial business strategy, leveraging Excel, Snowflake, Power BI, and related tools. The role requires strong collaboration across functions, a detail-oriented mindset, and over five years of relevant experience in forecasting and data analysis.

Qualifications

• A college or university degree.
• Experience supporting a Sales & Operations Planning (S&OP) environment.
• Advanced skills with data systems such as Excel, Snowflake, Power BI, Power Query, Power Automate, BIC.
• Experience developing demand forecasts, and analyzing variance.
• Over 5 years of progressively responsible job-related knowledge.
• Knowledge of Large Track Type Tractor machines, applications, and customers.
• Experience working with business resource (accounting), and factory scheduling teams.
• Continuous improvement mindset, able to create a vision for an improved future state, and execute.

Responsibilities

• Create a monthly product group forecast based on changes in supply and demand, identifying risks and opportunities.
• Provide supporting facts, data and statistics to support the business forecast and related changes.
• Use enterprise tools to input and adjust shipment plans and the product group forecast. Adjust the shipment plan and order coverage status based on actual monthly results.
• Perform data analysis for key performance metrics, including a comparison of how actual results compare to the forecast.
• Determine and report the results for various S&OP metrics.
• Assist with aligning the product group forecast to the financial business plan.

Skills

Forecasting

Data Gathering & Analysis

Analytical Thinking

Accuracy & Detail

Collaboration

Education

Bachelor's degree

Tools

Excel

Snowflake

Power BI

Power Query

Power Automate

BIC

Job description

Caterpillar Inc. is seeking a data-driven professional for its Peoria, IL area to lead forecasting and S&OP activities within the Supply Chain and Logistics function.

You will build monthly forecasts, analyze variances, and align plans with the financial business strategy, leveraging Excel, Snowflake, Power BI, and related tools. The role requires strong collaboration across functions, a detail-oriented mindset, and over five years of relevant experience in forecasting and data analysis.