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 E, xcel 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.
reate 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.
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, protected veteran status or any other characteristic protected by law.
Skills Required
- Bachelor's degree in Mechatronics, Electronics, or a related technical field
- Experience with electronics components, manufacturing, supply chain, or cost-related data
- Proven experience delivering reporting and automation solutions
- 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
- Strong Python/SQL for scripting
APTIV Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about APTIV and has not been reviewed or approved by APTIV.
-
Retirement Support — A 401(k) plan with company contribution and competitive matching is described as a notable component of the total rewards package. Equity participation and performance bonuses are also positioned as part of long-term and variable compensation.
-
Healthcare Strength — Core coverage is portrayed as broad, spanning medical, dental, vision, life, and disability insurance. Mental health resources and an Employee Assistance Program are also included as part of wellness support.
-
Leave & Time Off Breadth — Paid holidays, paid sick days, and flexible time-off policies are included in the benefits mix. Flexible scheduling and remote-work programs further support time management and personal needs.
APTIV Insights
What We Do
Aptiv is a global technology company that develops safer, greener and more connected solutions enabling the future of mobility. #ItsOurMove
