Data Engineer


Company:	The Devonshire Group
Salary:	Competitive
Hours:	Full-time
Location:	Bakewell, DE45 1PJ
Job type:	Permanent
Posting date:	17 Sept 2026
Closing date:	17 Oct 2026

Apply for this job

Summary

Job Advert

Data Engineer

About the Devonshire Group

The Devonshire Group comprises the Devonshire family interests, charities and businesses throughout the UK and Ireland, including Chatsworth in Derbyshire, the Bolton Abbey Estate in North Yorkshire, the Lismore Estate in County Waterford, and the Compton Estate in Sussex.

Across our estates and businesses, we operate visitor attractions, shops, restaurants and luxury accommodation, alongside tenanted residential and commercial property, farming and forestry enterprises, and a significant property development pipeline. We employ around 1,400 colleagues across more than 65,000 acres.

We are committed to benefitting heritage, people and a shared future, preserving and enhancing our heritage assets, supporting our communities, and leading by example in how we do things.

About the role

As our Data Engineer, you’ll take hands-on technical ownership of data ingestion, transformation, data warehousing and integration, primarily using Microsoft Fabric, SQL and Power BI. You’ll work closely with stakeholders across the Group to understand reporting and data requirements, translate these into reliable data models and integrations, and ensure data is accurate, secure and accessible for decision-making. Working collaboratively with the wider IT team, you’ll help maintain appropriate data architecture, quality, governance and operational standards.

What you’ll be doing

- Develop and maintain the Group’s Microsoft Fabric data platform and enterprise data warehouse

- Design, build and support data ingestion and transformation processes across bronze, silver and gold data layers

- Develop and maintain Fabric pipelines, Lakehouse and warehouse structures, SQL transformations and dimensional data models

- Build and support integrations with operational systems using APIs, database connections, ODBC, file transfers and other appropriate methods

- Develop and maintain Power BI semantic models, supporting colleagues with the creation of reliable reports and dashboards

- Establish data quality, testing and reconciliation controls to ensure information is accurate, complete and consistent with source systems

- Work with stakeholders across the Group to understand reporting and integration requirements, agree definitions and validate outputs

- Support the development of enterprise customer data, including customer matching, shared identifiers and the management of ambiguous records

- Maintain development, user acceptance testing and production environments, with controlled deployment and release processes

- Configure scheduling, monitoring and failure notifications, investigating and resolving unsuccessful or long-running processes

- Maintain technical and operational documentation, including data dictionaries, mappings, schemas, architecture diagrams and support runbooks

- Work with the IT pillar leads to ensure new applications and integrations consider data quality, ownership, security, APIs and reporting requirements

About you

You’ll bring practical, hands-on experience in data engineering, data warehousing and business intelligence, with strong technical skills in Microsoft Fabric or closely related Microsoft cloud data technologies.

You’ll be confident developing and troubleshooting SQL transformation logic, designing reliable ETL or ELT pipelines, and creating clear data models that support trusted reporting and decision-making.

You’ll be collaborative, organised and service-focused, able to translate business reporting and integration requirements into maintainable technical solutions. You’ll be comfortable working with technical and non-technical stakeholders, with a strong focus on data quality, governance, security, lineage and documentation best practice.

We’re looking for someone who has:

- Practical experience of Microsoft Fabric or closely related Microsoft cloud data technologies

- Strong SQL skills, including developing and troubleshooting data transformation logic

- Experience designing and maintaining ETL or ELT pipelines

- Strong knowledge of dimensional modelling, including facts, dimensions, grain, business keys and star schemas

- Experience integrating operational systems using APIs, databases, ODBC connections and files

- Experience implementing data quality, testing and reconciliation controls

- Experience building and maintaining Power BI semantic models

- Experience using source control and controlled deployment processes

- Ability to translate business reporting and integration requirements into clear, maintainable technical solutions

- Understanding of data governance, security, lineage and documentation best practice

- Ability to communicate effectively and work collaboratively with technical and non-technical stakeholders

- Strong organisational skills, with the ability to prioritise workload and manage competing demands

- Relevant professional experience or qualifications in data engineering, data warehousing, computing or a related discipline

In return

You’ll join a supportive and friendly IT team within a values-led organisation that genuinely cares about its people. You’ll play a key role in helping the IT function operate effectively and professionally across a diverse, multi-site organisation.

We offer a range of benefits including a wellbeing calendar of events, an onsite gym and swimming pool, and an Estate Pass providing free access to Chatsworth for you and your guests, plus discounts across Devonshire Group hotels, shops and restaurants.

Details of our employee benefits can be found here: https://devonshiregroup.co.uk/work-with-us/working-at-the-devonshire-group/

Our core values include “Being Inclusive” and we particularly welcome applications from disabled and Black, Asian and Minority Ethnic (BAME) candidates who are currently under-represented. We also welcome applicants from the LGBTQ+ community. Flexible ways of working will always be considered.

Successful candidates will be invited to attend a 2-stage selection process.

Please see attached job description for further information about the role.

Apply for this job

Proud member of the Disability Confident employer scheme

About Disability Confident

Disability Confident is a government scheme. It encourages employers to recruit and retain disabled people and those with long term health conditions.