Inventory Optimization Sr Analyst

PepsiCo Deutschland GmbH; Ciudad de México; Presencial; MXN 912,000 - 1,278,000; Jornada completa

Descripción de la vacante

A leading global food and beverage company is seeking a skilled individual for the role of Inventory Optimization support in Mexico City. This position includes responsibilities such as data management, running sensitivity analyses, and ensuring accurate input data for inventory management. Candidates should have a Bachelor's degree in related fields and experience with planning and inventory management, as well as proficiency in MS Excel, SQL, and SAP IBP. The company promotes a culture of learning and development, providing ample opportunities for career growth and flexible working arrangements.

Servicios

Opportunities for personal development

Recognition programs

Flexible work-life balance

Wellness programs

Formación

• 3-5 years of planning / inventory management experience.
• Fluent knowledge in MS Excel and business intelligence tools.
• Ability to navigate complex datasets and model scenarios.

Responsabilidades

• Support inventory optimization modeling and data analysis.
• Manage historical data and monitor data quality metrics.
• Run sensitivity analyses and create optimization scenarios.

Conocimientos

MS EXCEL

SQL

Python

Business Intelligence

Team collaboration

Educación

Bachelor degree in Supply Chain, Logistics, Operations Research, or Industrial Engineering

Advanced degree (MBA/MS) in relevant fields

Herramientas

SAP IBP

Power BI

Descripción del empleo

Overview

We Are PepsiCo

Join PepsiCo and Dare for Better! We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we're excited about the future and working together to make the world a better place.

Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries.

Our product portfolio, which includes 22 of the world's most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years.

A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you're from, or who you love, you can always influence the people around you and make a positive impact in the world.

Know more: PepsiCoJobs

Join PepsiCo, dare for better.

Responsibilities

The Opportunity

This role is to provide support to the PBNA Inventory Optimization modeling by collecting input data, cleaning or removing data discrepancy, running the models and analyzing the output. This role is responsible for data accuracy for all locations/material in scope for PBNA. The will entail monitoring data quality metrics, engaging SMEs in field and sector to determine appropriate input values for each parameter. Will include running sensitivity analyses to determine impact of a range of choices for input values have on the output values; analyze and review with IO team. This resource will also be required to initialize all the data and meet the exit criteria for exiting hypercare.

Your Impact

• Support IO/RP Division Capability Leads
• Make mass update master data updates upon request from Division
• Manage the business rules for default input values and ensure correct parameters setting
• Pull together historical data and summarize for SMEs review
• Run sensitivity studies upon request from Division CLs
• Monitor & respond to alerts found in IBP Analytics Stories
• Provide Visibility on Fix needed within IBP per Item Location
• Manage SKUs segmentation and lead inventory policies for each segment
• Identify and manage Inventory in Excess / stockouts on the network, leading action plans for improvements
• Run deep dives and what-if scenarios simulations for inventory management

• Support Cross functional partner FTS/IT
• Monitor for IO QoS Issues
• Implement model changes on current solution design
• Implement/Monitor input/output data consistency checks
• Investigate input data discrepancies (for e.g. schedule adherence < 60% in IO)

• Support Analytics/Visualization
• Update Inventory and Supply dashboards weekly
• Implement enhancements on current tools utilized to calculate optimal levels
• Perform data consistency checks on SAP Modules
• Create, share & respond to weekly Inventory levels to Review report
• Design different optimization scenarios for product/locations
• Reporting of missing master data for all NA product/locations
• Reporting of Changes in Forecast increase/decrease
• Provide Full detailed explanation on Inventory Results and give recommendations on parameter set

Qualifications

Who Are We Looking For?

• Bachelor degree in Supply Chain, Logistics, Operations Research, or Industrial Engineering
• Fluent knowledge and use of MS EXCEL, Powerpoint, Word, and Business Intelligence
• Knowledge of SAP IBP, SQL, Python and Power BI tools preferred
• 3-5 years of planning / Inventory management experience, E2E SC Knowledge
• Knowledge of Automation Tools and creating connections
• Ability to navigate complex datasets
• Flexible, ability to model “what if” scenarios with business acumen
• Effective team player
• Advanced degree (MBA/MS) in Supply Chain, Logistics, Operations Research, or Industrial Engineering is a plus

If this is an opportunity that interests you, we encourage you to apply even if you do not meet 100% of the requirements.

What can you expect from us:

• Opportunities to learn and develop every day through a wide range of programs.
• Internal digital platforms that promote self-learning.
• Development programs according to Leadership skills.
• Specialized training according to the role.
• Learning experiences with internal and external providers.
• We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others.
• Financial wellness programs that will help you reach your goals in all stages of life.
• A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle.

And because your family is also important to us, they can also enjoy benefits such as our Wellness Line, thousands of Agreements and Discounts, Scholarship programs for your children, Aid Plans for different moments of life, among others.

We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We respect and value diversity as a work force and innovation for the organization.