Data & Analytics Audit Lead (Power BI & SQL)

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

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