Data Engineer

TN United Kingdom; Leeds; On-site; GBP 40,000 - 80,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer to join their dynamic team in Leeds. This role offers the opportunity to work on innovative data solutions, transforming proof-of-concept systems into fully operational platforms. You will collaborate with agile teams to enhance data processing capabilities while ensuring security and efficiency. The company values diversity and inclusion, fostering a culture where your contributions can make a significant impact. If you're passionate about data engineering and want to be part of a forward-thinking environment, this position is perfect for you.

Benefits

Competitive pension scheme

Employee share plan

Flexible health benefits

Private health plans

Shopping discounts

Annual incentive eligibility

Qualifications

• Experience in data processing and management using Azure Data Factory and SQL Server.
• Strong understanding of data security and integration techniques.

Responsibilities

• Create dimensions and optimize data processing to reduce costs.
• Implement STAR schemas and enhance security in data access.

Skills

Data Processing

Azure Data Factory (ADF)

SQL Server

Microsoft Entra ID

STAR Schemas

Data Masking

Data Pseudonymisation

Agile Methodology

Education

Bachelor's Degree in Computer Science or related field

Tools

Power BI

Azure SQL

Job description

BAE Systems Digital Intelligence is home to 4,500 digital, cyber and intelligence experts. We work collaboratively across 10 countries to collect, connect and understand complex data, so that governments, nation states, armed forces and commercial businesses can unlock digital advantage in the most demanding environments.

Job Title: Data Engineer

Location: Leeds - We offer a range of hybrid and flexible working arrangements - please speak to your recruiter about the options for this particular role.

Grade: GG09-GG10

What You’ll Be Doing:

CPS engaged Mobilise to embark upon a discovery/proof-of-concept for business intelligence/data warehouse over 4 years. This period was interspersed with multiple breaks whilst CPS re-prioritised and determined next steps.

Mobilise helped CPS gain a better understanding of the technology options suitable for the CPS’s desired technology roadmap/ecosystem by putting in place a proof-of-concept which showcased an end-to-end capability and vision of ‘what’ and ‘how’ CPS’s vision could be realised.

Working together and using an agile delivery methodology, CPS gained a richer and deeper understanding of its own organisations data and learnt more about the Microsoft technology stack allowing them to improve their internal reporting and their understanding of their business.

CPS now wish to transform a PoC solution into a fully productionised and supported system.

This is anticipated to be achieved using one or more agile teams in a phased approach to deliver key technology deliverables on their enhancement journey.

Skills & Experience:

• Create dimensions incrementally, reducing processing and data needs with a hopeful reduction in the incurred costs for compute, data and network processing.
• Change the authentication method between ADF and SQL Server to use either a managed identity or service principal to enhance security and manageability.
• Establish parallelism within existing and new ADF pipeline activities.
• Template elements of an existing pipeline to support the ingestion of new datasets through the platform.
• Integrate Database Access with Microsoft Entra ID for enhanced security.
• Implement STAR schemas on Data Models.
• Establish naming conventions for database objects.
• Transition data processing from Power BI to Azure SQL.
• Segregate data serve level data into multiple schemas or views.
• Apply data segregation and redaction techniques, such as data masking and data pseudonymisation.

As well as a competitive pension scheme, BAE Systems also offer employee share plan, an extensive range of flexible discounted health, wellbeing and lifestyle benefits including a green care scheme, private health plans and shopping discounts – you may also be eligible for an annual incentive.

Why BAE Systems?

This is a place where you’ll be able to make a real difference. You’ll be part of an inclusive culture which values diversity, rewards integrity and merit, and where you’ll be empowered to fulfil your potential. We welcome candidates from all backgrounds and particularly from sections of the community who are currently under-represented within our industry including women, ethnic minorities, people with disabilities and LGBTQ+ individuals.

We also want to make sure that our recruitment processes are as inclusive as possible. If you have a disability or health condition (for example dyslexia, autism, an anxiety disorder etc.) that may affect your performance in certain assessment types, please speak to your recruiter about potential reasonable adjustments.

Please be aware that many roles at BAE Systems are subject to both security and export control restrictions. These restrictions such as your nationality, any nationalities which you previously may have held and your place of birth can restrict the roles you are able to perform within the organisation.

All applicants must as a minimum achieve Baseline Personnel Security Standard. Many roles also require higher levels of National Security Vetting where applicants must typically have 5 to 10 years of continuous residency in the UK depending on the vetting level required for the role, to allow for meaningful security vetting checks.

We are embracing Hybrid Working. This means you and your colleagues may be working in different locations, such as from home, another BAE Systems office or client site, some or all of the time, and work might be going on at different times of the day.

By embracing technology, we can interact, collaborate and create together, even when we’re working remotely from one another. Hybrid Working allows for increased flexibility in when and where we work, helping us to balance our work and personal life more effectively, and enhance well-being.

Diversity and inclusion are integral to the success of BAE Systems Digital Intelligence. We are proud to have an organisational culture where employees with varying perspectives, skills, life experiences and backgrounds – the best and brightest minds – can work together to achieve excellence and realise individual and organisational potential.