Lead Data & BI Engineer in Birmingham

Energy Jobline ZR; Birmingham; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

Gleeson Recruitment Group in Birmingham seeks a Lead Data & BI Engineer to own the end-to-end data platform, building a modern stack with Microsoft Fabric and Power BI for company-wide insights.

Role is hands-on with clear progression into leadership as the data function grows; hybrid work in Birmingham city centre, onsite 2–3 days.

Qualifications

• Strong hands-on experience with Microsoft Fabric and Lakehouse components.
• Advanced SQL and PySpark experience.
• Python for data processing and API integration.
• Experience building Power BI models and dashboards.
• Knowledge of ETL/ELT design and data modelling.
• Experience integrating third-party data via REST APIs.
• Familiarity with data quality, monitoring and governance.

Responsibilities

• Design and build scalable ETL/ELT pipelines in Microsoft Fabric using PySpark and SQL.
• Develop transformations in Fabric Lakehouses using Delta Lake and medallion architecture principles.
• Integrate data from ecommerce, ticketing, and marketing platforms into a central data layer.
• Connect sources such as GA4, Google Ads, Meta Ads, and affiliate platforms via APIs.
• Own data quality, monitoring, and governance across the platform.
• Design and implement dimensional data models (fact/dimension tables, star schema).
• Build and maintain Power BI semantic models with DAX, KPIs, and row-level security.
• Deliver dashboards and reporting across commercial, marketing, and operational performance.
• Support analytics use cases including attribution modelling, cohort analysis, and customer segmentation.
• Translate business requirements into data solutions and present insights to stakeholders.
• Promote best practices in data engineering, documentation, and version control.

Skills

PySpark

SQL

Python

Power BI

Data modeling

ETL/ELT design

Git/version control

Tools

Microsoft Fabric

Delta Lake

Azure Data Factory

APIs

Job description

Job Description

Lead Data & BI Engineer - Microsoft Fabric & Power BI

Birmingham City Centre based (Hybrid working, 2/3 days onsite)

£80K - £100K DOE

We’re partnering with a growing, data-driven organisation looking to hire a Data Engineer to take ownership of their end-to-end data platform.

This is a hands-on role focused on building a modern data stack within Microsoft Fabric. You’ll design and develop pipelines, structure data models, and deliver reporting through Power BI that supports decision-making across marketing, sales, finance, and operations.

There is a clear progression path into leadership as the data function grows, but the initial focus is on building a scalable, high-quality data platform from the ground up.

The Role

• Design and build scalable ETL/ELT pipelines in Microsoft Fabric using PySpark and SQL


• Develop transformation logic within Fabric Lakehouses using Delta Lake and medallion architecture principles


• Integrate data from ecommerce, ticketing, and marketing platforms into a central data layer


• Connect sources such as GA4, Google Ads, Meta Ads, and affiliate platforms via APIs and connectors


• Own data quality, monitoring, and governance across the platform


• Design and implement dimensional data models (fact/dimension tables, star schema)


• Build and maintain Power BI semantic models with DAX, KPIs, and row-level security


• Deliver dashboards and reporting across commercial, marketing, and operational performance


• Support analytics use cases including attribution modelling, cohort analysis, and customer segmentation


• Translate business requirements into data solutions and present insights to stakeholders


• Promote best practices in data engineering, documentation, and version control

Requirements

• Strong hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, pipelines). Azure Data Factory experience will also be considered if no working experience with fabric


• Advanced SQL and strong PySpark experience


• Proficiency in Python for data processing and API integration


• Experience building Power BI models and dashboards for business reporting


• Strong understanding of ETL/ELT design and data modelling principles


• Experience integrating third-party data via REST APIs


• Knowledge of data quality, monitoring, and governance practices


• Experience using Git or similar version control tools


• Comfortable working in a hands-on, standalone capacity

At Gleeson Recruitment Group, we embrace inclusivity and welcome applicants of all backgrounds, experiences, and abilities. We are proud to be a confident employer.