Data Engineer

GKN Aerospace; Birmingham; Remote; GBP 45,000 - 75,000; Full time

Job summary

An established industry player is seeking a talented Data Engineer to join their innovative team. This role offers the unique opportunity to work remotely while contributing to critical data-driven projects across various business lines. You'll be tasked with developing data pipelines, creating BI reports, and enhancing the overall BI service. Your expertise in data engineering and analytics will be pivotal in transforming data into actionable insights. If you're passionate about leveraging data to drive business success and thrive in a collaborative environment, this is the perfect opportunity for you.

Benefits

Remote Working

Industry Leading Pension Scheme

Life Assurance

25 Days Holiday

Income Protection

Shopping Discounts

Cycle To Work Scheme

Employee Assistance Programme

Dynamic Working Environment

Qualifications

• Experience in data analytics development and data engineering.
• Proficient in complex data modelling using Microsoft Fabric/Azure.
• Skilled in developing Power BI reports and dashboards.

Responsibilities

• Lead business analysis to document requirements.
• Develop and test complex BI applications.
• Support business users in self-service app development.

Skills

Data Analytics Development

Data Engineering

Complex Data Modelling

ETL Development

DAX

Power Query

Data Profiling

Data Validation Techniques

Intermediate-to-Advanced Excel

Predictive Analytics

Education

BSc in Computer Science

Tools

Microsoft Fabric

Power BI

Qlik Sense

SQL Server

SSIS

Python

R

Job description

GKN Aerospace is ‘s werelds meest toonaangevende leverancier binnen de vliegtuigindustrie. Met38productielocaties in12landen bedienen we meer dan 90% van ‘s werelds vliegtuig- en motorfabrikanten en een omzet behaald van £3,35 miljard in 2023. Wij ontwerpen en produceren innovatieve slimme ruimtevaartsystemen en componenten. Elke keer dat je per vliegtuig reist, is het waarschijnlijk dat GKN je op weg helpt.
We zijn op zoek naar mensen die een verschil willen maken, getalenteerde medewerkers met de vaardigheden en passies om het beste te worden in wat ze doen.

Role Summary

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.

How You'll Contribute

• 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 i.e. 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
  

What You'll Bring

Essential

• 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. Experience of analysing and diagnosing complex data issues and then 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
  

What We'll Offer

• Competitive salary dependent on experience
• Remote Working with Flexibility to attend site– giving you the opportunity to balance home and office working
• Industry Leading Pension Scheme = we’ll match your contributions on a 1 : 1.5 basis
• Life Assurance 8 x salary
• 25 days holiday + bank holidays
• Income protection
• Shopping discounts
• Cycle To Work Scheme
• Employee Assistance Programme
• A collaborative, dynamic working environment

As well as a competitive package we’ll offer you a world of opportunity. We want to see your career fly! We’ll support your career progression by providing you with learning and development opportunities. That’s the beauty of being part of a global business, once you’re on board you never know where you career journey may take you!

We’ll offer you fantastic challenges and amazing opportunities. This is your chance to be part of an organisation that has proven itself to be at the cutting edge of our industry; and is committed to pushing the boundaries even further. And with some of the best training on offer in the industry, who knows how far you can go?

Diversity Inclusion and Belonging (DIB)

As a global engineering company, innovation is what differentiates us from our competitors and is central to our success.

A balance of cultures, ethnicities and genders help bring new ideas and creativity to GKN. We need people of different backgrounds, with different skills and perspectives to spark originality, imagination and creativeness in our teams around the world.

GKN is an equal opportunity employer.

We treat all our employees and applicants fairly and are committed to ensuring that there is no discrimination or harassment against any employee or qualified applicant on the grounds of age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, or veteran status or any other characteristic protected by law.

#LI-HYBRID