Data Engineer

About GKN Aerospace

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 Business Systems Specialist 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/Azure/Power BI tooling whilst also assisting during the migration from Qlik Sense and the DWH (based on SQL Server/SSIS). The incumbent will conduct tasks across the full life cycle including business analysis of customer requirements through building data pipelines, developing analytical reports/apps, testing, deployment and post go-live support. The successful candidate will also drive adoption of BI through training, data literacy and supporting end users with self service development.

Job 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 i.e. that involve significant amounts of data transformation
• Develop data pipelines/data warehousing in Microsoft Azure 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

How you'll Contribute

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

Once you’re on board you’ll get the following perks and benefits:

• 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!