Back to jobs

Senior BI Engineer

London, England, United Kingdom

Live, first seen by us 7 days ago
Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Own the data warehouse, its dimensional model and loading pipelines

  • Own the ERP-to-warehouse data sync so data lands complete and on time

  • Build and fix reconciliations that prove data feeds are complete and accurate

  • Design and build Python, PySpark and Delta Lake pipelines and T-SQL models

  • Mentor BI engineers through design reviews, pairing and code review

From the employer’s posting
Own our data warehouse, including the dimensional model, the pipelines that load it
Own the data sync between our ERP and the warehouse, making sure data lands completely, on time
Build and maintain the reconciliations that prove our feeds are complete and accurate
Design and build data pipelines in Python, PySpark and Delta Lake, and write the T‑SQL behind our models and reconciliations
Support and mentor the other BI Engineers on both reports and the data side, through design reviews, pairing and code review

What you’ll bring

All qualifications

Core experience

  • Experience across the Azure data stack, including Azure Data Factory (ADF), Azure Functions, Logic Apps and Azure Storage.
  • Experience leading or mentoring other engineers, setting technical standards and lifting the quality of what a team produces.
  • Experience of a lakehouse or warehouse migration, or of working through a platform decision such as Databricks to Microsoft Fabric.
  • Strong experience with Databricks and Microsoft Fabric, including Lakehouse and modern data engineering solutions.
  • Knowledge of finance or supply chain processes such as procure to pay, order to cash, month end close or stock and warehouse operations.
  • Strong SQL/T-SQL skills and experience with Kimball dimensional modelling and data warehouse design.
Qualification wording
Experience across the Azure data stack, including Azure Data Factory (ADF), Azure Functions, Logic Apps and Azure Storage.
Experience leading or mentoring other engineers, setting technical standards and lifting the quality of what a team produces.
Experience of a lakehouse or warehouse migration, or of working through a platform decision such as Databricks to Microsoft Fabric.
Strong experience with Databricks and Microsoft Fabric, including Lakehouse and modern data engineering solutions.
Knowledge of finance or supply chain processes such as procure to pay, order to cash, month end close or stock and warehouse operations.
Strong SQL/T-SQL skills and experience with Kimball dimensional modelling and data warehouse design.
Apply at ASOS

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 11, 20267 days ago
Recorded sightings
8
Last seen by us
Nov 18, 2026
Reposted
once since Oct 5, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications. We count a repost when the same title and location comes back as a new listing within 60 days of the last one coming down. Some hiring systems expire listings on a schedule, so repost rates vary by system.

How this job compares

Time since we first saw it

Day 7

Similar jobs usually come down between day 6 and day 56.

At ASOS, jobs usually come down by about day 13.

From 13,984 similar postings that came down, and 47 of ASOS’s. Coming down is not always a hire.

ASOS is hiring

13 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring is picking up
  • Takes jobs down quickly
  • 62% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • T-SQL
  • Azure
  • Databricks
  • Delta Lake
  • Power BI
  • PySpark
Where the posting names them
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
- 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.
Data and BI Experience - 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.
- 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.
- 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.
- 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.
We’d Also Love to See - Experience of a lakehouse or warehouse migration, or of working through a platform decision such as Databricks to Microsoft Fabric. - Knowledge of finance or supply chain processes such as procure to pay, order to cash, month end close or stock and warehouse operations.
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.
- 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. Leadership

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

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.  

  • 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 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.  

Why This Role Matters  

Almost every decision our Finance and commercial teams make rests on numbers this team produces, from month end close and supplier payments through to trading, stock and range performance. If the warehouse is wrong or a feed silently drops data, people make the wrong call.  

This role is where that quality is set. We need someone senior enough to own the warehouse and the ERP data sync end to end, lead a team through a possible platform move, and still be close enough to the detail to build the hard things themselves.  

 

Qualifications

Data and BI Experience  

  • 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.  

  

Leadership  

  • Experience leading or mentoring other engineers, setting technical standards and lifting the quality of what a team produces.  

  • Comfortable taking a strategy someone else has set and turning it into a plan your team can deliver.  

  • Able to prioritise across competing requests and make a clear call on what gets done and what waits.  

Stakeholder Management and Rigour  

  • Confident with stakeholders across Finance, Tech and the commercial teams, able to explain data simply and push back when a request doesn’t stack up.  

  • A genuine eye for data quality, with the patience to chase a reconciliation break until you find the root cause.  

  • Organised and calm under pressure, particularly around month end and peak trading.  

  

We’d Also Love to See  

  • Experience of a lakehouse or warehouse migration, or of working through a platform decision such as Databricks to Microsoft Fabric.  

  • Knowledge of finance or supply chain processes such as procure to pay, order to cash, month end close or stock and warehouse operations.  

  • Experience in retail, ecommerce or fashion, particularly reporting for buying, merchandising or trading.  

  • Experience with CI/CD for data, testing frameworks, data observability or governance and cataloguing tools.  

Why You’ll Love This Role  

  • You will own the data warehouse and the ERP data sync for two of the most important areas of ASOS.  

  • It is a rare mix. You get to lead and mentor a team, set the technical standards, and still build the hard things yourself.  

  • A modern stack with a genuine platform decision ahead, and a real say in where we take it.  

  • Broad exposure across Finance, Commercial, Buying and Product, with work that visibly shapes how ASOS makes decisions. 

Additional Information

BeneFITS’ 

  • Employee discount (hello ASOS discount!) 
  • Employee sample sales 
  • 25 days paid annual leave + an extra celebration day for a special moment 
  • Discretionary bonus scheme 
  • Private medical care scheme 
  • Flexible benefits allowance - which you can choose to take as extra cash, or use towards other benefits 
  • Opportunity for personalised learning and in-the-moment experiences that enable you to thrive and excel in your role 

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 

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

London, England, United Kingdom

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.