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 general 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.
- 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 dev

📌 b Commercial Data Analyst (Miguel Hidalgo)
🏢 PEPSICO
📍 Miguel Hidalgo