Data Engineer

The Devonshire Group; Edensor CP; On-site; GBP 55,000 - 90,000; Full time

Benefits offered by this job

Wellbeing calendar

Onsite gym

Estate Pass with Chatsworth access

Staff discounts across group hotels,Sh

Job summary

The Devonshire Group is seeking a Data Engineer to take hands-on ownership of data ingestion, transformation, warehousing and BI reporting. You will design data models, ensure data quality and govern data flows across the Group, working with stakeholders and IT teams to deliver reliable information for decision-making.

You will build Fabric pipelines, SQL transformations and BI models, maintain documentation, and support data governance, security, and deployment processes across multiple sites.

Qualifications

• Hands-on experience with data platforms and warehousing.
• Strong knowledge of SQL, data modelling and BI tooling.
• Ability to translate requirements into reliable data models.

Responsibilities

• Develop and maintain the Group's data platform and data warehouse.
• Design, build and support ingestion and transformation processes.
• Create and maintain Power BI semantic models and dashboards.

Skills

Microsoft Fabric

SQL

Power BI

Data Warehousing

ETL/ELT pipelines

Data governance

API integration

Dimensional modelling

Education

Bachelor's degree in a relevant field

Professional data engineering qualifications

Tools

APIs

ODBC

Data modelling tools

Job description

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

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.

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.

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.