Aptiv - Senior Data Analyst - ETL/SQL (6-10 yrs)

Note : Women Candidate Preferred

Role : Senior Data Analyst

Job Description :

Why you will love being part of Aptiv? You will have the chance to work on a variety of applications, develop new technologies, and create innovative solutions for major OEMs. Plus, you get to see your products on the road, making the world safer, greener, and more connected. Are you ready to join us?

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.

Your Benefits at Aptiv :

- Higher Education Opportunities (UDACITY, UDEMY, COURSERA are available for your continuous growth and development);

- Life and accident insurance

- Sodexo cards for food and beverages

- Well Being Program that includes regular workshops and networking events;

- EAP Employee Assistance;

- Access to fitness clubs (T&C apply