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.
/01 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
/02 Job 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.
/03 Additional Info
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
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
what our people say
Meet The Team
Meet Zijiao Li -
Tech @ ASOS
Meet Amy Richardson -
Tech @ ASOS
Meet Si Jobling -
Tech @ ASOS
I love working at ASOS in my team because of the great atmosphere. From day one I already felt like being part of the team, everyone is so friendly, approachable and willing to help. It’s the place where you feel trusted and are given the opportunities & time to explore your full potential. As someone who just relocated to London, I also appreciate the international and cultural diverse environment – it’s ok to be whoever you want to be!
As a software engineer with a love for fashion, I feel extremely lucky to be part of a fashion company that priorities technology, innovation and customer experience to the same degree as their clothing.
As someone who left ASOS after 7 years but came back, it speaks volumes how much I love working at ASOS. The obvious reason is the people, not just in Tech but beyond. There's an unspoken respect and authenticity between everyone who works here
Zijiao Li
Tech @ ASOS
I love working at ASOS in my team because of the great atmosphere. From day one I already felt like being part of the team, everyone is so friendly, approachable and willing to help. It’s the place where you feel trusted and are given the opportunities & time to explore your full potential. As someone who just relocated to London, I also appreciate the international and cultural diverse environment – it’s ok to be whoever you want to be!
Amy Richardson
Tech @ ASOS
As a software engineer with a love for fashion, I feel extremely lucky to be part of a fashion company that priorities technology, innovation and customer experience to the same degree as their clothing.
Si Jobling
Tech @ ASOS
As someone who left ASOS after 7 years but came back, it speaks volumes how much I love working at ASOS. The obvious reason is the people, not just in Tech but beyond. There's an unspoken respect and authenticity between everyone who works here
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
our business values
loading
We are Customer First
We couldn’t be ASOS without our customers.
Across every behaviour, value, and all that we do, we see everything through our customers’ eyes. That means never taking anything for granted and always zeroing in on every single detail. So we can always bring our best as a team, and our customers can have an amazing experience, every time.
We are Authentic
We work together to be honest, transparent, and our full authentic selves.
This is our ASOS. Our culture, built on collaboration and togetherness, and supported by what’s real and honest. We know that we win bigger when we win as a diverse team. That means celebrating our differences and using them to help us stand out from the crowd, without losing our authenticity and individuality.
We are Brave
We challenge each other to aim high and reach our potential.
Doing nothing gets us nowhere. We may be proud of everything we’ve done so far, but there’s still so much more to explore. We believe we can always be wiser, faster, stronger, bigger, braver, kinder…so asking ‘why’ isn’t just a question, it’s a necessity. We use our voice to drive us forward, speaking up on the things our people and customers care about and using our curiosity to create possibility.
We are Creative
We know innovation leads to inspiration – it’s what makes us stronger
Change is in our DNA. By acting fast and staying one step ahead of the curve, we can be a leader, not a follower. But for our products and platform to be innovative, they have to be fuelled by creative passion and a deep understanding of our customers and our people.
We always Deliver
We couldn’t be excellent without evidence – so whatever we’re doing, we have proof of why we’re doing it.
It takes facts and data to tell our stories and help us make our decisions in the most effective way possible. This means we can do what we say and own what we do, no matter how long it takes us to do it. We aren’t about nonsense ifs, buts and maybes, we’re about creating an ASOS that’s built for future success on delivered success.
Our Benefits
Employee Discount
The most asked-about benefit! As an ASOSer, you’ll receive an exclusive employee discount. You can also nominate a family member or friend to share your discount with.
Pension
Retirement might not be on your mind right now, but it’s important to prep for it. We offer matched contributions up to 5% to help you save.
Private Medical Care scheme
If you join our Private Medical Care scheme, you’ll get fast and effective access to medical cover.
Bonus
What we achieve is always a team effort. That’s why we offer a discretionary bonus scheme which rewards you based on our group financial and strategic performance.
Celebratory Day!
Get an extra day off in addition to the 25 days of annual leave you get! Spend it celebrating the big days in life, whether it’s birthdays, cultural holidays, weddings and anything else.
Shuttlebus Service (if you're based in our Leavesden office)
It’s more of a work perk, but we offer a free shuttlebus between Watford station and our office in Leavesden.
Sample Sales
We’ve always got fun things happening in our offices, but the one ASOSers get most excited about is our sample sales. Plus, all proceeds from the sample sale get donated to the ASOS Foundation, which helps our charity partners abroad.
Career Development
You’ll have the opportunity for personalised learning and in-the-moment experiences to create a dynamic and agile learning environment that empowers you to thrive and excel in your role.
Summer Hours
We finish at 3pm on Fridays in June, July and August!! This perk doesn’t mean a dip in your salary – it just gives you extra freedom to enjoy those summer weekends however you want.
Location
Our HQ in London
Our HQ in Camden was once a cigarette factory – now, the iconic Art Deco building has been completely renovated with spacious office areas, ASOS Studios (where we shoot all our products), beauty rooms and a free gym. There’s also a subsidised canteen and café.