About this role
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 experienceAdvanced SQL and strong PySpark experienceProficiency in Python for data processing and API integrationExperience building Power BI models and dashboards for business reportingStrong understanding of ETL/ELT design and data modelling principlesExperience integrating third-party data via REST APIsKnowledge of data quality, monitoring, and governance practicesExperience using Git or similar version control toolsComfortable working in a hands-on, standalone capacity Responsibilities: Design and build scalable ETL/ELT pipelines in Microsoft Fabric using PySpark and SQLDevelop transformation logic within Fabric Lakehouses using Delta Lake and medallion architecture principlesIntegrate data from ecommerce, ticketing, and marketing platforms into a central data layerConnect sources such as GA4, Google Ads, Meta Ads, and affiliate platforms via APIs and native connectorsOwn data quality, monitoring, and governance across the platformDesign and implement dimensional data models, including fact and dimension tables and star schema structuresBuild and maintain Power BI semantic models with DAX, KPIs, and row-level securityDeliver dashboards and reporting across commercial, marketing, and operational performanceSupport analytics use cases including attribution modelling, cohort analysis, and customer segmentationTranslate business requirements into data solutions and present insights to stakeholdersPromote best practices in data engineering, documentation, and version control Technologies: APIAzureDAXETLFabricGitSupportMarketingPower BIPythonPySparkRESTSQLSecurityCloud 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