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

We are a Global Capability Center (GCC) team delivering centralized business services. Our scope supports Pepsiconnect / MiNegocio+ a B2B mobile application focused on the direct sales channel (traditional trade customers), enabling commercial execution, product visibility, and sales growth. Within the team, the Data Analyst plays a critical role in transforming raw application and operational data into actionable insights that drive business decisions across markets. This role will work closely with cross-functional teams-including Digital products & Services and Business Units-to ensure data accuracy, reporting consistency, and insight generation that enhances commercial performance. The ideal candidate combines strong analytical expertise with business acumen and a proactive mindset to support continuous improvement in a fast-paced, data-driven environment.

Your Impact

* Develop, maintain, and enhance Power BI dashboards and reports to support business decision-making across markets.
* Extract, transform, and analyze data from application backends and databases using SQL and other querying tools.
* Design and optimize data models, measures, and KPIs for scalable reporting solutions.
* Collaborate with cross-functional teams (Digital Products and services, and business stakeholders) to understand data needs and translate them into analytical solutions.
* Ensure data quality, integrity, and consistency across reports and datasets.
* Automate reporting processes and improve data workflows to increase efficiency.
* Perform ad hoc analyses to identify trends, risks, and opportunities within the direct sales channel.
* Support the documentation and standardization of data processes and reporting frameworks.(Nice to have)
* Contribute to data engineering or advanced analytics initiatives, including pipeline development or predictive modeling.

Qualifications

Who Are We Looking For?

Required Skills & Experience:
* Strong experience with Power BI, including dashboard design and data modeling.
* Proficiency in DAX for building calculated measures and KPIs.
* Solid knowledge of SQL for data extraction and manipulation.
* Advanced Excel skills for analysis and data handling.
* Experience with Python for data analysis and automation is highly valued.
* Strong analytical thinking and problem-solving skills.
* Ability to translate business requirements into technical solutions.
* Effective communication and stakeholder management skills.

Nice to Have:
* Experience with Databricks, PySpark, or big data processing tools.
* Familiar with business applications such as SAP ECC, SAP BOBJ, Salesforce, Qualtrics, Fullstory to export data.
* Knowledge of NoSQL databases and modern data architectures.
* Familiarity with data pipelines, ETL processes, or data engineering frameworks.
* Exposure to data science or predictive analytics techniques.
* Experience working in FMCG, e-commerce, or B2B sales environments.

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.

* 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

We are a Global Capability Center (GCC) team delivering centralized business services. Our scope supports Pepsiconnect / MiNegocio+ a B2B mobile application focused on the direct sales channel (traditional trade customers), enabling commercial execution, product visibility, and sales growth. Within the team, the Data Analyst plays a critical role in transforming raw application and operational data into actionable insights that drive business decisions across markets. This role will work closely with cross-functional teams-including Digital products & Services and Business Units-to ensure data accuracy, reporting consistency, and insight generation that enhances commercial performance. The ideal candidate combines strong analytical expertise with business acumen and a proactive mindset to support continuous improvement in a fast-paced, data-driven environment.

Your Impact

* Develop, maintain, and enhance Power BI dashboards and reports to support business decision-making across markets.
* Extract, transform, and analyze data from application backends and databases using SQL and other querying tools.
* Design and optimize data models, measures, and KPIs for scalable reporting solutions.
* Collaborate with cross-functional teams (Digital Products and services, and business stakeholders) to understand data needs and translate them into analytical solutions.
* Ensure data quality, integrity, and consistency across reports and datasets.
* Automate reporting processes and improve data workflows to increase efficiency.
* Perform ad hoc analyses to identify trends, risks, and opportunities within the direct sales channel.
* Support the documentation and standardization of data processes and reporting frameworks.(Nice to have)
* Contribute to data engineering or advanced analytics initiatives, including pipeline development or predictive modeling

Ihr Profil:

Who Are We Looking For?

Required Skills & Experience:
* Strong experience with Power BI, including dashboard design and data modeling.
* Proficiency in DAX for building calculated measures and KPIs.
* Solid knowledge of SQL for data extraction and manipulation.
* Advanced Excel skills for analysis and data handling.
* Experience with Python for data analysis and automation is highly valued.
* Strong analytical thinking and problem-solving skills.
* Ability to translate business requirements into technical solutions.
* Effective communication and stakeholder management skills.

Nice to Have:
* Experience with Databricks, PySpark, or big data processing tools.
* Familiar with business applications such as SAP ECC, SAP BOBJ, Salesforce, Qualtrics, Fullstory to export data.
* Knowledge of NoSQL databases and modern data architectures.
* Familiarity with data pipelines, ETL processes, or data engineering frameworks.
* Exposure to data science or predictive analytics techniques.
* Experience working in FMCG, e-commerce, or B2B sales environments.

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.

* 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