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.
#J-18808-Ljbffr
Lead Data & BI Engineer in Birmingham employer: Energy Jobline ZR
Energy Jobline ZR is an excellent employer for Structural Engineers, offering a vibrant work culture in the heart of Shoreditch. With a focus on innovation and collaboration, employees benefit from competitive salaries, professional development opportunities, and the chance to work on exciting projects from concept to completion within a supportive team environment.
