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.

• 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 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

• 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.