Data Engineer

Location(s): UK, Europe & Africa : UK : LeedsBAE 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 EngineerLocation: 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-GG10Referral Bonus: £5000What 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:Azure Data Factory (ADF) Create dimensions incrementally, reducing processing and data needs with a hopeful reduction in the incurred costs for compute, data and network processing.Changing the authentication method between ADF and SQL Server to use either a managed identity or service principal to enhance security and manageability.Establishing parallelism within existing and new ADF pipeline activities.Template elements of an existing pipeline to support the ingestion of new datasets through the platformAzure SQL Integrating Database Access with Microsoft Entra ID for enhanced security.Implementing STAR schemas on Data Models.Establishing naming conventions for database objects.Transitioning data processing from Power BI to Azure SQL.Segregating data serve level data into multiple schemas or views.Data segregation and redaction techniques, such as data masking and data pseudonymisation.Benefits: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 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.Life at BAE Systems Digital IntelligenceWe 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.