Financial Data Analyst

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

Descripción de la vacante

Join PepsiCo as a GCC LAB FP&A Analyst and play a key role in Latin America's Beverage business. You'll be responsible for supporting financial planning, report generation, and process improvements, ensuring accurate financial insights for decision-making. Opportunities for advancement and a culture that values diversity await you.

Servicios

Opportunities to learn and develop

Leadership development programs

Flexible work arrangements

Recognition programs

Formación

• C1-C2 English proficiency is required.
• Minimum 2 years in financial planning and modeling.
• Strong understanding of P&L and its interrelations.

Responsabilidades

• Coordinate monthly closings and consolidate relevant reports.
• Manage P&L information and prepare forecast reports.
• Run P&L checks and allocate expenses properly.

Conocimientos

Financial Analysis

Data Integrity

Excel

Power BI

PowerPoint

SharePoint

Teams

Tableau

Educación

Finance

Accounting

Industrial Engineering

Computer Engineering

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

GCC LAB FP&A Analyst will play a key role in LATAM’s Beverage business. This role is responsible for supporting report generation and consolidation of a world-class GCC for LAB Mexico. Supporting digital transformation, financial planning, innovation from a financial standpoint, and providing accurate financial and volume information to support decision-making. Additionally, it aims to become a business partner for CU by providing financial insights for decision-making and process improvement.

Your Impact

As a Finance Analyst, your responsibilities include:

• Monthly Closing: Coordinate with teams like Operations and Franchise for concentrate units closing information, consolidate in templates, analyze variations, and prepare relevant reports.
• P&L Latest Estimate (LE): Manage P&L information in LAB’s MS Teams, aligned with CU FP&A team.
• Mosaic: Upload monthly closings into TM1 (Mosaic), ensuring data accuracy across systems.

Monthly Forecast

• Sell Out: Prepare and consolidate volume forecast reports, analyze trends, lead review meetings, and update forecasts as needed.
• Sell In: Request and consolidate BOY forecasts, update projections, and ensure rationale alignment with teams.
• Mosaic: Upload forecast data into TM1, managing inputs and processes for accuracy.

HFM: Run P&L checks to ensure correct uploads and process closure, and allocate expenses properly.

Qualifications

Who Are We Looking For?

Education: Finance, Accounting, Industrial Engineering, or Computer Engineering.

Experience:

• Proficient in English (C1-C2)
• Minimum 2 years in financial planning and modeling
• Strong understanding of P&L and its interrelations
• Expertise in financial analysis, handling large data, and maintaining data integrity
• Advanced skills in Excel, PowerPoint, SharePoint, Teams, Power BI, and Tableau.

We encourage you to apply even if you don't meet 100% of the requirements.

What can you expect from us:

• Opportunities to learn and develop through various programs
• Internal digital platforms for self-learning
• Leadership development programs
• Specialized training and learning experiences
• Recognition programs and wellness benefits
• Flexible work arrangements and family benefits

We are an equal opportunity employer and value diversity. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability. We believe diversity fosters innovation and strengthens our organization.