FP&A Assoc Analyst

PepsiCo Inc.; Ciudad de México; Sur place; MXN 360 000 - 600 000; Plein temps

Avantages offerts par ce poste

Wellness program

Flexibility program

Scholarship programs for children

Discounts and agreements

Résumé du poste

PepsiCo Inc. seeks a Cockpit Analyst to translate reporting needs into Tableau solutions, leveraging AI tools to accelerate delivery and improve accuracy. Early-career professionals will collaborate with Finance teams to build scalable dashboards and ensure data integrity.

The role emphasizes AI-enabled automation, standard methodologies, and close interaction with Operating Units to deliver impactful insights.

Qualifications

• 0-2 years of professional experience in finance, analytics, reporting, data, or related fields (incl. internships).
• Proficient with Tableau; able to use calculated fields, LODs, parameters, and dashboard actions.
• Practical, everyday use of generative AI tools (e.g., Claude, ChatGPT, Copilot).
• Basic SQL: read queries, trace data origins and joins.
• Strong analytical judgment; verify numbers before publishing.
• Advanced English (written and spoken).
• Comfort with ambiguity and a strong learning appetite.

Responsabilités

• Partner with Operating Units and Functions to gather and clarify reporting requirements.
• Design and build financial dashboards in Tableau with drill-down capability using standardized frameworks.
• Continuously improve dashboards for usability, performance and consistency.
• Analyze how end-users actually consume data and adapt designs accordingly.
• Ensure data security, compliance, and alignment with FP&A standards.
• Use generative AI tools daily: drafting docs, generating and debugging calculations and SQL.
• Design and refine prompts for repeatable processes and measure output quality.
• Critically review AI output to catch hallucinations or errors before business use.
• Identify repetitive work and propose automation with the team.
• Contribute to AI validation and quality frameworks as they scale.
• Collaborate with S&T teams to translate business requirements into Cockpit designs.
• Support training and enablement of Cockpit users.
• Deliver high-priority tactical projects within the Digital Finance Cockpit team.

Connaissances

Tableau

Generative AI

SQL

Analytical thinking

English (Advanced)

Learning mindset

Outils

Claude

ChatGPT

Copilot

Description du poste

Overview

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

TheOpportunity

The Digital Planning Transformation program is a global initiative to modernize how the organization plans, reports, and makes decisions, moving all Operating Units onto a single standardized platform, Cockpit, used today by 7,000+ users with 175,000+ monthly views.

We are past the "build dashboards" phase. The next phase is making reporting self-maintaining: dashboards that are automatically validated, documentation that writes itself, insights that surface without someone manually assembling them. Generative AI is now part of how this team works, not a side project.

As a Cockpit Analyst, you will translate business reporting needs into Tableau solutions, and you will use AI tooling to do it faster, check it more rigorously, and automate the parts of the job that shouldn't be manual. This is a role for someone early in their career who is genuinely fluent with AI tools and wants to build reporting products, not just reports.

YourImpact

• Partner with Operating Units and Functions to gather and clarify reporting requirements
• Design and build financial performance dashboards in Tableau with drill-down capability, following the team's standardized frameworks
• Continuously improve existing dashboards for usability, performance, and consistency
• Analyze how end-users (from analysts to senior leaders) actually consume data, and adapt designs accordingly
• Ensure data security, compliance, and alignment with corporate and Sector FP&A standards
• Use generative AI tools in daily delivery: drafting documentation, generating and debugging calculations and SQL, accelerating requirement analysis
• Design and refine prompts for repeatable team processes (validation, documentation, quality checks), and iterate on them based on measured output quality
• Critically review AI output,identify hallucinated logic, inconsistent results, and silent errors before they reach a business user. Knowing when not to trust the model matters more than knowing how to prompt it
• Identify manual, repetitive work in the reporting lifecycle and propose automation, working with the team to implement it
• Contribute to the team's AI validation and quality frameworks as they scale
• Work closely with S&T teams to ensure business requirements are accurately translated into Cockpit designs
• Support training and enablement of Cockpit users
• Deliver tactical, high-priority projects within the Digital Finance Cockpit team

Qualifications

Who Are We Looking For?

Experience

• 0-2 years of professional experience in finance, analytics, reporting, data, or a related field - including internships and academic projects
• Working proficiency in Tableau, with a portfolio, coursework, or certification you can walk us through. You should be comfortable with calculated fields, LODs, parameters, and dashboard actions
• Practical, everyday use of generative AI tools(Claude, ChatGPT, Copilot or similar) - you can show us a concrete example of something you built, automated, or solved faster because of it
• Basic SQL: able to read a query, understand joins, and trace where a number comes from
• Strong analytical judgment - you check whether a number makes sense before you publish it
• Advanced English (written and spoken)
• Comfort with ambiguity and a genuine appetite to learn; this team's tooling changes every few months

Whatcanyouexpectfromus:

• Opportunitiestolearnanddevelopeverydaythroughawiderangeofprograms.
• Internaldigitalplatformsthatpromoteself-learning.
• DevelopmentprogramsaccordingtoLeadershipskills.
• Specializedtrainingaccordingtotherole.
• Learningexperienceswithinternalandexternalproviders.
• Welovetocelebratesuccess,whichiswhywehaverecognitionprogramsforseniority,behavior,leadership,momentsoflife,amongothers.
• Financialwellnessprogramsthatwillhelpyoureachyourgoalsinallstagesoflife.
• Aflexibilityprogramthatwillallowyoutobalanceyourpersonalandworklife,adaptingyourworkingdaytoyourlifestyle.
• Andbecauseyourfamilyisalsoimportanttous,theycanalsoenjoybenefitssuchasourWellnessLine,thousandsofAgreementsandDiscounts,Scholarshipprogramsforyourchildren,AidPlansfordifferentmomentsoflife,amongothers.

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.