Lead Data & BI Engineer

Salary: £85,000 - 100,000 per year

Requirements:

• Strong hands-on experience with Microsoft Fabric, including Lakehouse, Warehouse, and pipelines; Azure Data Factory experience will also be considered if we do not yet have direct Fabric experience
• 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

Responsibilities:

• 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, including fact and dimension tables and star schema structures
• 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

Technologies:

• API
• Azure
• DAX
• ETL
• Fabric
• Git
• Support
• Marketing
• Power BI
• Python
• PySpark
• REST
• SQL
• Security
• Cloud

More:

We are a growing, data-driven organisation based in Birmingham City Centre, offering a hybrid working setup with 2 to 3 days onsite. We are hiring a Lead Data & BI Engineer to take ownership of our end-to-end data platform and help build a modern data stack within Microsoft Fabric. This is a hands-on role with a clear progression path into leadership as our data function grows, and the initial focus is on building a scalable, high-quality platform from the ground up. We value inclusivity and welcome applicants from all backgrounds, experiences, and abilities, and we are proud to be a disability confident employer.

last updated 34 week of 2026