Lead Data Engineer
Job title: Lead Data Engineer
Location: Preston or Frimley – Hybrid 2/3 day weekly split.
Salary: Up to £51K pending skills and experience
What you’ll be doing:
- Develop, implement and optimise complex T-SQL scripts independently to support data ingestion processes and reporting
- Monitoring and do proactive validations and verifications of ETL development and monitoring of data loads into the data warehouse
- Maintaining existing ETL solutions and identifying improvements
- Analyse existing SQL queries for performance improvements
- Conducting peer code reviews and UAT validation and create well defined test cases
- Adhering to company source control, validation and promotion policy
- Working within change control environment
- Writing and Review technical documentation
Your skills and experiences:
Essential:
- Previous experience in a similar role Excellent in T-SQL programming and experience using SQL Server Management Studio and Microsoft BI stack (SSIS/SSRS)
- Excellent understanding of relational databases and normalisation
- Solid experience of working with Visual Studio to develop, debug and publish SSIS packages and reports and to proactive provide training to juniors and peers
Desirable:
- Knowledge of PowerShell scripting
- Appreciation of data warehousing architecture techniques, best practised and able to deploy packages for production to be at industrial strength
Benefits:
You’ll receive benefits including a competitive pension scheme, enhanced annual leave allowance and a Company contributed Share Incentive Plan. You’ll also have access to additional benefits such as flexible working, an employee assistance programme, Cycle2work and employee discounts – you may also be eligible for an annual incentive.
The Shared Service Data Service team:
The Shared Service Data Service team is responsible to source and ingest data from BAE Systems and external source systems into a Shared Services Data Warehouse, to provide enterprise wide insights that are both operational and strategic and impact across all levels of the business. The team develop and configure re-useable ETL and ELT patterns and packages, following data warehouse principles and best practises to provide data with high quality and integrity, within the security framework and policy’s.
As a SQL Data Engineer, you will be a key component of the Data & Analytics Hub. They are responsible for determining how we operate as a team and as to which technologies are utilised to maximise efficiency and performance across the entire platform.
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 that 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 underrepresented 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 working for BAE Systems will be subject to both security and export control restrictions. These restrictions mean that factors including your nationality, any previous nationalities you have held, and your place of birth may limit those roles you can perform for the organisation.
Closing Date: 21st November 2023
We reserve the right to close this vacancy early if we receive sufficient applications for the role. Therefore, if you are interested, please submit your application as early as possible.
We are proud supporters of Women in Data®. Connect, engage and belong to the largest free female data community in the UK – visit: www.womenindata.co.uk to join our community.