Lead Data Platform Engineer – Fabric & Power BI

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

Benefits offered by this job

Hybrid working

Training & development

Job summary

FRP Advisory Group is seeking a hands-on Data Platform Engineer to join the Applications and Data team and develop a Microsoft Fabric-based enterprise data platform. You will work with an existing Data Engineer and report to the Data & Analytics Lead to build reliable pipelines, dimensional models and transformations that make trusted data available across the business.

You will design and maintain Power BI reports and data models, set governance standards, and collaborate with stakeholders to

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

Git

Azure DevOps

SQL

Data warehouses

ETL/ELT

Medallion architecture

Microsoft Fabric

PySpark

dbt

data quality

testing

monitoring

operational support

problem solving

communication

Tools

Git

Azure DevOps

PySpark

Job description

FRP Advisory Group is seeking a hands-on Data Platform Engineer to join the Applications and Data team and develop a Microsoft Fabric-based enterprise data platform. You will work with an existing Data Engineer and report to the Data & Analytics Lead to build reliable pipelines, dimensional models and transformations that make trusted data available across the business.

You will design and maintain Power BI reports and data models, set governance standards, and collaborate with stakeholders to