Demand Planner

We Are PepsiCo

Join PepsiCo and dare to transform! 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. PepsiCo Mexico is one of the most significant consumer product companies in the country. 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. 

Join PepsiCo, dare to transform. 

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 PBNA MBS Demand Planning Analyst your responsibilities would consist of

• 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
• 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
• Support DP weekly processes including cuts review, bias review, outliers and activity request forms
• Drive continuous improvement agenda by automating core processes including the case load in process
• Work with division teams to drive improvement and visibility to B segment forecast accuracy
• Identify drivers of error with the stat forecast and work with stat forecasting partners to resolve.

Who Are We Looking For? 

• Fluent in English
• Bachelor’s degree or master’s degree in supply chain, business analytics, statistics, economics, engineering, or computer science.
• A minimum of 1-1/2 years with a bachelor’s degree in developing and implementing business analytics applications is required. Prior work experience must include 1 year of experience in the following areas

1. Desirable knowledge on statistical modeling and programming using SAS or R or Python, preferably for demand forecasting.
2. Working with large volumes of data and proficiency in writing SQL queries on relational databases like Teradata, Oracle, DB2, and SQL Server is a plus.
3. Full proficiency on Excel (macros).
4. Creating insights and visualization using PowerBI, and/or Excel/VBA, Tableau is a plus.
5. Researching data and processes to identify root causes of supply chain issues such as low products supply, low sales, irregular promotions effects, seasonal changes in sales
6. Working with IT support teams on projects such as the technical implementation of supply chain tools and upgrading and supporting systems and software
7. Experience in implementing or using demand forecasting software and understanding 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.