Senior Data Engineer

Oxfordshire Bus Enhanced Partnership; Oxford; Ibrido; GBP 70.000 - 110.000; Tempo pieno

Vantaggi offerti da questo lavoro

Hybrid working

Flexible working

Learning development

Copilot access

Employee Assistance Programme

Annual leave

Pension scheme

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

SQL

Python

ETL/ELT

Microsoft Fabric

Data modeling

Data integration

Data warehousing

SQL optimization

PySpark

Strumenti

Talend

FME

SSIS

Descrizione del lavoro

About Us

Oxfordshire County Council's central Data Office brings together data architecture, engineering, analytics and spatial data expertise. We work across the organisation to improve how data supports effective public services, operational delivery and better outcomes for residents.

About the Role

As a Senior Data Engineer, you will take a hands-on role in designing and delivering scalable data pipelines, integrations, lakehouses, data warehouses and data models. The role requires strong SQL, Python and ETL/ELT experience, with a particular focus on designing and developing solutions in Microsoft Fabric.

Key responsibilities include:

• Designing and delivering scalable, reliable and reusable data engineering solutions.
• Building ETL/ELT pipelines and integrations using ETL tools, Microsoft Fabric, SQL, Python and other appropriate technologies.
• Designing and configuring Microsoft Fabric pipelines, lakehouses, data warehouses and data models.
• Supporting the migration of on-premises data workloads to Microsoft Fabric.
• Implementing data quality controls, testing, monitoring and technical documentation.
• Applying data architecture standards and engineering best practices.
• Translating complex business requirements into practical, maintainable data solutions.
• Creating and maintaining data catalogue, metadata management and data lineage.
• Working collaboratively with technical teams, analysts and business stakeholders.

About you

• Significant experience of developing data integration, migration and data warehousing solutions using one or more ETL platforms, such as Talend, Microsoft Fabric, FME or SSIS.
• In-depth working knowledge of SQL, with the ability to write and optimise queries and stored procedures.
• Experience building robust data pipelines using Python, PySpark or other relevant programming languages.
• Solid hands-on experience of designing and developing Microsoft Fabric solutions across pipelines, lakehouses, warehouses and data layers.
• Strong data modelling skills, with experience designing scalable and maintainable models for data integration, warehousing, analytics and reporting.
• Strong data discovery skills, including locating, understanding and analysing source data.
• Experience of implementing testing and data quality controls to identify, prevent and resolve data anomalies.
• Experience of creating and maintaining data catalogues, technical metadata and data lineage using Microsoft Purview or another metadata management platform would be advantageous.

Rewards and benefits

At OCC, you'll be part of a team that’s not only passionate about what we do, but also about how we do it. We foster a culture of inclusion, respect, and continuous improvement, and we’re proud to offer flexible working arrangements, professional development opportunities, and a strong sense of purpose in everything we do.

• Hybrid working - Benefit from a flexible mix of home and office working, with typically around one day a week in the office for collaboration.
• Culture of flexible working - Flexibility is important to deliver the service and to suit individual lifestyles. We encourage discussion at interview as we acknowledge there isn’t a one-size-fits-all approach.
• Great learning and development opportunities to support your growth.
• Technology to support agile working - with unlimited access to Copilot for smarter productivity.
• Employee Assistance Programme with health and wellbeing support.
• Generous annual leave - up to 30 days plus bank holidays, and an option to 'buy' additional time off.
• Enhanced family-friendly policies.
• Local Government Pension Scheme - employer contributions up to 19.9%.
• Discounts - local and national offers for shopping and travel.

Your office base may be subject to change as we are currently transitioning between temporary and permanent office locations due to the closure of County Hall. If this is applicable to you, you will be notified, but no reimbursement will apply in respect of travel.

Application deadline: 9th November 2026.

Shortlisting will take place week commencing 16th November 2026.

Interviews are expected to take place in person at our Oxford office during the first week of December 2026.

For informal enquiries or further information about the role

Please contact Gowri Nagarajan, Data Architecture and Engineering Lead on [e-mail].

Our commitment to: Equality, Diversity and Inclusion

At Oxfordshire County Council we are proud of our diverse workforce. Everyone is accepted for who they are, regardless of age, disability, gender identity, marital status, race, faith or belief, sexual orientation, socioeconomic background, or on maternity or family leave. We have a number of staff network groups which provide peer support, education and safe spaces for all.

Our commitment to: Guaranteed Interview Schemes

As a Disability Confident employer, we guarantee an interview for disabled applicants who meet the essential criteria for the job. We also guarantee interviews to care leavers who have completed further education and who meet the essential criteria for the job. For those leaving care without any further education, we guarantee an interview for our apprenticeships. We are also committed to helping and supporting those transitioning from HM Armed Forces to civilian life and guarantee an interview for those demonstrating the essential criteria for the role, within three years of leaving the service.

Our commitment to: Safeguarding

Oxfordshire County Council are committed to safeguarding and promoting the welfare of children, young people and adults. We expect all employees, workers and volunteers to share this commitment. We will ensure that all our recruitment and selection practices reflect these commitments.

Our commitment to: Flexible Working

We are open to discussions about flexible working, which can include flexi-time, part time working, job sharing, nine-day fortnights and annualised hours, depending on the requirements of the role and the service.

Follow us on Social Media

Stay up-to-date with the latest news and featured jobs from Oxfordshire County Council by following us on LinkedIn, Facebook, Twitter and Instagram.