IBP Strategy Analyst

Descrizione del lavoro:

Overview

CAREERS TO SMILE ABOUT

At PepsiCo, you'll discover a place where our mission is to create smiles around the world. With a portfolio of more than 500 beloved brands including, Gatorade, Lay's and Quaker, our work touches millions of people every day.

At the heart of the company is a team of thinkers, creators, and problem-solvers who collaborate to innovate and turn ideas into action. Driven by innovation and a focus on creating joyful moments through food and drinks, our decisions are guided by consumer centricity, creating opportunities for our associates to do meaningful work and make a lasting impact in the communities we serve.

Whatever your role, you'll be part of a global community that values your ideas and empowers you to make an impact, on your career and on the world around you.
Responsibilities

The Opportunity

The primary purpose of this role is to support the Integrated Business Planning (IBP) organization by driving governance, visibility, and analytical control of the Total Portfolio Optimization (TPO) agenda.

Your Impact

1. Support the governance and control of the Total Portfolio Optimization (TPO) agenda, ensuring visibility of SKU performance, rationalization progress, and productivity commitments. (Execute)
2. Develop and maintain portfolio performance scorecards, tracking KPIs such as velocity, margin contribution, distribution, cannibalization, and obsolescence risk. (Execute)
3. Monitor SKU productivity and complexity indicators, identifying underperforming items and supporting data-driven rationalization recommendations. (Execute / Recommend)
4. Prepare analytical materials for PMR and IBP forums, consolidating portfolio insights into executive-ready summaries and dashboards. (Execute)
5. Ensure data consistency and governance across portfolio datasets, coordinating with Demand, Supply, Finance, and Commercial teams. (Consult / Inform)
6. Provide reporting support to S&OP, AOP, and S&OE processes, ensuring accurate and timely data availability. (Execute)
Qualifications

Who Are We Looking For?

* Strong analytical and financial acumen
* Advanced proficiency in Excel and Power BI
* Ability to manage and analyze large datasets
* Understanding of profitability drivers (mix, margin, velocity, distribution)
* Basic programming/data automation skills (SQL, Python, or similar preferred)
* Experience in CPG or fast-paced commercial environments preferred
* Strong data and technology savviness, with curiosity to continuously improve analytics solutions
* Ability to translate complex data into clear, business-relevant insights
* Structured thinking and problem-solving mindset
* Ability to work effectively in a fast-paced, cross-functional environment
* Proactive, self-starter attitude with strong ownership mentality
* Clear communication skills to engage both technical and non-technical stakeholders
* Strong ownership mindset and governance discipline
* High attention to detail and data integrity
* Cross-functional collaboration skills

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.

The Opportunity

The primary purpose of this role is to support the Integrated Business Planning (IBP) organization by driving governance, visibility, and analytical control of the Total Portfolio Optimization (TPO) agenda.

Your Impact

1. Support the governance and control of the Total Portfolio Optimization (TPO) agenda, ensuring visibility of SKU performance, rationalization progress, and productivity commitments. (Execute)
2. Develop and maintain portfolio performance scorecards, tracking KPIs such as velocity, margin contribution, distribution, cannibalization, and obsolescence risk. (Execute)
3. Monitor SKU productivity and complexity indicators, identifying underperforming items and supporting data-driven rationalization recommendations. (Execute / Recommend)
4. Prepare analytical materials for PMR and IBP forums, consolidating portfolio insights into executive-ready summaries and dashboards. (Execute)
5. Ensure data consistency and governance across portfolio datasets, coordinating with Demand, Supply, Finance, and Commercial teams. (Consult / Inform)
6. Provide reporting support to S&OP, AOP, and S&OE processes, ensuring accurate and timely data availability. (Execute)

Requisiti del candidato:

Who Are We Looking For?

* Strong analytical and financial acumen
* Advanced proficiency in Excel and Power BI
* Ability to manage and analyze large datasets
* Understanding of profitability drivers (mix, margin, velocity, distribution)
* Basic programming/data automation skills (SQL, Python, or similar preferred)
* Experience in CPG or fast-paced commercial environments preferred
* Strong data and technology savviness, with curiosity to continuously improve analytics solutions
* Ability to translate complex data into clear, business-relevant insights
* Structured thinking and problem-solving mindset
* Ability to work effectively in a fast-paced, cross-functional environment
* Proactive, self-starter attitude with strong ownership mentality
* Clear communication skills to engage both technical and non-technical stakeholders
* Strong ownership mindset and governance discipline
* High attention to detail and data integrity
* Cross-functional collaboration skills

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