Demand Planning Analyst

PepsiCo; Ciudad de México; Presencial; MXN 50,000 - 70,000; Jornada completa

Descripción de la vacante

A leading global food and beverage company in Mexico City is seeking a Demand Planning Analyst. This role involves developing accurate sales forecasts using data and statistical models. Responsibilities include supporting weekly processes, managing innovation forecasts, driving improvement in forecast accuracy, and collaborating with IT teams. The ideal candidate has a relevant degree and experience in business analytics, preferably with statistical modeling tools such as SAS, R, or Python. A supportive and inclusive workplace awaits you.

Servicios

Opportunities for learning and development

Internal digital platforms for self-learning

Recognition programs for achievements

Financial wellness programs

Formación

• Minimum of 1.5 years of experience developing and implementing business analytics solutions.
• Experience with statistical modeling for demand forecasting.
• Hands-on experience with SQL and large datasets.

Responsabilidades

• Support DP weekly processes including cuts review and bias review.
• Identify drivers of error with the statistical forecast.
• Manage division innovation forecasts and UPC end to end consolidation process.

Conocimientos

Fluent in English

Statistical modeling

Writing SQL queries

Data visualization

Educación

Bachelor’s or Master’s degree in Supply Chain, Business Analytics, Statistics, Economics, Engineering, Computer Science, or a related field

Herramientas

SAS

R

Python

Tableau

Power BI

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.

Know more: PepsiCoJobs

Join PepsiCo, dare for better.

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:

• Support DP weekly processes including cuts review, bias review, outliers and activity request forms
• Identify drivers of error with the stat forecast and work with stat forecasting partners to resolve.
• 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
• Work with division teams to drive improvement and visibility to B and C segment forecast accuracy
• Develop disaggregation analysis reporting and provide customer planners with opportunities to drive forecast accuracy through adjustments
• Support ad-hoc analytical needs as needed by developing programs, tools, analyzing data, and/or creating visualizations in Excel and/or Power Bi/Tableau
• 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.