Senior BI Engineer: Lead Data Warehouse Migration

ASOS

Greater London

On-site

GBP 90,000 - 130,000

Full time

8 days ago

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Benefits offered by this job

Employee discount

Employee sample sales

25 days annual leave + extra day

Discretionary bonus

Private medical care

Flexible benefits allowance

Learning opportunities

Job summary

ASOS is seeking a Senior BI Engineer to join our FinTech and Fashion Tech BI team. You will translate strategy into delivery, lead the team day to day and be the senior data hand driving data warehouse, data sync with ERP and financial reporting.

You'll work with Python, PySpark, Delta Lake and Databricks, consider Microsoft Fabric as a potential platform move, and build scalable pipelines and well-crafted Power BI reports for stakeholders across Finance, Commercial and Product.

Qualifications

Strong hands-on experience with Python, SQL, PySpark and Delta Lake for building scalable data pipelines.
Experience across the Azure data stack, including Azure Data Factory (ADF), Azure Functions, Logic Apps and Azure Storage.
Strong experience with Databricks and Microsoft Fabric, including Lakehouse and modern data engineering solutions.
Strong SQL/T-SQL skills and experience with Kimball dimensional modelling and data warehouse design.
Experience integrating ERP data, ideally Microsoft Dynamics 365 Finance & Operations or other major ERP platforms.
Working knowledge of Power BI, DAX and data modelling, with a focus on delivering effective business reporting.

Responsibilities

Support the BI team day to day, turning the strategy set by the Staff Engineering Lead into a plan the team can deliver against.
Mentor BID Engineers 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.
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.
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.
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.
Work closely with the solution, engineering and support teams across FinTech 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 DevOps.
Work with Architecture, Security and Risk so what we build meets ASOS standards, protects sensitive financial data and stands up to audit.