Fp&A Assoc Analyst

Pepsico; Xico; Presencial; MXN 420.000 - 540.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Learning programs

Digital self-learning platforms

Leadership development programs

Scholarship programs for children

Descripción de la vacante

PepsiCo in Mexico is seeking a LATAM Commercial Finance Analyst to support direct profit planning, reporting and control across LatAm. You will consolidate topline, NRR, innovation, and run OT P&L trackers, partnering with FP&A and Category Finance teams to deliver accurate data for decision making.

Responsibilities include SLA management, dashboard development, and quarterly AOP forecasting. Fluency in Spanish and English, strong Excel/Power BI skills, and solid knowledge of P&L drivers are

Formación

• Bachelor’s degree in business, economics or finance.
• Intermediate Excel skills required; Advanced Excel and PowerPoint preferred.
• Experience with Power Query, VBA and Power BI.
• Spanish native, English fluent.
• Strong understanding of P&L drivers.

Responsabilidades

• Consolidate LatAm topline, NRR, and innovation reporting.
• Lead and support LATAM COMCAT in OT P&L tracking and dashboards.
• Partner with FP&A and Category Finance to deliver accurate information.
• Ensure SLA fulfillment with GBS Finance clients in LatAm.
• Prepare Fcst/AOP forecasts and maintain planning models.

Conocimientos

Intermediate Excel skills

Advanced Excel and PowerPoint

Power Query

VBA

Power BI

Spanish native / English fluent

Educación

Bachelor’s Degree in business administration, economics or finance

Herramientas

Power BI

Power Query

VBA

Excel

PowerPoint

Descripción del empleo

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 MCC LATAM Commercial Finance analyst will play a key role in the LatAm’s direct profit planning, reporting and control. This role is responsible for the consolidation of LatAm’s Topline, NRR, Innovation and other ad-hoc reports. Lead OU´s CommCat consolidation and generating efficiencies. Interact and become business partner for OUs FP&A and Category Finance teams, delivering accurate information to lead decision making process and ensure Service Level Agreements (SLAs) fulfillment according to their target.

• Deliver an excellent service to GBS Finance clients according to SLA’s aligned with LatAm CommCat for Topline, NRR and Innovation consolidation and reporting processes.
• Quickly develop an understanding of LatAm financial objectives and commercial plans to effectively play a key role as a business partner.
• Lead and Support COMCAT Team in the construction of OT P&L Tracker consisiting of: requesting information to each LATAM OU, analyzing and consolidating information received and elaborate final dashboard with main results, KPIs and explanations of OT Performance in a quarter frecuency and also in AOP.
• Lead and elaborate LATAM D&A Performance Report, analyzing LATAM OUs D&A performance with the deep dive requested and focusing in White Swan Categories, giving visibility of each category to Finance and Commercial Teams (CCO).
• Follow up AdHocs monthly request by LatAm CommCat in order to assist CCO Teams in finance matters.
• LatAm Point Person for Topline Tracker, Innovation, NRR and COMCAT Reports.
• Support LatAm CommCat and Category Finance teams in the construction of Fcst and AOP reports to understand Topline main drivers and providing accurate and timely information to support decision making process.
• Load Innovation in Cockpit each Q.
• Lead recurrent sessions with all stakeholders to ensure alignment, new projects and priorities of the team.
• Owner of LatAm CommCat planning model’s responsible of their maintenance, updates and improvements.

Qualifications

Who Are We Looking For?

• Education - Bachelor’s Degree in business administration, economics or finance.
• Experience - Intermediate Excel skills needed.
• Advanced Excel and Power Point skills desired.
• Desired experience with Power Query, VBA and Power BI tools.
• Language: Spanish native / English fluent.
• Deep understanding of a P&L and its drivers.
• Blend of control/planning and field finance.
• Quick/Self learner and curiousity to explore new ways to manage tools and processes.
• Able to work without supervision.

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.

Equal Opportunity

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.