Data Engineer: Modernize SQL Server Platform (Contract)

Millbrook Healthcare Group; Southampton; On-site; GBP 55,000 - 75,000; Full time

Job summary

Millbrook Healthcare Group is seeking a Data Engineer on a 24-month fixed-term contract in Southampton. You will work on a large SQL Server estate, modernising toward a Microsoft Fabric-based platform while preserving critical business logic.

You will design and maintain ETL/ELT pipelines, integrate data from multiple systems, and collaborate with BI teams to deliver trusted datasets and reporting.

Qualifications

• Strong SQL Server and T-SQL skills essential.
• Read and understand large stored procedures and business logic.
• Experience building ETL/ELT pipelines and data integrations.
• Understanding of relational/analytical data modelling and data quality.
• Experience with Azure data services and Power BI.

Responsibilities

• Build, support and improve complex SQL Server solutions used by operational systems, reporting and integrations.
• Read and interpret stored procedures with significant business logic before changes.
• Troubleshoot slow or unreliable SQL using execution plans, indexing and statistics.
• Refactor high-risk SQL to improve maintainability and performance.
• Support data migrations, reconciliations, and data fixes with traceability.
• Understand dependencies between databases, replicas, reporting and integrations.

Skills

SQL Server

T-SQL

ETL pipelines

Data modelling

Power BI

Azure data services

Git/Azure DevOps

Data quality

Tools

SSIS

Azure Data Factory

SQL Server Management Studio

Job description

Millbrook Healthcare Group is seeking a Data Engineer on a 24-month fixed-term contract in Southampton. You will work on a large SQL Server estate, modernising toward a Microsoft Fabric-based platform while preserving critical business logic.

You will design and maintain ETL/ELT pipelines, integrate data from multiple systems, and collaborate with BI teams to deliver trusted datasets and reporting.