Demand Planning Analyst

PepsiCo Deutschland GmbH; México; Presencial; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A leading global food and beverage company is looking for a Demand Planning Analyst in Mexico. The role involves developing accurate sales forecasts to support business success, leveraging statistical models, and driving continuous improvement processes. Candidates should have a degree in a related field and experience in statistical modeling and SQL. The company offers development programs and a flexible work culture to support employees' personal and professional growth.

Servicios

Opportunities for learning and development

Recognition programs

Financial wellness programs

Flexibility program

Formación

• Fluent in English.
• Bachelor’s or Master’s degree in Supply Chain, Business Analytics, Statistics, Economics, Engineering, Computer Science, or a related field.
• Minimum of 1.5 years of experience with a Bachelor’s degree developing and implementing business analytics solutions.

Responsabilidades

• Support DP weekly processes including cuts review and bias review.
• Identify drivers of error with the statistical forecast and resolve issues.
• Manage division innovation forecasts by adjusting raw case forecasts.

Conocimientos

Fluent in English

Statistical modeling

SQL Queries

Data visualization

Data analysis

Educación

Bachelor’s or Master’s degree in relevant field

Herramientas

SAS

R

Python

Tableau

Power BI

Excel (VBA)

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.

Responsibilities

The Opportunity

The Demand Planner contributes to PepsiCo Beverages success by developing accurate sales forecasts. This is accomplished by leveraging data and statistical models to guide the decision‑making process for the assigned markets in consultation with other key process stakeholders.

Your Impact

As Demand Planning Analyst your responsibilities would consist of:

1. Support DP weekly processes including cuts review, bias review, outliers and activity request forms
2. Identify drivers of error with the stat forecast and work with stat forecasting partners to resolve
3. Manage division innovation forecasts by reviewing and adjusting raw case forecast and planner codes and working with the sector team to incorporate strategic direction. Own UPC end to end consolidation process
4. Work with division teams to drive improvement and visibility to B and C segment forecast accuracy
5. Develop disaggregation analysis reporting and provide customer planners with opportunities to drive forecast accuracy through adjustments
6. Support ad-hoc analytical needs as needed by developing programs, tools, analyzing data, and/or creating visualizations in Excel and/or Power Bi/Tableau
7. Drive continuous improvement agenda by automating core processes including the case load in process

Qualifications

Who Are We Looking For?

• Fluent in English
• Bachelor’s or Master’s degree in Supply Chain, Business Analytics, Statistics, Economics, Engineering, Computer Science, or a related field.
• Minimum of 1.5 years of experience with a Bachelor’s degree developing and implementing business analytics solutions.
• At least 1 year of hands‑on experience in:
  • Statistical modeling and programming using SAS, R, or Python, preferably applied to demand forecasting.
  • Working with large datasets and writing SQL queries in relational databases such as Teradata, Oracle, DB2, or SQL Server.
  • Using UNIX environments, including shell scripting, and VBA macros in Excel.
  • Developing insights and data visualizations using Tableau, Power BI, and/or Excel (VBA).
• Ability to analyze data and processes to identify root causes of supply chain challenges, including product shortages, low sales performance, irregular promotion impacts, and seasonality effects.
• Experience collaborating with IT and technical support teams on initiatives such as system implementations, upgrades, and ongoing support.
• Experience implementing or using demand forecasting tools, with a solid understanding of the demand planning process.

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.