Lead Data & BI Engineer in Birmingham

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.