Senior BI Engineer in London

Senior BI Engineer in London

London Full-Time 67500 - 82500 £ / year (est.) On-site
ASOS.com

At a Glance

  • Tasks: Lead the BI team in delivering impactful data solutions for FinTech and Fashion Tech.
  • Company: Join ASOS, a global fashion retailer that celebrates individuality and creativity.
  • Benefits: Enjoy employee discounts, flexible benefits, and 25 days of annual leave plus a bonus scheme.
  • Other info: Be part of a dynamic environment with opportunities for personal growth and career advancement.
  • Why this job: Shape critical business decisions with your expertise in data and BI while mentoring a talented team.
  • Qualifications: Strong experience in Python, SQL, and data engineering; leadership skills are a plus.

The predicted salary is between 67500 - 82500 £ per year.

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.

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

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

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

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

Senior BI Engineer in London employer: ASOS.com

ASOS is an exceptional employer that fosters a vibrant and innovative work culture, perfect for creative minds looking to make a significant impact in the fashion industry. With a strong emphasis on collaboration and professional growth, employees are encouraged to develop their skills while working on trend-led collections in a dynamic environment. Located in a bustling area, ASOS offers unique advantages such as access to industry events and a diverse team that inspires creativity and inclusivity.

ASOS.com

Contact Details:

ASOS.com Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior BI Engineer in London

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like ASOS.com!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior BI Engineer at ASOS.com.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like ASOS.com.

✨Apply Directly through Our Website

When you find a suitable opening like Senior BI Engineer at ASOS.com, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Senior BI Engineer in London

Python
Data Engineering
Problem-Solving Skills
Communication Skills
SQL
ETL/ELT Processes
Data Pipeline Development

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at ASOS.com, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at ASOS.com. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at ASOS.com

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at ASOS.com!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.