UK remote
Senior BI Engineer
About this role
We’re looking for a Senior BI Engineer to work along with our BI team in FinTech and Fashion Tech. Reporting to the Staff Engineering Lead, you will take the strategy they set and turn it into delivery, leading the team day to day and being the senior, most experienced pair of hands on the data side. The team owns reporting and BI across all of FinTech and Fashion Tech. That covers the reports our business runs on, the reconciliations that keep our data feeds honest, and ownership of the data warehouse and the data sync between our ERP and the wider estate.
Our stack is Python, PySpark, Delta Lake and Databricks, with T‑SQL, Kimball dimensional modelling and Power BI on top, working closely with Microsoft Dynamics 365 Finance and Operations data structures. We are currently reviewing whether to move from Databricks to Microsoft Fabric, so you should be comfortable working through a platform decision and the migration that may follow. Key Responsibilities Being Mentor to the BI Team Support the BI team day to day, turning the strategy set by the Staff Engineering Lead into a plan the team can deliver against.
Support and mentor the other BI Engineers on both reports and the data side, through design reviews, pairing and code review. Be the senior technical voice in the team. Set the standards for how we model, build and test, and raise the bar on quality. Prioritise and balance the team’s work across reporting requests, reconciliations and platform work, and pick up the hardest builds yourself. Owning the Data Warehouse and Data Sync Own our data warehouse, including the dimensional model, the pipelines that load it and the standards that keep it consistent as it grows.
Own the data sync between our ERP and the warehouse, making sure data lands completely, on time and in a shape the business can use. Build and maintain the reconciliations that prove our feeds are complete and accurate, and investigate and fix them when they break. Reporting and BI Delivery Deliver reporting our stakeholders trust, from the models underneath through to well built, performant Power BI reports. Design and build data pipelines in Python, PySpark and Delta Lake, and write the T‑SQL behind our models and reconciliations.