Business Intelligence Analyst

PepsiCo; Ciudad de México; Presencial; MXN 300,000 - 450,000; Jornada completa

Descripción de la vacante

A global food and beverage leader is seeking a Business Intelligence Analyst in Ciudad de México. This role involves partnering with business teams to design and develop visual dashboards for financial performance, ensuring effective data management and adherence to corporate standards. Ideal candidates will have experience with Tableau or Power BI, and a strong foundation in data systems management.

Servicios

Opportunities for learning and development

Internal digital platforms for self-learning

Family benefits such as Wellness Line and discounts

Formación

• 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.

Responsabilidades

• Collaborate with OUs and Functions to capture reporting needs.
• Create end-to-end visual dashboards for financial performance.
• Build harmonized dashboards aligned with corporate FP&A standards.
• Identify enhancements to improve user experience.
• Maintain compliance with financial data security.
• Work closely with S&T teams to ensure business requirements are accurately reflected.
• Deliver training and support for Cockpit users.
• Manage dashboard initiatives within the Cockpit Digital Finance team.

Conocimientos

Management Reporting

Systems and Data Management

Advanced Tableau or Power BI

Python

SQL

Advanced English

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.

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.