B2B Commercial Data Analyst

Beschreibung:

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 in Mexico City

Join PepsiCo's Global Capability Center, where we deliver centralized business services that enable digital transformation and commercial growth across multiple markets.
As a B2B Data Analyst, you will play a key role in turning complex data into actionable insights that drive business decisions and improve commercial performance. You will support a digital platform designed for the direct sales channel, helping traditional trade customers access products, place orders, and strengthen their connection with PepsiCo.
In this role, you will partner with Digital Product teams, Commercial stakeholders, and Business Units across different markets to ensure data accuracy, build meaningful reporting solutions, and uncover opportunities that enhance customer engagement, sales execution, and business growth.
This is an excellent opportunity for a data-driven professional who enjoys solving business challenges, influencing decisions through analytics, and working in a fast-paced global environment.

What You'll Do

* Develop, maintain, and optimize interactive dashboards and reports using Power BI to support strategic and operational decision-making.
* Extract, transform, and analyze large datasets from multiple sources using SQL and other analytical tools.
* Design scalable data models, metrics, and performance indicators that provide clear visibility into business performance.
* Partner with Digital Product teams and business stakeholders to understand reporting needs and translate them into impactful analytical solutions.
* Ensure the quality, integrity, and consistency of data across reports, dashboards, and reporting environments.
* Identify opportunities to automate reporting processes and improve data workflows, increasing efficiency and reducing manual effort.
* Conduct ad hoc analyses to uncover trends, business risks, customer behaviors, and growth opportunities.
* Support the development of reporting standards, documentation, and best practices to improve data governance and scalability.
* Contribute to advanced analytics initiatives, including data engineering projects, predictive analytics, and process optimization opportunities.
Qualifications

What We're Looking For

Required Experience & Skills

* Proven experience developing business intelligence solutions using Power BI, including dashboard creation, data modeling, and performance optimization.
* Advanced SQL skills with experience extracting, transforming, and analyzing data from multiple sources.
* Advanced Microsoft Excel capabilities for data analysis and reporting.
* Experience using Python for data analysis, automation, or process improvement.
* Strong analytical and problem-solving skills with the ability to convert data into meaningful business recommendations.
* English.
* Ability to understand business requirements and translate them into technical and analytical solutions.
* Excellent communication and stakeholder management skills, with the ability to present insights to both technical and non-technical audiences.

Preferred Qualifications

* Experience working with cloud-based data platforms and big data technologies such as Databricks or PySpark.
* Familiarity with enterprise systems and business applications, including enterprise resource planning, customer relationship management, survey platforms, and digital analytics tools.
* Knowledge of modern data architectures, data engineering concepts, and database technologies.
* Experience supporting data pipelines, data integration processes, or analytics automation initiatives.
* Exposure to predictive analytics, machine learning, or advanced statistical analysis.
* Previous experience in consumer goods, e-commerce, digital commerce, or business-to-business sales environments.

Why Join PepsiCo?

* Work on high-impact digital initiatives that influence commercial performance across multiple markets.
* Collaborate with global teams and business leaders in a highly visible role.
* Gain exposure to modern analytics technologies and large-scale data environments.
* Drive meaningful business decisions through data and insights.
* Be part of a culture that values innovation, continuous learning, and professional growth.
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.
 
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.

The Opportunity in Mexico City

Join PepsiCo's Global Capability Center, where we deliver centralized business services that enable digital transformation and commercial growth across multiple markets.
As a B2B Data Analyst, you will play a key role in turning complex data into actionable insights that drive business decisions and improve commercial performance. You will support a digital platform designed for the direct sales channel, helping traditional trade customers access products, place orders, and strengthen their connection with PepsiCo.
In this role, you will partner with Digital Product teams, Commercial stakeholders, and Business Units across different markets to ensure data accuracy, build meaningful reporting solutions, and uncover opportunities that enhance customer engagement, sales execution, and business growth.
This is an excellent opportunity for a data-driven professional who enjoys solving business challenges, influencing decisions through analytics, and working in a fast-paced global environment.

What You'll Do

* Develop, maintain, and optimize interactive dashboards and reports using Power BI to support strategic and operational decision-making.
* Extract, transform, and analyze large datasets from multiple sources using SQL and other analytical tools.
* Design scalable data models, metrics, and performance indicators that provide clear visibility into business performance.
* Partner with Digital Product teams and business stakeholders to understand reporting needs and translate them into impactful analytical solutions.
* Ensure the quality, integrity, and consistency of data across reports, dashboards, and reporting environments.
* Identify opportunities to automate reporting processes and improve data workflows, increasing efficiency and reducing manual effort.
* Conduct ad hoc analyses to uncover trends, business risks, customer behaviors, and growth opportunities.
* Support the development of reporting standards, documentation, and best practices to improve data governance and scalability.
* Contribute to advanced analytics initiatives, including data engineering projects, predictive analytics, and process optimization opportunities

Ihr Profil:

What We're Looking For

Required Experience & Skills

* Proven experience developing business intelligence solutions using Power BI, including dashboard creation, data modeling, and performance optimization.
* Advanced SQL skills with experience extracting, transforming, and analyzing data from multiple sources.
* Advanced Microsoft Excel capabilities for data analysis and reporting.
* Experience using Python for data analysis, automation, or process improvement.
* Strong analytical and problem-solving skills with the ability to convert data into meaningful business recommendations.
* English.
* Ability to understand business requirements and translate them into technical and analytical solutions.
* Excellent communication and stakeholder management skills, with the ability to present insights to both technical and non-technical audiences.

Preferred Qualifications

* Experience working with cloud-based data platforms and big data technologies such as Databricks or PySpark.
* Familiarity with enterprise systems and business applications, including enterprise resource planning, customer relationship management, survey platforms, and digital analytics tools.
* Knowledge of modern data architectures, data engineering concepts, and database technologies.
* Experience supporting data pipelines, data integration processes, or analytics automation initiatives.
* Exposure to predictive analytics, machine learning, or advanced statistical analysis.
* Previous experience in consumer goods, e-commerce, digital commerce, or business-to-business sales environments.

Why Join PepsiCo?

* Work on high-impact digital initiatives that influence commercial performance across multiple markets.
* Collaborate with global teams and business leaders in a highly visible role.
* Gain exposure to modern analytics technologies and large-scale data environments.
* Drive meaningful business decisions through data and insights.
* Be part of a culture that values innovation, continuous learning, and professional growth.
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.
 
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