Commercial Finance – Analytics & BI Developer

Sainsbury's Limited

Greater London

Hybrid

GBP 65,000 - 90,000

Full time

6 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Colleague discounts
Pensions and life cover
Performance bonus up to 20%
Private healthcare
Cycle to work

Job summary

Sainsbury's Limited is seeking an Analytics & BI Developer to own and advance our Commercial Finance analytics ecosystem. You will design, build and maintain Power BI models and semantic layers, using SQL and DAX, while partnering with Finance stakeholders to translate questions into scalable solutions.

You’ll drive data automation and documentation, work with central BI and data teams, and help set development standards across the team.

Qualifications

  • Hands-on ownership of analytics and BI products used by Finance teams.
  • Translate business requests into practical technical solutions.
  • Build and maintain Power BI semantic models and reporting estates.
  • Automate time-consuming processes and transform data as needed.
  • Document, test and reconcile solutions to certified measures.
  • Collaborate with central BI, engineering and platform teams to set standards.
  • Explore Alteryx, workflow automation, AI-assisted development and ML tools.

Responsibilities

  • Take hands-on ownership of analytics and BI products used by Trading and Finance.
  • Work with Finance stakeholders to understand rationale and deliver from design to release.
  • Develop Power BI models with star-schema design and DAX, delivering production reporting.
  • Identify automation opportunities and data preparation needs with appropriate tooling.
  • Document, test and reconcile outputs to certified measures and controls.
  • Partner with BI, data engineering and platform teams to raise standards and quality.

Skills

BI development
Stakeholder engagement
SQL
DAX
Data modeling
Automation

Education

Part-qualified or qualified accountant (ACA, ACCA or CIMA)

Tools

Power BI
Alteryx
dbt
GitHub
Cloud data warehouse

Job description

Commercial Finance – Analytics & BI Developer

Salary: Competitive Plus Benefits
Location: London Store Support Centre, London, EC1M 6HA
Hours: Full time
Contract type: Permanent
Business area: Finance & Transformation
Closing date: 20 November 2026
Requisition ID: 400097941

We’d all like amazing work to do, and real work-life balance. That’s waiting for you here at Sainsbury’s. For a FTSE business, we move incredibly fast. When we’re not leading projects, we’re supporting teams across the wider group to achieve their goals. And here, you can see the impact of your work as soon as you walk into a store, giving you a real sense of purpose and responsibility. Better still, the team around you will listen to your ideas and opinions, and you’ll have every chance to try something new. The scale and complexity of our business mean there’s always something new to learn, and we’ll support you every step of the way. We’re trusted to get on with it. So get ready to make things happen.

Joining Date – March 2027

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

About the team

This is an opportunity to join a newly formed Trading Performance & Analysis team within Commercial Finance. We sit where commercial decision-making meets data, working alongside Trading Finance leaders, the central Finance BI and reporting team, Retail and Supply Chain analytics colleagues, and central data engineering. Our aim is to create trusted, scalable analytics that help colleagues understand performance, make better decisions and spend less time on manual reporting.

More about the role

You will take hands-on ownership of the analytics and business intelligence products used by Trading and Commercial Finance. Day-to-day, you will work directly with Finance stakeholders to understand the rationale behind a request, translate that need into a practical technical solution, and deliver it from design through to release and ongoing support. A key focus will be building and maintaining Power BI semantic models and the reporting estate that sits on them, using SQL, DAX and appropriate data preparation tools.

You will also identify opportunities to automate time-consuming processes, prepare and transform data where local supplementation is needed, and ensure your solutions are documented, tested and reconciled to certified measures. Working with central BI, engineering and platform teams, you will help set development standards across the team and champion quality and control, ensuring both your own work and the wider team’s outputs comply with internal control and digital control frameworks. You will also work alongside partner resources and deputise for the Head of Trading Performance & Analysis on analytics and technical matters when required. The role also offers scope to build experience with Alteryx, workflow automation, AI-assisted development, machine learning and other emerging tools used within Finance.

More about you

You combine practical BI development capability with an understanding of Finance data and terminology. You can move confidently between a commercial question and the technical work needed to answer it, explaining complex ideas clearly to non-technical colleagues and recognising when data or a result does not look right. A Finance qualification may be useful, but it is not required where you can demonstrate equivalent experience working with Finance teams and data.

You are comfortable taking accountability for work from initial requirements through to delivery and support, prioritising effectively without close supervision. You bring curiosity about the business problem, apply structured development and control practices, and can constructively challenge stakeholders or technical designs when needed. Experience in retail, FMCG or another commercial environment would be helpful, particularly where you have worked with measures such as sales, margin, promotions, markdown, stock or supplier income.

  • 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.
  • Demonstrable experience using SQL and a cloud data warehouse to source, query and validate data for reporting or analytics.
  • Proven 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

Evidence of preparing or transforming data using an ETL or data-preparation tool such as Alteryx, Power Query, dbt or an equivalent platform.

  • Part-qualified or qualified accountant (ACA, ACCA or CIMA)
  • Experience of Git-based version control, ideally using GitHub, including branching and pull requests, would be advantageous, with support available to develop these skills.

We are committed to being a truly inclusive retailer so you’ll be welcomed whoever you are and wherever you work. Around here, there’s always the chance to try something new — whether that’s as part of an evolving team or somewhere else across the business - and we take development seriously and promise to support you. We also recognise and celebrate colleagues when they go the extra mile and, where possible, offer flexible working. When you join our team, we’ll also offer you an amazing range of benefits. Here are some of them:

Starting off with colleague discount, you'll be able to save 10% on your shopping online and instore at Sainsbury's, Argos, TU and Habitat, and we regularly increase the discount to 15% at points during the year. We've also got you covered for your future with our pensions scheme and life cover. You'll also be able to share in our success as you may be eligible for a performance-related bonus of up to 20% of salary, depending on how we perform.

Your wellbeing is important to us too. You'll receive an annual holiday allowance, and you can buy up to an additional week's holiday, and we provide private healthcare. We also offer other benefits that will help your money go further such as season ticket loans, interest free car loan of up to £10k, cycle to work scheme, health cash plans, salary advance (where you can access some of your pay before pay day) as well access to a great range of discounts from hundreds of other retailers. And if you ever need it there is also an Employee Assistance Programme.

Moments that matter are as important to us as they are to you which is why we give up to 26 weeks’ pay for maternity or adoption leave and up to 4 weeks’ pay for paternity leave.

Please see www.sainsburys.jobs for a range of our benefits (note, length of service and eligibility criteria may apply).

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Commercial Finance - Analytics & BI Developer
Commercial Finance - Analytics & BI Developer

Sainsbury’s Group • City of Westminster

On-site
GBP 45,000 - 65,000
Colleague discount: 10% off shopping
Pensions scheme and life cover
Performance bonus up to 20% of salary
+1
Finance Analyst – Labour Costs
Finance Analyst – Labour Costs

Sainsbury's Limited • Greater London

Hybrid
GBP 65,000 - 90,000
Colleague discount
Pensions and life cover
Performance bonus up to 10%
+1
Lead Analyst – Retail
Lead Analyst – Retail

Sainsbury’s • City Of London

Hybrid
GBP 60,000 - 90,000
Colleague discount
Pensions
Life cover
+6
Analyst – Retail
Analyst – Retail

Sainsbury’s • City Of London

Hybrid
GBP 42,000 - 66,000
Colleague discount
Pensions
Life cover
+5
Finance Analyst - Labour Costs
Finance Analyst - Labour Costs

Sainsbury’s Group • City of Westminster

Hybrid
GBP 55,000 - 75,000
Colleague discount
Pensions & life cover
Bonus up to 10%
+7
Senior Data Scientist
Senior Data Scientist

Sainsbury's Limited • Greater London

Hybrid
GBP 90,000 - 130,000
Colleague discount
Pensions and life cover
Performance bonus (up to 20% of salary
+8
Analyst - Pricing
Analyst - Pricing

Sainsbury’s Group • City of Westminster

On-site
GBP 65,000 - 85,000
Discounts on shopping
Pensions
Life cover
+1
Analyst - Retail
Analyst - Retail

Sainsbury’s Group • City of Westminster

On-site
GBP 52,000 - 68,000
Colleague discount 10%–15%
Pensions scheme
Performance-related bonus up to 10%
+2
Analyst – Pricing
Analyst – Pricing

Sainsbury’s • City Of London

On-site
GBP 55,000 - 90,000
Colleague discount (10%–15%)
Pensions and life cover
Performance-related bonus up to 10%
+2
Financial Accountant – Gross Margin Accounting
Financial Accountant – Gross Margin Accounting

Sainsbury's Limited • Greater London

Hybrid
GBP 55,000 - 75,000
Colleague discount
Pensions scheme
Life cover
+3