Senior Data Analyst - SCM

The Company

Aptiv is a global technology company with a mission to develop safe, green and connected solutions which are enabling the future of mobility. The company has 147,000 total employees, of which 22,000 are salaried.  Aptiv operates 14 major technical centres and 109 manufacturing locations in 45 countries.  The company is geographically diversified with revenues in North America representing roughly 37% of total revenues, Europe representing 33% of total revenues, Asia Pacific representing 28% of total revenues, and South America representing 2% of total revenues.  China is our fast growing region and currently represents roughly 20% of our total revenues.

As a technology company, approximately 16,000 of our 22,000 salaried employees are engineers.  Over one-third of our engineers develop software and systems solutions.  Our salaried workforce has the following breakdown regionally: 30% in North America, 42% in Europe, and 25% in Asia Pacific.

Our vision is to be our customers’ partner of choice by developing world class supply chain capabilities to successfully serve our customers. A significant competitive advantage in our supply chain are the 109 manufacturing locations around the globe, approximately 80% of which are in best cost countries.  Approximately 97% of our 125,000 hourly workers are located in best cost countries.

Candidate Profile & Main Responsibilities

The holder of the position will be responsible to lead part of the reporting and analytics for specific stakeholders within the 180-strong matrix AS&UX SCM organization as well as support additional business analytics deliverables. Main responsibilities are:

• Tableau strategy for plethora of dashboards for matrix AS&UX SCM organization. Being able to create (technically) dashboards, being able to understand data behind these dashboards, being able to manage cadence and regular improvements to these Tableau dashboards, with a layering strategy in mind (lagging vs leading KPIs, layering dashboards per different spams/layers of organization, connections in between)
• Working closely with functional stakeholders, category teams, buyers to improve existing data-based deliverables and streamline data-related reporting processes, reducing cycle time for completion, ability to apply 80/20 pareto to data, problem solving methodology etc.
• Independently managing self, internal working groups or external team (TCS) who are responsible for large master data sets, with a purpose of cleansing, transforming, loading etc. (ETL) and translating them into readable reports and dashboards
• Assessing gaps within the current data and business planning process, problem solving to the core and developing recommendations for improvements and execute those improvements via kaizens, problem solving

Overall, you will be responsible for strengthening the AS&UX SCM’s approach to data analytics to ensure transparency and accuracy of data and continuous improvement, making sure that the business analytics is at the highest accuracy and quality, it is easily accessible, enabling end-user to drive SCM performance and make business-savvy decisions.

You need to have an ability to cooperate and be able to mediate and align with different stakeholders, cultures and attitudes. Strong motivation, sense of urgency/proactivity, high-level of energy and problem-solving skills as well as ability to focus and willingness to understand the external influx of data (OEM’s, suppliers) are key for this role. 

Role Requirements

• BA degree in Business/Finance Management, Statistics, Computer Science or similar relevant subjects
• Minimum 6+ years of experience in cross-functional if possible, supply chain/procurement area (automotive environment a plus)
• Previous working experience in companies with solid continuous improvement culture and approach to lean  e.g. Toyota, Honeywell or Royal Philips and/or data management consultancies
• Advanced working knowledge in designing and creating Tableau reports and dashboards
• Knowledge of SQL – subqueries, aggregations, functions, triggers, Indexes, DB optimization, creating/understanding relational data base models
• Good SAP knowledge, especially in operational procurement areas, additional exposure to any ERP system advantage (Teradata, Data warehouse etc.)
• Knowledge of ETL (Extract, Transform, Load) process, Statistical methods and data modelling knowledge (working knowledge of databases)
• Advanced skills and certification in Alteryx a huge plus
• Advanced VBA (Visual Basic for Applications in Excel, writing your own functions or commands in an xls
• Excellent English
• Lean/Six Sigma or Problem Solving experience and passion for continuous improvement a plus

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.