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
The primary objective of this role is to support the Product Catalog team by ensuring the accuracy, consistency, and reliability of data flowing into the catalog system. The analyst will use strong SQL and data analysis skills to validate data, perform quality checks, and conduct root-cause analysis across complex data pipelines. The role also includes partnering with stakeholder teams—such as Finance—to ensure processes are well-defined, scalable, and aligned, and that catalog outputs meet downstream reporting and business needs.
Your Impact
As Digital Commerce Product Catalog Data Analyst your responsibilities would consist of:
Ensure data quality and integrity of Product Catalog outputs used for reporting and analytics by performing routine and ad hoc SQL-based validation, reconciliation, and anomaly detection across catalog data pipelines.
(Accountability: Executing actions)
Impacted groups: Reporting teams, Finance, Product Analytics-
Perform root-cause analysis on catalog data issues by tracing data lineage across upstream sources, transformation logic, and downstream outputs, and documenting findings and remediation recommendations.
(Accountability: Executing actions / Providing consultation)
Impacted groups: Data Engineering, Reporting teams, Finance -
Support Finance and reporting stakeholders by validating catalog data against financial hierarchies, category assignments, and reporting requirements, ensuring outputs meet governance and accuracy standards.
(Accountability: Providing consultation / Being informed)
Impacted groups: Finance, BI & Reporting teams -
Monitor and maintain catalog-related processes and controls, including executing predefined SQL checks, reviewing alerts, and escalating data quality risks or process breakdowns as needed.
(Accountability: Executing actions)
Impacted groups: Product Catalog team, Data Engineering -
Partner with Product and Engineering teams to provide analytical input on catalog changes, enhancements, and defect remediation, using data evidence to inform prioritization and impact assessment.
(Accountability: Providing consultation)
Impacted groups: Product teams, Data Engineering -
Document data processes, validation logic, and known data issues to improve transparency, repeatability, and stakeholder understanding of catalog behavior and limitations.
(Accountability: Executing actions)
Impacted groups: Reporting teams, Finance, Product teams -
Execute ad hoc analytical requests related to catalog data, including investigative SQL queries and exploratory analysis to answer stakeholder questions or support decision-making.
(Accountability: Executing actions / Being informed)
Impacted groups: Finance, Reporting teams, Product teams -
Contribute to continuous process improvement efforts by identifying inefficiencies, gaps, or risks in catalog workflows and recommending enhancements to improve robustness and scalability.
(Accountability: Providing consultation)
Impacted groups: Product Catalog team, Data Engineering
Qualifications:
Who Are We Looking For?
Experience
Advanced SQL proficiency with the ability to write complex queries for data validation, reconciliation, root-cause analysis, and exploratory investigation across large, relational datasets.-
Strong understanding of data flows and data lineage, particularly within multi-source, multi-layer data platforms (e.g., upstream sources, transformation layers, and downstream reporting views).
-
Process analysis and optimization skills, including the ability to evaluate existing workflows, identify failure points, and recommend controls to improve data reliability and scalability.
-
Data quality and governance expertise, including experience defining checks, monitoring anomalies, and supporting consistent application of business rules and hierarchies.
-
Ability to translate business requirements into analytical checks, particularly in partnership with Finance, Reporting, and Product teams.
-
Working knowledge of product or master data concepts, such as product hierarchies, reference data, and categorization frameworks (or the ability to quickly learn these domains).
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.
