Skip to Main Content
Location icon
London, London

Commercial Finance - Analytics & BI Developer

Sainsbury's
Office & Professional
Office & Professional
Company logo image
Description

Location
Hybrid - Store Support Centre and home, with approximately one day a week in the office (London, Manchester or Ansty, Coventry).

Hours
Full Time

Salary
£10,000 per month

About the Role
This is an opportunity to join a newly formed Trading Performance & Analysis team within Commercial Finance at Sainsbury's. The team operates at the intersection of commercial decision-making and data, collaborating closely with Trading Finance leaders, the central Finance BI and reporting team, Retail and Supply Chain analytics colleagues, and central data engineering. The goal is to create trusted, scalable analytics that help colleagues understand performance, make better decisions, and reduce time spent on manual reporting.

You will take hands-on ownership of the analytics and business intelligence products used by Trading and Commercial Finance. Day-to-day responsibilities include working directly with Finance stakeholders to understand the rationale behind requests, translating those needs into practical technical solutions, and delivering them from design through to release and ongoing support. A key focus will be building and maintaining Power BI semantic models and the reporting estate using SQL, DAX, and appropriate data preparation tools.

You will identify opportunities to automate time-consuming processes, prepare and transform data where local supplementation is needed, and ensure solutions are documented, tested, and reconciled to certified measures. Working with central BI, engineering, and platform teams, you will help set development standards and champion quality and control, ensuring compliance with internal control and digital control frameworks.

You will also deputise for the Head of Trading Performance & Analysis on analytics and technical matters when required. The role offers scope to build experience with Alteryx, workflow automation, AI-assisted development, machine learning, and other emerging tools used within Finance.

At Sainsbury's, you will experience a fast-moving FTSE business where your work has visible impact. The team values your ideas and supports your development, offering a real sense of purpose and responsibility.

Requirements

Experience
- Practical experience working within Commercial Finance data and terminology, with examples of translating commercial or financial questions into analytical outputs.
- Demonstrated ownership of end-to-end development including stakeholder requirements, testing, documentation, version control or controlled release, and ongoing support.
- Proven experience using SQL and a cloud data warehouse to source, query, and validate data for reporting or analytics.
- Hands-on experience designing and building Power BI semantic models from scratch, including star-schema design and DAX, and delivering reporting solutions through to production release.
- Experience preparing or transforming data using ETL or data-preparation tools such as Alteryx, Power Query, dbt, or equivalent platforms.

About you
You combine practical BI development skills with an understanding of Finance data and terminology. You can confidently translate commercial questions into technical solutions and explain complex ideas clearly to non-technical colleagues. You take accountability for your work from initial requirements through delivery and support, prioritising effectively without close supervision. You bring curiosity about business problems, apply structured development and control practices, and can constructively challenge stakeholders or technical designs when needed. Experience in retail, FMCG, or other commercial environments is beneficial, especially with measures such as sales, margin, promotions, markdown, stock, or supplier income.

Qualifications
- A Finance qualification (e.g., ACA, ACCA, CIMA) is desirable but not essential if you can demonstrate equivalent experience working with Finance teams and data.
- Experience with Git-based version control, ideally GitHub, including branching and pull requests, is advantageous; support is available to develop these skills.

Expiry date: 19/12/2026
Commercial Finance - Analytics & BI Developer
Company:
Sainsbury's
Job Type:
Full-time
Location:
London, London