You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
ASOS

Senior BI Engineer

  • Office
  • 6+ years

Salary

Not stated

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

This is a Senior BI Engineer role in the BI team serving FinTech and Fashion Tech. You report to the Staff Engineering Lead, turn their strategy into delivery, and lead the team day to day as its most senior hands-on data engineer.

The team is responsible for reporting and BI across FinTech and Fashion Tech. This covers the reports the business depends on, the reconciliations that check data feeds, and the data warehouse and the data sync between the ERP and the wider systems.

The stack is Python, PySpark, Delta Lake and Databricks, with T-SQL, Kimball dimensional modelling and Power BI, working alongside Microsoft Dynamics 365 Finance and Operations data structures. The company is assessing a move from Databricks to Microsoft Fabric, so you should be ready to handle a platform decision and any migration that follows.

The company is an online fashion retailer serving customers around the world.

Responsibilities

  • Lead the BI team day to day, turning the Staff Engineering Lead's strategy into a plan the team can deliver.
  • Mentor the other BI Engineers on reports and data work through design reviews, pairing and code review.
  • Act as the senior technical voice in the team, setting standards for modelling, building and testing and raising the quality bar.
  • Balance the team's workload across reporting requests, reconciliations and platform work, and take on the hardest builds yourself.
  • Own the data warehouse, including the dimensional model, the loading pipelines and the standards that keep it consistent as it grows.
  • Own the ERP to warehouse data sync, ensuring data arrives complete, on time and in a usable form.
  • Build and maintain reconciliations that confirm feeds are complete and accurate, and investigate and fix them when they fail.
  • Deliver trusted reporting, from the underlying models 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 models and reconciliations.
  • Monitor cost, performance and reliability across the platform and keep improving live systems.
  • Work with Finance, Tech and Fashion stakeholders, including Commercial, Buying and Product, to understand their data needs.
  • Turn reporting requests into clear requirements, and challenge them when an existing report or a different data cut would be a better fit.
  • Keep stakeholders informed about progress, priorities and risks to the data they rely on.
  • Work with solution, engineering and support teams across FinTech and Fashion Tech so upstream ERP changes do not break downstream reporting.
  • Follow the wider company delivery process, including governance, change control and release cadence, and manage team work in Azure DevOps.
  • Work with Architecture, Security and Risk so the solutions meet company standards, protect sensitive financial data and can pass audit.

Requirements

  • 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.
  • Strong SQL and T-SQL skills, with experience in Kimball dimensional modelling and data warehouse design.
  • Experience integrating ERP data, ideally from Microsoft Dynamics 365 Finance and Operations or another major ERP.
  • Working knowledge of Power BI, DAX and data modelling, focused on useful business reporting.
  • Experience leading or mentoring engineers, setting technical standards and raising team output.
  • Able to take a strategy set by someone else and turn it into a plan your team can deliver.
  • Able to prioritise competing requests and make clear decisions about what gets done now and what waits.
  • Able to explain data simply to Finance, Tech and commercial stakeholders and push back when a request does not hold up.
  • Careful with data quality, and persistent enough to trace a reconciliation break to its root cause.
  • Organised and calm under pressure, especially at month end and during peak trading.
  • Nice to have: experience of a lakehouse or warehouse migration, or of working through a platform decision such as Databricks to Microsoft Fabric.
  • Nice to have: knowledge of finance or supply chain processes such as procure to pay, order to cash, month end close or stock and warehouse operations.
  • Nice to have: experience in retail, ecommerce or fashion, particularly reporting for buying, merchandising or trading.
  • Nice to have: experience with CI/CD for data, testing frameworks, data observability, or governance and cataloguing tools.

Conditions

The company is a Disability Confident Committed employer, so tell the Talent team if you need reasonable adjustments during recruitment.

Benefits

  • Discount on the company's products.
  • Access to employee sample sales.
  • 25 days paid annual leave, plus an extra celebration day for a special moment.
  • Discretionary bonus scheme.
  • Private medical care scheme.
  • Flexible benefits allowance, which you can take as extra cash or put towards other benefits.
  • Support for personalised learning and in-the-moment experiences to help you thrive in your role.

Where you’d work

From the office

About the company

ASOS

  • Industry: E-commerce

Office in London, United Kingdom

Your chances

Worth a look before you spend an evening tailoring a CV for it.

  • 19 checks run
  • 1 red flag

Still hiring?

13 checks

1 red flag

How crowded?

6 checks

No red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details12 facts · Role, Location, Compensation, Employment, Company
Tech stack
  • Python
  • SQL
  • Azure
  • Spark
  • Databricks
  • Power BI
Seniority
Senior
Type
Full-time
Industry
E-commerce
Specialty
BI
Region
United Kingdom
Show 6 more factsShow less

Role

Category
Data & Analytics
Specialty
BI
Seniority
Senior
Experience
6+ years
Tech stack
  • Python
  • SQL
  • Azure
  • Spark
  • Databricks
  • Power BI

Location

Work model
Office
Region
United Kingdom
Office
  • London, United Kingdom

Compensation

Salary
Salary by agreement
Pay period
Annual

Employment

Type
Full-time

Company

Industry
E-commerce

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason