Data Engineer

BAE Systems; Frimley; On-site; GBP 47,000; Full time

Job summary

A leading defense contractor in Frimley seeks a Data Engineer to develop and optimise SQL scripts and ETL data pipelines. You'll monitor and validate ETL processes, maintain solutions, and analyze SQL for improvements. Required skills include strong SQL knowledge and experience with ETL tools. The position offers a competitive salary of circa £47,000 along with benefits such as a pension scheme and health plans.

Benefits

Competitive pension scheme

Employee share plans

Flexible health and wellbeing benefits

Qualifications

• Previous experience in a similar data engineering role.
• Excellent SQL knowledge and experience in database technologies.
• Understanding of relational databases and dimensional modelling.

Responsibilities

• Develop and optimise SQL scripts and ETL data pipelines.
• Perform validations of ETL development and data loads.
• Maintain existing ETL solutions and identify improvements.
• Analyse SQL queries for performance enhancements.

Skills

SQL knowledge

ETL development

Database management

Data analysis

Tools

SQL Server Management Studio

Microsoft BI stack (SSIS/SSRS)

Alteryx designer

Job description

Responsibilities

• Develop, implement and optimise complex SQL scripts and ETL data pipelines to support data ingestion processes and reporting
• Monitoring and performing 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 a change control environment
• Writing and reviewing technical documentation

Qualifications

• Previous experience in a similar data engineering role
• Excellent SQL knowledge and experience using SQL Server Management Studio and Microsoft BI stack (SSIS/SSRS) or an equivalent database technology.
• Excellent understanding of relational databases and dimensional modelling

Desirable

• Appreciation of data warehousing architecture techniques, best practises and able to deploy packages for production to be at industrial strength.
• Experience in Alteryx designer

About BAE Systems

The Shared Services Data & Analytics Hub is the heart of our company data landscape, bringing together data from our global operations and generating a broad range of insights to inform key business decisions by senior stakeholders. This is your chance to play a key role through delivery of key data, whilst gaining exposure across the business.

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 of thought, rewards integrity, merit, and where you'll be empowered to fulfil your potential. We welcome people from all backgrounds and 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 mean that factors such as your nationality, any nationalities you may have previously held, and your place of birth can restrict the roles you are eligible 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.

Salary

Circa £47,000 dependent on experience. As well as a competitive pension scheme, BAE Systems also offers employee share plans, an extensive range of flexible discounted health, wellbeing and lifestyle benefits, including a green car scheme, private health plans and shopping discounts – you may also be eligible for an annual incentive.