MCC Cost Modeling and Consolidation Coordinator – SoCo & Andean

PepsiCo Deutschland GmbH; Ciudad de México; Presencial; MXN 549,000 - 916,000; Jornada completa

Descripción de la vacante

A leading global food and beverage company located in Mexico City is seeking a Cost & Opex Modelling Consolidation Coordinator. This role involves leading financial processes, developing reporting frameworks, and collaborating with finance teams to drive insights. Candidates should have extensive experience in finance, strong analytical skills, and proficiency in tools like Excel and Power BI. Join us to contribute to making data-driven decisions and supporting financial strategies.

Servicios

Opportunities for learning and development

Flexibility program for work-life balance

Recognition programs for employees

Financial wellness programs

Formación

• 5 to 6 years of experience mainly in FP&A, Supply Chain Finance, or Cost Management.
• English fluency required.
• Experience in analyzing or forecasting Profit and Loss results.

Responsabilidades

• Lead the consolidation and visibility of COGS and Opex processes.
• Develop and manage a Power BI dashboard to visualize monthly variations.
• Design and implement a productivity tracking framework.

Conocimientos

Financial acumen

Microsoft Excel

PowerPoint skills

Problem-solving skills

Interpersonal skills

Analytical skills

Educación

University degree in Business

Accounting Designation / MBA

Herramientas

Essbase software

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

Andean and SoCo Cost & Opex modelling Consolidation Coordinator will play a key role in the Andean and SoCo direct profit planning, reporting and control. This role is responsible for providing a cost world class Global Business Service (GBS) for Mexico (all BU's). Responsible of elaborating cost analysis, actuals understanding and forecasting across PMF with special focus on direct cost and the consolidation of cost model. Interact and become business partner for OUs commercial finance and FP&A, deliver accurate information to lead decision making process and ensure cost Service Level Agreements (SLAs) fulfillment.

Primary Responsibilities & Value Contribution

• Lead the consolidation and visibility of COGS and Opex processes at the operational unit level (aggregated across markets), providing actionable insights and reporting for OU CFOs.
• Enhance granularity and control within the productivity tracking process, ensuring accurate flow and validation of initiatives and savings.
• Accelerate transformation and harmonization of financial processes across SoCo and Andinos, aligning with enterprise-wide goals for simplification and standardization.

Operational Impact & Alignment with Company Priorities

• Drive the consolidation of COGS and Opex across SoCo and Andinos, enabling clear visibility into key cost drivers and execution plans.
• Support the company's strategic priority of achieving Net Zero Inflation by ensuring robust tracking and alignment of productivity and operational plans.

Process Harmonization & Financial Governance

• Lead the harmonization of Opex processes for SoCo, mirroring the structured approach used in Andinos but shifting from country-level to P&L line-level analysis.
• Centralize and streamline the consolidation of base costs, investments, productivity initiatives, allocations, and S&T expenses to enable full E2E visibility of spending.

Digital Enablement & Reporting Automation

• Develop and manage a Power BI dashboard to visualize monthly variations across scenarios, sub-groupings, accounts, and cost owners.
• Respond to recurring requests from OU CFOs for scenario-based analysis by replacing manual file creation with automated, scalable reporting tools.

Productivity Process Development

• Design and implement a robust productivity tracking framework to monitor actuals and forecasts, ensuring visibility into where savings are landing.
• Enable standardized reporting of rate inflation by P&L line and account, improving transparency and decision‑making across finance and operations.

Qualifications

Who Are We Looking For?

• 5 to 6 years of experience mainly in FP&A, Supply Chain Finance, Sales Finance or Cost Management
• Financial acumen, and knowledge of PEP finance P&L drivers
• Proven record in delivering strategic change, results and customer expectations
• University degree in Business; Accounting Designation / MBA an asset but not required
• English fluency required
• Exceptional Microsoft Excel and PowerPoint skills are a key requirement
• Previous Essbase software experience an asset
• Experience in consumer products industry an asset
• Strong customer relations, interpersonal and verbal and written communications skills
• Strong organizational skills
• Strong technical, problem‑solving, planning, and analytical skills
• Experience in analyzing or forecasting Profit and Loss results
• Ability to work independently with minimal supervision

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.