MCIP Data Analytics, Tools, Process Engineer

Aptiv PLC; Monterrey; Presencial; MXN 420.000 - 660.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Savings Fund

Pension Plan

Christmas Bonus

Attendance Bonus

Vacation Premium

Medical Expenses

Life Insurance

Social security (IMSS, INFONAVIT, Retirement)

Recognition for innovation and excellence

Opportunities to give back to the community

Descripción de la vacante

A leading technology company in Monterrey seeks a MCIP Data Engineer responsible for developing and maintaining data tools and analytics solutions. This role will focus on data capture, automation, and reporting across global stakeholders. The ideal candidate holds a Bachelor's degree in Mechatronics or Electronics and has strong proficiency in Microsoft Lists, Power BI, and automation tools. Join us to drive impactful improvements in data efficiencies while enjoying a competitive benefits package.

Formación

• Experience working with electronics components, manufacturing or supply chain data is preferred.
• Proven experience delivering reporting and automation solutions in a corporate environment.
• Strong proficiency in Power BI and data tools.
• Strong proficiency in Microsoft Lists, Power Automate, Excel, and Power BI.
• Solid understanding of Power Query, DAX, and data relationships.
• Experience integrating data from multiple systems and formats.
• Strong Python/SQL for scripting.

Responsabilidades

• Develop and maintain Microsoft Lists for data collection.
• Automate processes between Microsoft Lists, SharePoint, Excel, and Power BI.
• Analyze and prepare data using advanced Excel capabilities.
• Customize list views for usability and adoption.
• Automate data synchronization between Lists, SharePoint, Excel, and Power BI.
• Monitor and troubleshoot automation flows.
• Use advanced Excel capabilities (Pivot Tables, XLOOKUP, XMATCH) for data analysis.
• Leverage Power Query to clean and transform data.
• Develop and maintain Power BI semantic models, reports, dashboards, and paginated reports.
• Design data models with relationships and measures.
• Create DAX measures for KPIs and savings tracking.
• Understand and modify live connections to Power BI datasets.

Conocimientos

Microsoft Lists

Power Automate

Excel

Power BI

Python

SQL

Educación

Bachelor's degree in Mechatronics, Electronics, or a related technical field

Herramientas

Microsoft Lists

Power Automate

Excel

Power BI

Power Query

DAX

Descripción del empleo

Overview

The MCIP Data Engineer will be responsible for developing, maintaining, and optimizing data tools and analytics solutions that support Aptiv’s Material Cost Improvement Program (MCIP). This role focuses heavily on enabling reliable data capture, automation, visualization, and reporting across global stakeholders.

Key Responsibilities:

• Develop, customize, and maintain Microsoft Lists to support MCIP data collection and tracking.

• Design and manage multiple cross-linked lists to enable efficient data extraction, automation, and reporting.

• Implement Lookup fields and validation rules to optimize and error-proof data entry.

• Customize list views to improve usability, data visualization, and end-user adoption.

• Automate recurring processes and data synchronization between Microsoft Lists, SharePoint, Excel, and Power BI.

• Monitor and troubleshoot automation flows to ensure reliability and performance.

• Use advanced Excel capabilities to analyze, validate, and prepare data: Pivot Tables, Pivot Charts, XLOOKUP, XMATCH, and advanced formulas, Conditional Formatting for data validation and insights

• Leverage Power Query to clean, transform, and integrate data from multiple sources.

• Develop, customize, maintain, optimize, and debug Power BI semantic models, reports, dashboards, and paginated reports.

• Design efficient data models, including relationships and measures, to support MCIP analytics.

• Create and maintain DAX measures to support KPIs, cost analysis, and savings tracking.

• Understand and modify live connections to Power BI datasets, enabling end-users to customize visuals based on their specific data needs.

Your background:

• Bachelor's degree in Mechatronics, Electronics, or a related technical field.

• Experience working with electronics components, manufacturing, supply chain, or cost-related data is strongly preferred.

• Proven experience delivering reporting and automation solutions in a corporate environment.

• Strong proficiency in Microsoft Lists, Power Automate, Excel, and Power BI.

• Solid understanding of Power Query, DAX, and data relationships

• Experience integrating data from multiple systems and formats.

• Strong Python/SQL for scripting

WHY JOIN US?

• You can grow at Aptiv. Aptiv provides an inclusive work environment where all individuals can grow and develop, regardless of gender, ethnicity or beliefs.

• You can have an impact. Safety is a core Aptiv value; we want a safer world for us and our children, one with: Zero fatalities, Zero injuries, Zero accidents.

• You have support. We ensure you have the resources and support you need to take care of your family and your physical and mental health with a competitive health insurance package.

Your Benefits at Aptiv:

• Savings Fund

• Pension Plan

• Christmas Bonus

• Attendance Bonus

• Vacation Premium

• Medical Expenses

• Life Insurance

• Social security (IMSS, INFONAVIT, Retirement)

• Recognition for innovation and excellence

• Opportunities to give back to the community

APPLY TODAY, AND TOGETHER LET’S CHANGE TOMORROW!

#LI-MG1

Privacy Notice - Active Candidates: https://www.aptiv.com/privacy-notice-active-candidates

Aptiv is an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, gender identity, sexual orientation, disability status or any other characteristic protected by law.