Our Client
Every day, around the world, they help aircrafts fly further, faster and greener. They’re the world’s leading tier one aerospace supplier of systems and components. With over 15,000 employees across 38 manufacturing sites in 12 countries serving over 90% of the world’s aircraft and engine manufacturers with sales of £2.8bn. Together as one they’re moving their business and industry forward developing technologies that rapidly decarbonise aircraft, and innovating to help build a new generation of planes that produce zero emissions. They’re putting sustainability at the heart of what they do; driving their objective to becoming a net zero greenhouse gas emissions business before 2050!
It’s great to know you’re making a difference to the future of aviation! Whatever part you play you’ll be helping them deliver operational excellence to their customers.
The Role
The Business Systems Specialist will be based remotely, ideally you will be located in the UK or Netherlands. This is a global functions role supporting all three of their business lines (Civil, Defence & Engines), the incumbent will have the flexibility to attend one of their 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 BI apps using Qlik Sense and the DWH using SQL Server and migrating to Microsoft Fabric/Azure/Power BI. The incumbent will conduct tasks across the full life cycle including business analysis of customer requirements through development, 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.
Responsibilities
- Routine support of the BI service including incident resolution
- Lead on business analysis with internal customers to discover and document requirements
- Data engineering and 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 and test 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
- Analyse and debug incoming data to ensure data is complete and of required data quality
- Contribute to the delivery of processes shared with adjacent CoE’s
- Adhere to all governance requirements
- Contribute to ad-hoc requests as needed
Requirements
- Notable Business Intelligence development experience
- Experience of complex app/DWH development and support using Qlik Sense and SQL Server 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 development to read in data and apply data profiling and data validation techniques
- Data engineering and data modelling experience in bringing together multiple data sources and tables to create the data model
- Designing and building the user facing Qlik app visualisations including set analysis, variables and master dimensions/measures
- Intermediate-to-advanced competency with Excel
- BSc degree in Computer Science or a related discipline
- Experience of complex app/DWH development and support using Qlik Sense and SQL Server
- Experience in a manufacturing environment ideally within the aerospace industry
- 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
Benefits
- Remote working with some flexibility to attend site giving you the opportunity to balance home and office working
- Industry Leading Pension Scheme = they’ll match your contributions up to 8% 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