> Markdown version of [/jobs/ext/2502952-lead-data-bi-engineer](https://www.wearedevelopers.com/jobs/ext/2502952-lead-data-bi-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Data & BI Engineer

- **Company:** Gleeson Recruitment Ltd
- **Location:** Birmingham, UK
- **Experience:** Expert
- **Salary:** £80,000.0 - £100,000.0
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Google AdWords, Information Engineering, Data Infrastructure, Extract Transform Load (ETL), Data Systems, Data Warehousing, Google Analytics, Python (Programming Language), Power BI, Standard Sql, Systems Integration, Data Processing, Azure Data Factory, Sql Optimization, Git, Data Layers, Build Management, Microsoft Fabric, Data Lakes, Pyspark, Star Schema, Restful APIs, Software Version Control, Data Pipelines
- **Published:** August 18, 2026
- **Apply:** https://www.careerboard.com/pt/en/find-jobs-in-United-Kingdom/-5CCBDA87C0BA7EDBE3/

## About the Role

* 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

## Description

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 E-commerce, 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


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)

## Related Articles

- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)