Lead Data & BI Engineer

Gleeson Recruitment Ltd

Birmingham, UK

16 days ago

Apply on www.careerboard.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Compensation

£80,000.0 - £100,000.0

Working hours

Regular working hours

Job source

www.careerboard.com

Tech stack

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

+13 more

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

Job 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

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