Lead Data Engineer: Fabric & Power BI Platform

FRP Group; City Of London; Hybrid; GBP 70,000 - 110,000; Full time

Benefits offered by this job

Hybrid working

Training and certifications

Career development

Job summary

FRP Advisory Group is expanding its Applications and Data team to develop and support a Microsoft Fabric-based enterprise data platform. You will work with the Data & Analytics Lead to deliver reliable data pipelines, dimensional models and transformations, enabling trusted data across the business.

You will lead a data engineering team, define standards for architecture and governance, and collaborate with stakeholders to ensure timely delivery. Hybrid working and UK travel are part of the role.

Qualifications

• Strong commercial experience of Kimball dimensional modelling and dbt transformations.
• Experience using Git and Azure DevOps for source control, testing and CI/CD.
• Strong SQL skills and experience with complex data structures.
• Experience building and supporting enterprise data warehouses or similar analytical platforms.
• Experience developing reliable ETL or ELT processes in the Medallion architecture.
• Experience with Microsoft Fabric data engineering, including Pyspark and dbt.
• Practical knowledge of data quality, testing, monitoring and operational support.
• Strong problem-solving skills and attention to detail.
• Clear communication and the ability to work independently while collaborating with the Data & Analytics Lead, technical colleagues and business stakeholders.

Responsibilities

• Lead and develop the data team, including Data Engineering, with clear priorities and responsibilities.
• Guide technical work across reporting, data modelling, integration and engineering.
• Design and maintain Power BI reports, dashboards, semantic models and supporting data models.
• Set Power BI standards for architecture, development, governance, deployment and reuse.
• Work with stakeholders to understand requirements, agree priorities and manage delivery.
• Work with Data Engineering to build reliable data pipelines and connect source systems, Microsoft Fabric and Power BI.
• Maintain standards for data quality, security, performance, documentation and support.
• Train selected technical colleagues to contribute to Power BI work alongside their main roles.
• Track the Microsoft Fabric roadmap and recommend relevant features for FRP.
• Travel to regional offices when needed for meetings, delivery and training

Skills

Kimball dimensional modelling

dbt transformations

SQL

Data warehousing

ETL/ELT

Pyspark

data quality

problem solving

communication

Tools

Git

Azure DevOps

Job description

FRP Advisory Group is expanding its Applications and Data team to develop and support a Microsoft Fabric-based enterprise data platform. You will work with the Data & Analytics Lead to deliver reliable data pipelines, dimensional models and transformations, enabling trusted data across the business.

You will lead a data engineering team, define standards for architecture and governance, and collaborate with stakeholders to ensure timely delivery. Hybrid working and UK travel are part of the role.