Senior Data Engineer: Fabric Pipelines & Lakehouses

Oxfordshire Bus Enhanced Partnership; Oxford; Hybrid; GBP 70,000 - 110,000; Full time

Benefits offered by this job

Hybrid working

Flexible working

Learning development

Copilot access

Employee Assistance Programme

Annual leave

Pension scheme

Job summary

Oxfordshire County Council is seeking a Senior Data Engineer to design and deliver scalable data pipelines, lakehouses, data warehouses and data models using Microsoft Fabric. You will implement ETL/ELT processes, data quality controls and metadata management.

The role requires strong SQL, Python and ETL/ELT experience with hands-on Fabric expertise, data integration and warehousing across complex datasets. Expect collaboration with analysts and stakeholders in a hybrid working environment.

Qualifications

• Significant experience in developing data integration, migration and data warehousing solutions using ETL platforms such as Talend, Microsoft Fabric, FME or SSIS.
• Strong SQL skills with ability to write, optimise queries and stored procedures.
• Experience building robust data pipelines using Python, PySpark or similar languages.
• Hands-on experience designing Microsoft Fabric solutions across pipelines, lakehouses and data warehouses.
• Solid data modelling skills for integration, warehousing, analytics and reporting.
• Experience implementing data quality controls to identify and resolve data anomalies.

Responsibilities

• Design and deliver scalable, reliable data engineering solutions.
• Build ETL/ELT pipelines and integrations using ETL tools, Microsoft Fabric, SQL and Python.
• Design and configure Microsoft Fabric pipelines, lakehouses, data warehouses and data models.
• Support migration of on-premises workloads to Microsoft Fabric.
• Implement data quality controls, testing and documentation.
• Apply data architecture standards and engineering best practices.
• Translate business requirements into maintainable data solutions.
• Create and maintain data catalogues, metadata and data lineage.
• Collaborate with technical teams, analysts and stakeholders.

Skills

SQL

Python

ETL/ELT

Microsoft Fabric

Data modeling

Data integration

Data warehousing

SQL optimization

PySpark

Tools

Talend

FME

SSIS

Job description

Oxfordshire County Council is seeking a Senior Data Engineer to design and deliver scalable data pipelines, lakehouses, data warehouses and data models using Microsoft Fabric. You will implement ETL/ELT processes, data quality controls and metadata management.

The role requires strong SQL, Python and ETL/ELT experience with hands-on Fabric expertise, data integration and warehousing across complex datasets. Expect collaboration with analysts and stakeholders in a hybrid working environment.