Data Engineer

GKN Aerospace Services Limited; Birmingham; Remote; GBP 50,000 - 70,000; Full time

Job summary

A leading aerospace services company is seeking a Data Engineer to support global BI functions. The role involves developing data pipelines and BI reports using Microsoft Fabric and Power BI, engaging with various data sources for analytics. The ideal candidate will have a strong background in data engineering and analytics development, capable of designing robust Power BI solutions. Competitive salary and benefits offered.

Benefits

Remote working

Industry-leading pension scheme

Life assurance (8x salary)

25 days holiday + bank holidays

Employee Assistance Programme

Qualifications

• Experience in bringing together multiple data sources to create data models.
• Proficient in analyzing and diagnosing complex data issues.
• Ability to design Power BI dashboards using DAX and Power Query.

Responsibilities

• Lead business analysis to discover and document requirements.
• Develop and test BI apps with data transformation.
• Support business users in self-service app development.

Skills

Data analytics development experience

Data engineering and complex data modelling

Complex app/DWH development using Microsoft Azure/Power BI

ETL and SSIS development

Power BI reports/apps/dashboards design

Intermediate-to-advanced Excel competency

Education

BSc degree in Computer Science or a related discipline

Tools

Microsoft Fabric

Power BI

SQL Server

Qlik Sense

Python

R

Job description

Overview

The Data Engineer will be based remotely and ideally you will be located in the UK or Netherlands. This is a global functions role supporting all three of our business lines (Civil, Defence & Engines). The incumbent will have the flexibility to attend one of our sites and flexibility will be required for quarterly National/EU travel to attend internal site visits. The Data Engineer will be part of the BI CoE reporting to the CoE Manager - BI with responsibility for supporting the global BI service and developing data pipelines and BI reports/apps/dashboards using the Microsoft Fabric/ Power BI tooling whilst also assisting during the migration from Qlik Sense and the DWH (based on SQL Server/SSIS). The role is primarily focused on ingesting data (ERPs, SQL Sharepoint etc) into MS Fabric and transforming this into governed data for use in other systems such as Power BI. There will also be a need to develop Power BI apps from time to time and work with the rest of the team to drive adoption of BI through training, data literacy and supporting end users with self-service development.

Responsibilities

• Lead on business analysis with internal customers to discover and document requirements
• Data engineering and complex modelling bringing together data from multiple data sources suitable for analytics
• Develop and test complex BI apps that involve significant amounts of data transformation
• Develop data pipelines/data warehousing in Microsoft Fabric and migrate across existing solutions from the current SQL based Data Warehouse
• Support business users in the development of self-service apps
• Continuous improvement of the BI service bringing in advanced data science capabilities
• Routine support of the BI service including incident resolution
• Analyse and debug incoming data to ensure data is complete and of required quality
• Contribute to the delivery of processes shared with adjacent CoE's
• Adhere to all governance requirements
• Contribute to ad-hoc requests as needed

Qualifications

• Notable data analytics development experience
• Data engineering and complex data modelling experience (using Fabric/Azure) in bringing together multiple data sources (including ERPs) and tables to create the data model/semantic layers
• Experience of complex app/DWH development and support using Microsoft Azure/Power BI. Ability to analyse and diagnose complex data issues and explain key findings in clear business language to end users
• Experience of ETL and SSIS development to read in data and apply data profiling and data validation techniques
• Designing and building the user facing Power BI reports/apps/dashboards including in-depth use of DAX and Power Query
• Intermediate-to-advanced competency with Excel

Desirable

• BSc degree in Computer Science or a related discipline
• Experience in a manufacturing environment ideally within the aerospace industry
• Experience of complex app/DWH development and support using Qlik Sense and SQL Server/SSIS
• Experience of KPI reporting
• Experience of managing finance concepts and terminology
• Experience of predictive analytics and machine learning
• Development using Python/R
• Experience of developing and supporting BI systems in the Cloud

Company and Benefits

GKN Aerospace is reimagining air travel: going further, faster and greener! We are a diverse organisation with over 16,000 employees across 33 manufacturing sites in 12 countries, serving over 90% of the world's aircraft and engine manufacturers. We offer a competitive salary dependent on experience, remote working with site attendance, industry-leading pension scheme (1:1.5 match), life assurance (8x salary), 25 days holiday + bank holidays, income protection, shopping discounts, Cycle To Work Scheme, and an Employee Assistance Programme. We are committed to diversity, inclusion and belonging and strive to create an accessible recruitment process.