Business Intelligence Analyst

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.

The Opportunity

PepsiCo’s Digital Planning Transformation program is a global initiative designed to revolutionize our planning and reporting capabilities. Our goal is to unify all Operating Units (OUs) on a single, standardized planning platform—Cockpit—to enable real-time decision support, eliminate manual processes (Excel, PPT, PDF), and deliver an agile, user-friendly performance management tool.

Cockpit, PepsiCo’s digital performance reporting platform, serves over 7,000 users and generates 175,000 views per month, driving insights and efficiency across the organization.

This role operates within a fast-paced, high-autonomy environment that encourages experimentation, continuous learning, and close collaboration with data engineers and developers as part of PepsiCo’s global digital transformation.

Your Impact

In this role, you will:

• Partner with Business Teams: Collaborate with OUs and Functions to capture reporting needs and translate them into actionable solutions.
• Design & Develop Dashboards: Create end-to-end visual dashboards for financial performance. Enable drill-down capabilities for deeper insights. Take full ownership of end-to-end BI solutions, from understanding business logic to transforming data and developing scalable dashboards that meet business needs.
• Deploy Reporting Frameworks: Build harmonized dashboards aligned with corporate FP&A standards. Work with large and complex datasets, applying performance optimization techniques and helping to define BI best practices across the team.
• Drive Continuous Improvement: Identify enhancements to improve user experience and system performance. Prioritize and lead implementation of changes.
• Ensure Data Integrity & Security: Maintain compliance with financial data security and legal requirements. Guarantee consistency with Sector and Corporate FP&A reporting.
• Collaborate Across Teams: Work closely with S&T teams to ensure business requirements are accurately reflected in SPOT/Cockpit design. Collaborate directly with data engineers and developers to design new data pipelines and enable advanced analytics capabilities.
• Enable Adoption: Deliver training and support for Cockpit users.
• Lead Tactical Projects: Manage dashboard initiatives within the Cockpit Digital Finance team. Design new data pipelines along with the Data Engineering team to onboard new capabilities in Cockpit.

Qualifications

Who Are We Looking For?

• Proven experience in Management Reporting
• Systems and Data Management expertise
• Advanced Tableau or Power BI technical skills (MUST)
• Knowledge of Python and SQL is highly desirable
• 0–1 year of relevant work experience
• Advanced English

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.
• Recognition programs for seniority, behavior, leadership, moments of life, among others.
• Financial wellness programs to help you reach your goals in all stages of life.
• A flexibility program to balance your personal and work life, adapting your working day to your lifestyle.
• Family benefits such as Wellness Line, discounts, scholarship programs for children, and aid plans for different moments of life.

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 workforce and innovation for the organization.

The Opportunity

PepsiCo’s Digital Planning Transformation program is a global initiative designed to revolutionize our planning and reporting capabilities. Our goal is to unify all Operating Units (OUs) on a single, standardized planning platform—Cockpit—to enable real-time decision support, eliminate manual processes (Excel, PPT, PDF), and deliver an agile, user-friendly performance management tool.

Cockpit, PepsiCo’s digital performance reporting platform, serves over 7,000 users and generates 175,000 views per month, driving insights and efficiency across the organization.

This role operates within a fast-paced, high-autonomy environment that encourages experimentation, continuous learning, and close collaboration with data engineers and developers as part of PepsiCo’s global digital transformation.

As a Business Intelligence Analyst, you will play a pivotal role in shaping PepsiCo’s digital reporting ecosystem. You will partner with global sectors and functions to gather requirements, design and develop dashboards, and continuously enhance the Cockpit platform. This role is critical to delivering a common performance reporting solution that empowers leadership teams to identify trends, analyze performance, and take action.

Your Impact

In this role, you will:

• Partner with Business Teams: Collaborate with OUs and Functions to capture reporting needs and translate them into actionable solutions.
• Design & Develop Dashboards: Create end-to-end visual dashboards for financial performance. Enable drill-down capabilities for deeper insights. Take full ownership of end-to-end BI solutions, from understanding business logic to transforming data and developing scalable dashboards that meet business needs.
• Deploy Reporting Frameworks: Build harmonized dashboards aligned with corporate FP&A standards. Work with large and complex datasets, applying performance optimization techniques and helping to define BI best practices across the team.
• Drive Continuous Improvement: Identify enhancements to improve user experience and system performance. Prioritize and lead implementation of changes.
• Ensure Data Integrity & Security: Maintain compliance with financial data security and legal requirements. Guarantee consistency with Sector and Corporate FP&A reporting.
• Collaborate Across Teams: Work closely with S&T teams to ensure business requirements are accurately reflected in SPOT/Cockpit design. Collaborate directly with data engineers and developers to design new data pipelines and enable advanced analytics capabilities.
• Enable Adoption: Deliver training and support for Cockpit users.
• Lead Tactical Projects: Manage dashboard initiatives within the Cockpit Digital Finance team. Design new data pipelines along with the Data Engineering team to onboard new capabilities in Cockpit.