Data Engineer

BAE Systems
Frimley, United Kingdom
18 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
£ 40K

Job location

Frimley, United Kingdom

Tech stack

Code Review
Databases
Information Engineering
ETL
Data Warehousing
Relational Databases
Power BI
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Data Ingestion
SQL Server Management Studio (SSMS)
Software Version Control
Data Pipelines
Alteryx

Job description

  • 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

Requirements

  • 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

Benefits & conditions

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.

About the company

The Shared Services Data & Analytics Hub is at 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, and 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.

Apply for this position