Senior BI Engineer

Follow the Gradient

Greater London

On-site

GBP 90,000 - 120,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Employee sample sales
25 days paid annual leave
Discretionary bonus
Private medical care
Flexible benefits allowance
Learning opportunities

Job summary

ASOS is looking for a Senior BI Engineer to lead the BI team across FinTech and Fashion Tech. You will translate strategy into delivery, mentor engineers, and own key data assets.

You will manage the data warehouse, ERP data sync, and oversee platform decisions such as a potential move to Microsoft Fabric, while delivering performant Power BI reports with a focus on data quality and cost efficiency.

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.
  • Leadership experience in mentoring engineers and setting technical standards.

Responsibilities

  • Mentor the BI team and turn strategy into deliverable plans.
  • Support and mentor the BI Engineers through design reviews, pairing and code review.
  • Set standards for data modeling, building, testing, and quality.
  • Prioritise work across reporting, reconciliations and platform tasks, tackling the hardest builds.
  • Own the Data Warehouse and Data Sync pipelines and ensure data lands correctly from ERP to warehouse.

Skills

Python
SQL
PySpark
Delta Lake
Databricks
Power BI
Kimball modelling
Data warehouse design
ERP data integration
Azure data stack
Microsoft Fabric
DAX
Leadership

Tools

Azure Data Factory
Azure Functions
Logic Apps
Azure Storage
T-SQL

Job description

We'reASOS, 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'refree 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'reDisability 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 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
  • 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

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply

Job Location
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior BI Engineer
Senior BI Engineer

ASOS • Greater London

On-site
GBP 90,000 - 130,000
Employee discount
Employee sample sales
25 days annual leave + extra day
+4
Senior BI Engineer
Senior BI Engineer

ASOS.com • Greater London

On-site
GBP 90,000 - 130,000
Employee discount (hello ASOS discount
Employee sample sales
25 days paid annual leave + an extra '
+4
Senior Software Engineer
Senior Software Engineer

ASOS • Greater London

On-site
GBP 90,000 - 130,000
Competitive salary & pension
Private medical care
Bonus performance related
+6
Senior Finance Analyst - Group FP&A
Senior Finance Analyst - Group FP&A

asos.com Ltd • Greater London

Hybrid
GBP 70,000 - 90,000
Annual leave 25 days
Private medical care
Performance-based recognition
+2
Senior Data Engineer
Senior Data Engineer

ASOS • Greater London

On-site
GBP 70,000 - 120,000
Employee discount (hello ASOS discount
Employee sample sales
25 days paid annual leave + an extra
+4
Power BI Developer
Power BI Developer

ASOS.com • Greater London

Hybrid
GBP 55,000 - 75,000
Employee discount
25 days paid annual leave
Private medical care
+1
Associate Data Engineer
Associate Data Engineer

asos.com Ltd • Greater London

On-site
GBP 60,000 - 90,000
Employee discount
Employee sample sales
Annual leave + celebration day
+3
Senior Product Analyst
Senior Product Analyst

ASOS.com • Greater London

On-site
GBP 70,000 - 100,000
Employee discount (ASOS)
Employee sample sales
25 days paid annual leave + extra day
+4
Head of Workplace Technology
Head of Workplace Technology

ASOS • Greater London

On-site
GBP 95,000 - 135,000
Employee discount (hello ASOS discount
Employee sample sales
25 days paid annual leave + an extra莎
+4
Finance Analyst - Supply Chain
Finance Analyst - Supply Chain

ASOS.com • London

On-site
GBP 30,000 - 50,000
Employee discount
Personal development opportunities
Employee sample sales
+5