Senior Data Engineer

locations Cheltenham, Gloucestershire, England, UK Remote - UK

time type Full time

posted on Posted 30+ Days Ago

job requisition id REQ-9763

Ultra PCS is a leading developer of mission and safety critical equipment in the defence and aerospace industry. Our team of experts are at the heart of our success, which is why we are dedicated to fostering a safe working environment and a positive culture where every staff member feels valued and respected.

We solve our customers' problems, providing engineering solutions to safety and mission critical challenges in the air and on the ground. Our solutions can be found in the latest military aircraft and vehicles, in civil aircraft, and in unmanned vehicles.

We also offer innovative products optimised to support the unique challenges of the dismounted soldier. We help to ensure our customers get to where they need to be safely, achieve their objectives and keep on going back.

Wherever possible, we will consider a variety of working options to suit your lifestyle, whether that be hybrid home/office working, flexible working and part or full time employment. It's the 'innovating' and 'empowering' values that we ASPIRE to be. We welcome the challenge to work in new ways and have trust in you when getting the job done because we recognise, our business is our people.

Over the past three years, Ultra PCS has transitioned to a new business intelligence and data architecture, centred on SQL Server, SSIS, and Power BI. We've developed an in-house Data Warehouse that serves as our OLAP database and manages most ETL processes. Power BI is then used to consistently deliver high-quality data to our internal teams.

Ultra PCS is a leading developer of mission and safety critical equipment in the defence and aerospace industry. Our team of experts are at the heart of our success, which is why we are dedicated to fostering a safe working environment and a positive culture where every staff member feels valued and respected.

We solve our customers' problems, providing engineering solutions to safety and mission critical challenges in the air and on the ground. Our solutions can be found in the latest military aircraft and vehicles, in civil aircraft, and in unmanned vehicles.

We also offer innovative products optimised to support the unique challenges of the dismounted soldier. We help to ensure our customers get to where they need to be safely, achieve their objectives and keep on going back.

Wherever possible, we will consider a variety of working options to suit your lifestyle, whether that be hybrid home/office working, flexible working and part or full time employment. It's the 'innovating' and 'empowering' values that we ASPIRE to be. We welcome the challenge to work in new ways and have trust in you when getting the job done because we recognise, our business is our people.

Over the past three years, Ultra PCS has transitioned to a new business intelligence and data architecture, centred on SQL Server, SSIS, and Power BI. We've developed an in-house Data Warehouse that serves as our OLAP database and manages most ETL processes. Power BI is then used to consistently deliver high-quality data to our internal teams.

We are seeking a Senior Data Engineer to focus primarily on our Financial and Sales data.

This role has two key areas of responsibility: Firstly, to maintain and manage existing data pipelines. Secondly, working with our Business Analyst and PowerBI expert, to define ETL procedures for new data flows, ensuring the necessary data is available to create compelling dashboards and reports.

The goal is for this role to become a data expert in Finance, Sales, and Working Capital, providing opportunities to guide data analytics requirements and conduct investigative analysis into key challenges facing PCS.

Key responsibilities

• Work with the Data Systems Director to help implement PCS's Business Intelligence Strategy.
• Maintain and manage PCS's existing data pipelines within the Finance/Sales/Working Capital scope.
• Build new data pipelines to support PowerBI report creation.
• Conduct investigative data analysis projects to improve workflows.
• Propose projects to improve data quality at source.
• Manage stakeholder requirements for new datasets.
• Apply analytical techniques to clean, transform, analyze, and interpret data.
• Collaborate with Business Analysts, PowerBI designers, and end-users to meet business needs.
• Document database architecture and data pipelines according to PCS policies.

Qualifications / skills required

• Knowledge of Data warehousing theories and methodologies.
• Expertise in SQL and SQL Server Management Studio (SSMS).
• Proficiency in PowerBI or similar tools and data modeling.
• Experience reporting on data from ERP & Manufacturing/Operations Systems.
• Strong background working with sales and finance data.
• Familiarity with transactional database systems.
• Excellent written and verbal communication skills.
• Ability to self-manage and work efficiently under speed and planning.

Benefits:

• Flexible working within core hours
• 25 days holiday plus options to buy/sell days and bank holidays
• Life assurance (4x annual salary)
• Flexible benefits package
• Pension scheme with employer contributions up to 7.5%
• Sports and Social club
• Supportive team environment with events

If interested, follow the application process to join Ultra PCS at an exciting time.

Candidates must be able to work in the UK without restrictions and undergo UK National Security Vetting.

Ultra PCS values diversity, inclusion, and equality. We welcome applications from all backgrounds and do not discriminate based on race, religion, gender, age, or disability.