Senior Data Engineer

Who you are

• CANDIDATES MUST BE ELIGIBLE FOR UK SECURITY CLEARANCE FOR THIS ROLE
• MUST be eligible for UK Security Clearance
• Demonstrable experience in Data Engineering
• Proven experience delivering complex Data Migration and Data Integration projects
• Strong experience working with large and complex datasets
• Experience working across both AWS and Microsoft Azure environments
• Strong hands-on experience with:
• PostgreSQL
• MySQL
• Microsoft SQL Server
• Oracle
• Amazon Redshift
• Amazon Athena
• Excellent SQL development, optimisation, and troubleshooting skills
• Strong practical experience with:
• AWS Glue
• Amazon S3
• AWS Lambda
• AWS Step Functions
• Amazon QuickSight
• Microsoft Azure Technologies
• Microsoft Fabric
• Azure Data Factory
• Azure Synapse Analytics
• Azure Data Lake Storage
• Azure SQL
• Data Engineering
• Strong knowledge of:
• ETL and ELT design patterns
• Data Integration architectures
• Data Warehousing
• Data Lake and Lakehouse architectures
• Data Modelling
• Data Profiling
• Data Quality Management
• Data Validation and Reconciliation
• Candidates must be able to demonstrate a pre-existing right to work and travel within the UK. Documentary evidence will be required
• All offers are subject to satisfactory vetting, references and occupational health checks
• This role requires Security Check (SC) clearance. Candidates must either hold current SC clearance, or be eligible to obtain SC clearance

What the job involves

• Design, develop and maintain scalable ETL and ELT pipelines
• Build data integration solutions across cloud, on-premise, and third-party systems
• Design and implement robust data migration solutions, including extraction, transformation, validation, reconciliation, and cutover activities
• Perform data profiling, root cause analysis, and data quality assessments
• Develop and optimise data warehouse, data lake, and lakehouse solutions
• Produce source-to-target mappings, transformation rules, and technical documentation
• Support data governance, security, and compliance requirements
• Work collaboratively with stakeholders to understand requirements and deliver effective solutions
• Troubleshoot complex data issues and implement sustainable solutions

Benefits

• Private Medical Healthcare
• Pension Scheme
• Life Assurance
• 25 Days Holiday
• Wellness
• Retail & Lifestyle Discounts
• Flexible Working
• Continued Learning
• CycleScheme