Audit Data & Analytics Lead — SQL, Python, Power BI

PepsiCo; Ciudad de México; Presencial; MXN 600.000 - 900.000; Jornada completa

Descripción de la vacante

PepsiCo in Mexico City seeks a Senior Audit Data & Analytics Analyst to join Corporate Audit. You’ll blend data, technology, and analytics to transform how we identify risks and deliver insights across the organization.

You will work with global teams to design analytics-driven solutions, improve audit quality and efficiency, and create dashboards and automated workflows. The role emphasizes collaboration with stakeholders, strong English, and curiosity to apply emerging technologies in risk

Formación

• 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 with SQL and data preparation/ETL processes.
• Experience translating business requirements into data-driven solutions.
• Experience working with multiple stakeholders and managing projects 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

Python

SQL

Power BI

ETL

Databricks

Machine learning

Power Automate

Power Apps

Data analytics

Stakeholder management

Communication

Educación

Bachelor's degree in computer science, Computer Engineering, Mathematics, Management, Data Analytics, or a related field

Herramientas

SQL notebooks

Python notebooks

Power BI dashboards

Databricks

Power Automate

Power Apps

Descripción del empleo

PepsiCo in Mexico City seeks a Senior Audit Data & Analytics Analyst to join Corporate Audit. You’ll blend data, technology, and analytics to transform how we identify risks and deliver insights across the organization.

You will work with global teams to design analytics-driven solutions, improve audit quality and efficiency, and create dashboards and automated workflows. The role emphasizes collaboration with stakeholders, strong English, and curiosity to apply emerging technologies in risk