Commercial Finance - Analytics & BI Developer in City of Westminster

Commercial Finance - Analytics & BI Developer in City of Westminster

City of Westminster Full-Time 40500 - 49500 £ / year (est.) On-site
Sainsbury’s Group

At a Glance

  • Tasks: Own analytics and BI products, translating finance needs into technical solutions.
  • Company: Join Sainsbury’s, a fast-paced FTSE business with a collaborative culture.
  • Benefits: Enjoy discounts, bonuses, private healthcare, and flexible working options.
  • Other info: Dynamic environment with opportunities for growth and learning.
  • Why this job: Make a real impact in finance while developing your skills with cutting-edge tools.
  • Qualifications: Experience in BI development, SQL, and Power BI; finance knowledge is a plus.

The predicted salary is between 40500 - 49500 £ per year.

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 Git Hub, 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.

Commercial Finance - Analytics & BI Developer in City of Westminster employer: Sainsbury’s Group

Join our Argos Local Fulfilment Centre as a Warehouse Operative and become part of a dynamic, 24-hour team dedicated to delivering exceptional customer service. With a strong focus on inclusivity and employee growth, we offer a supportive work environment where you can thrive, alongside generous benefits such as colleague discounts, wellbeing support, and opportunities for career progression. Experience the camaraderie of a family-like atmosphere while making a tangible impact on our customers' experiences.

Sainsbury’s Group

Contact Details:

Sainsbury’s Group Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Commercial Finance - Analytics & BI Developer in City of Westminster

✨Get to Grips with Data Visualisation Tools

If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.

✨Join Local Business Intelligence Meetups

Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Sainsbury’s Group!

✨Engage with Online BI Communities

Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.

✨Leverage Your University’s Career Support

If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!

We think you need these skills to ace Commercial Finance - Analytics & BI Developer in City of Westminster

Power BI
SQL
DAX
Data Preparation
ETL
Alteryx
Cloud Data Warehouse

Some tips for your application 🫡

Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.

Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.

Tailor Your Documents for Us:When applying for a full-time role at Sainsbury’s Group, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!

Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.

How to prepare for a job interview at Sainsbury’s Group

✨Show off your analytical skills

In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!

✨Practice your technical know-how

Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.

✨Portfolio of Projects

Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.

✨Know their business model

Get familiar with Sainsbury’s Group’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.