Senior Staff Auditor – Data & Analytics

Pepsico; Xico; Presencial; MXN 700.000 - 1.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexibility program

Wellness Line

Scholarship programs for children

Descripción de la vacante

PepsiCo is seeking a Senior Audit Data & Analytics Analyst in Mexico City to partner with global Corporate Audit teams, analyze large datasets, and build scalable analytics solutions. You will design ETL pipelines, develop Python notebooks, and create Power BI dashboards to deliver actionable insights for audit teams and stakeholders.

Responsibilities include automating workflows with Power Automate, leveraging Databricks, and translating business needs into data-driven solutions while

Formación

• Bachelor's degree in a related field.
• 3+ years of experience developing analytical solutions using Python or another programming language.
• 3+ years of experience working with data visualization tools, particularly Power BI.
• Experience working with SQL and data preparation/ETL processes.
• Experience translating business requirements into data-driven solutions.
• Experience working with multiple stakeholders and managing projects or initiatives with limited oversight.

Responsabilidades

• Partner with global Corporate Audit teams to identify opportunities where data, analytics, automation, and emerging technologies can enhance audit processes and deliverables.
• Analyze large and complex datasets to identify trends, anomalies, risks, and opportunities across security, system configurations, and business processes.
• Design and maintain reliable ETL/data pipelines, ensuring data is accurate, complete, timely, and consistent for audit and analytics purposes.
• Develop SQL and Python notebooks to perform advanced analytics and support audit testing, including the application of machine learning models where appropriate.
• Create and enhance Power BI dashboards that translate complex data into actionable insights for audit teams and business stakeholders.
• Automate repetitive processes and workflows using Power Automate, improving efficiency and enabling audit teams to focus on higher-value activities.
• Leverage Databricks and other advanced analytics capabilities to develop scalable data and automation solutions.
• Build Power Apps and other digital solutions that simplify interactions between Corporate Audit teams and existing data sources.
• Collaborate with technology and business stakeholders to understand data requirements, translate business needs into analytical solutions, and drive adoption.
• Promote the use of analytics, automation, and emerging technologies across the global Corporate Audit organization.
• Support the development of innovative approaches that strengthen PepsiCo's risk management, governance, and audit capabilities.

Conocimientos

Analytical problem solving

Python

Power BI

SQL & ETL

Requirements gathering

Stakeholder management

Educación

Bachelor's degree in Computer Science / Computer Engineering / Mathematics / Data Analytics or related field

Herramientas

Databricks

Descripción del empleo

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 Senior Audit Data & Analytics Analyst

The Opportunity in Mexico City

Your Impact In this role, you will:

• Partner with global Corporate Audit teams to identify opportunities where data, analytics, automation, and emerging technologies can enhance audit processes and deliverables.
• Analyze large and complex datasets to identify trends, anomalies, risks, and opportunities across security, system configurations, and business processes.
• Design and maintain reliable ETL/data pipelines, ensuring data is accurate, complete, timely, and consistent for audit and analytics purposes.
• Develop SQL and Python notebooks to perform advanced analytics and support audit testing, including the application of machine learning models where appropriate.
• Create and enhance Power BI dashboards that translate complex data into actionable insights for audit teams and business stakeholders.
• Automate repetitive processes and workflows using Power Automate, improving efficiency and enabling audit teams to focus on higher-value activities.
• Leverage Databricks and other advanced analytics capabilities to develop scalable data and automation solutions.
• Build Power Apps and other digital solutions that simplify interactions between Corporate Audit teams and existing data sources.
• Collaborate with technology and business stakeholders to understand data requirements, translate business needs into analytical solutions, and drive adoption.
• Promote the use of analytics, automation, and emerging technologies across the global Corporate Audit organization.
• Support the development of innovative approaches that strengthen PepsiCo's risk management, governance, and audit capabilities.

Qualifications

What You’ll Bring

• Education - Bachelor's degree in computer science, Computer Engineering, Mathematics, Management, Data Analytics, or a related field.
• Experience - 3+ years of experience developing analytical solutions using Python or another programming language.
• Experience - 3+ years of experience working with data visualization tools, particularly Power BI.
• Experience - working with SQL and data preparation/ETL processes.
• Experience - translating business requirements into data-driven solutions.
• Experience - working with multiple stakeholders and managing projects or initiatives with limited oversight.

Preferred Qualifications

• Experience with Databricks and notebooks.
• Experience with machine learning, advanced analytics, or AI applications.
• Experience with Power Automate and/or Power Apps.
• Certifications or formal training in programming, analytics, data science, or related technologies.
• Exposure to audit, risk management, controls, cybersecurity, or business process analysis is a plus.

What We’re Looking For

• Strong analytical and problem-solving capabilities, with the ability to turn complex information into clear insights.
• Strong communication and interpersonal skills, with the ability to interact effectively from frontline teams to senior leadership.
• Ability to work independently, prioritize competing demands, and operate with limited oversight.
• Strong stakeholder management and relationship-building skills.
• Ability to influence and collaborate across functions, cultures, and geographies.
• Strong organization and project management skills.
• Curiosity and willingness to learn and apply emerging technologies.
• Adaptability and comfort working in an evolving environment.
• Fluent English communication skills are required.

Location & Travel

Location: Mexico City – Habitat Travel: 5–10%, as required.

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.