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.