Your Role
We are looking for data analyst whose role is 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.
- 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
Your Background
Key ingredients for succeeding in this role are your:
- 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
- Active participation in the design and review of automated testing tools
- Active participation in technical and organizational innovation programs
- Experience of working in Agile development environment is an added advantage
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.
Employment Type: Full Time, Permanent
Read full job description