Commercial Finance - Analytics & BI Developer

Sainsbury’s Group

City of Westminster

On-site

GBP 45,000 - 65,000

Full time

4 days 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 discount: 10% off shopping
Pensions scheme and life cover
Performance bonus up to 20% of salary
Annual leave with option to buy extra

Job summary

Sainsbury’s Group is seeking a BI Analyst to own analytics and BI products used by Trading and Commercial Finance. You will work with Finance stakeholders to translate questions into technical solutions, delivering from design through release and ongoing support.

A key focus is building Power BI models, using SQL, DAX and data prep tools, with opportunities to automate and modernise processes. You will collaborate with central BI, engineering and platform teams, set development standards, and

Qualifications

  • Experience translating business questions into analytical outputs.
  • End-to-end ownership of development, testing, docs and releases.
  • Hands-on SQL and cloud data warehouse for reporting/analytics.
  • Building Power BI semantic models from scratch with star-schema design.

Responsibilities

  • Own analytics and BI products for Trading and Commercial Finance.
  • Translate stakeholder requests into practical technical solutions and deliver end-to-end.
  • Develop and maintain Power BI semantic models and reporting estate.
  • Automate time-consuming processes and prepare data where needed.
  • Ensure documentation, testing and reconciliation to certified measures.

Skills

SQL
Power BI
DAX
Data modelling
ETL tools

Tools

Alteryx
Power Query
dbt

Job description

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.

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.
Desirable Experience
  • 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’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.

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:

Benefits
  • Colleague discount: save 10% on your shopping online and in-store at Sainsbury’s, Argos, TU and Habitat, and we regularly increase the discount to 15% at points during the year.
  • We’ve got you covered for your future with our pensions scheme and life cover.
  • Performance-related bonus up to 20% of salary, depending on how we perform.
  • Annual holiday allowance, and the option to buy up to an additional week’s holiday.
  • Private healthcare.
  • 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).
  • Access to a great range of discounts from hundreds of other retailers.
  • Employee Assistance Programme.
  • Maternity or adoption leave: up to 26 weeks’ pay.
  • Paternity leave: up to 4 weeks’ pay.
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 Limited • Greater London

Hybrid
GBP 65,000 - 90,000
Colleague discounts
Pensions and life cover
Performance bonus up to 20%
+2
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
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
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 – Retail
Analyst – Retail

Sainsbury’s • City Of London

Hybrid
GBP 42,000 - 66,000
Colleague discount
Pensions
Life cover
+5
Spatial Data Analyst
Spatial Data Analyst

Sainsbury’s Group • Coventry

On-site
GBP 42,000 - 62,000
Colleague discount
Pension scheme
Life cover
+8
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
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
Analyst - Pricing
Analyst - Pricing

Sainsbury’s Group • City of Westminster

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