Supply Chain Optimization Modeler

PepsiCo; United States; On-site; USD 100,000 - 150,000; Full time

Job summary

PepsiCo is seeking a Global Network Design Modeler to advance its next generation network design capabilities across the enterprise. The role focuses on developing, testing and refining optimization models that minimize cost while enabling growth and sustainability.

Responsibilities include building models with tools like Supply Chain Guru, Llamasoft, and SQL-based data workflows, collaborating with cross-functional teams to align recommendations and deliver measurable impact.

Qualifications

• BS degree in OR, IE or supply chain.
• 3+ years in supply chain planning/optimization.
• Translate business problems into analytical frameworks.
• Proficiency in Excel, Tableau and Power BI.
• Experience with SQL databases (nice to have).

Responsibilities

• Validate and implement advanced supply chain models and tools to optimize the E2E supply chain.
• Develop and maintain network optimization models to evaluate project hypotheses and strategic alternatives and quantify model changes in end-to-end supply chain.
• Translate complex business problems into optimization models using tools like Supply Chain Guru
• Utilize organizational systems and tools for data collection and to build project facts, benchmarking analyses, etc.
• Ability to evaluate optimization models inputs and outputs by data automation, executing models, analyzing data and reporting
• Partner with cross functional teams to provide necessary inputs for long term projects and ensure that project recommendations are organizationally aligned
• Ability to manage multiple tasks and priorities concurrently and work well under tight timelines
• Develops domain knowledge and SME in Network Modeling and analytics

Skills

Optimization modeling

Supply chain analytics

Llamasoft

Coupa SCG

JDA

Supply Chain Guru

Data Guru

Tableau

Power BI

SQL

Microsoft Office

Education

Bachelor’s degree in Operations Research, Industrial Engineering or Supply Chain

Tools

Llamasoft

Coupa SCG

JDA

Supply Chain Guru

Data Guru

SQL

Tableau

Power BI

Microsoft Office

Job description

Overview

This role supports the development of the next generation network design capability, enabling industry leading design capability for all Global business units, Sectors, and ND Global Capability Centers, across the End-to-End Value Chain.

This role is responsible for developing and refining network optimization modeling projects and analyses that help source, deploy, store, and deliver our portfolio of products to customers at the lowest cost while supporting long-term growth. The Global Network Design Modeler is responsible for driving the testing of advanced modeling tools and designing new approaches and systems to optimize our supply chain network. This role requires deep understanding of optimization algorithms, data science techniques and supply chain operations. Ultimately, this role will be responsible for building and analysing optimization models using state-of-the-art optimization software to create scalable and effective solutions.

This will enable identification of transformative projects that will deliver significant levels of profitability, efficiency, sustainability, and service, that align with the organization’s global operational objectives.

Responsibilities

• Support the validation and implementation of advanced supply chain models and tools to optimize the E2E supply chain.,
• Develop and maintain network optimization models to evaluate project hypothesis and strategic alternatives and quantify model changes in end-to-end supply chain.,
• Translate complex business problems into optimization models using tools like Supply Chain Guru
• Utilize organizational systems and tools for data collection and to build project facts, benchmarking analyses, etc.,
• Ability to evaluate optimization models inputs and outputs by data automation, executing models, analyzing data and reporting
• Partner with cross functional teams to provide necessary inputs for long term projects and ensure that project recommendations are organizationally aligned
• Ability to manage multiple tasks and priorities concurrently and work well under tight timelines
• Develops domain knowledge and Subject Matter Expertise (SME) in Network Modeling and analytics

Qualifications

• Bachelors Degree in Operations Research, Industrial Engineering/Supply Chain or similar.
• 3+ years of experience in a supply chain planning/optimization function utilizing Modelling & Technical Design tools, such as Llamasoft, Coupa SCG, JDA or similar.
• Ability to translate business problems into analytical frameworks
• Proficiency in Microsoft office suite, Tableau and Power BI
• Manage of big data bases on SQL or similar (nice to have)
• Use of Supply Chain Guru and Data Guru (must have)

Behavioral Competencies:

• Leadership
• Strong Communicator
• Results Oriented
• Agility to solve problems
• Analytical Thinking
• Teamwork
• Excellent interpersonal relationships