Lead Data & BI Engineer

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 Lake houses 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 native 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

Data Engineer
- Please apply asap if interested
- GleeIT

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

By applying you will be registered as a candidate with Gleeson Recruitment Limited. Our Privacy Policy is available on our website and explains how we will use your data