Senior BI Engineer

Company Description We're ASOS, the online retailer for fashion lovers all around the world. We exist to give our customers the confidence to be whoever they want to be, and that goes for our people too. At ASOS, you're free to be your true self without judgement, and channel your creativity into a platform used by millions. Everyone needs some help showing up as their best self.

We're Disability Confident Committed - let our Talent team know if you need any reasonable adjustments throughout the recruitment process

Job Description We’re looking for a Senior BI Engineer to work along with our BI team in Fin Tech 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 Fin Tech 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.  Keep an eye on cost, performance and reliability across the platform, and keep improving what is already live.  Working with Stakeholders  Work with stakeholders across Finance, Tech and Fashion, including our Commercial, Buying and Product colleagues, to understand what they need from their data. 

Turn reporting requests into well shaped requirements, and challenge constructively when an existing report or a different cut of the data would do the job.  Keep stakeholders updated on progress, priorities and any risks to the data they depend on, so there are no surprises.  Working Across Tech  Work closely with the solution, engineering and support teams across Fin Tech and Fashion Tech, so changes upstream in the ERP don’t break reporting downstream. 

Follow the wider ASOS delivery process, including governance, change control and release cadence, and run the team’s work through Azure Dev Ops.  Work with Architecture, Security and Risk so what…