Data Engineer — Fabric & Power BI, Flexible Work

The Devonshire Group; Bakewell CP; On-site; GBP 36,000 - 44,000; Full time

Benefits offered by this job

Estate Pass

Onsite gym and swimming pool

Discounts across Devonshire Group_hot?

Job summary

The Devonshire Group is seeking a Data Engineer to own data ingestion, transformation, warehousing and integration using Microsoft Fabric, SQL and Power BI. You will translate reporting needs into reliable data models and ensure data quality, governance and security across the Group.

You’ll work with the IT team and stakeholders to design scalable data architectures, develop end-to-end pipelines, and support reporting through Power BI.

Qualifications

• 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

Responsibilities

• 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

Skills

Microsoft Fabric

SQL

Power BI

ETL pipelines

Dimensional modelling

Data governance

APIs

Education

Degree in data engineering or computing

Tools

ODBC

APIs

Job description

The Devonshire Group is seeking a Data Engineer to own data ingestion, transformation, warehousing and integration using Microsoft Fabric, SQL and Power BI. You will translate reporting needs into reliable data models and ensure data quality, governance and security across the Group.

You’ll work with the IT team and stakeholders to design scalable data architectures, develop end-to-end pipelines, and support reporting through Power BI.