BI Developer (SQL, Data Modelling, Power BI)

Innocent Limited; Greater London; On-site; GBP 50,000 - 75,000; Full time

Benefits offered by this job

Private healthcare

Target-based bonus

Free smoothies

Job summary

Innocent Limited in the UK is seeking a BI Developer to turn data into trusted models and analytics. You will build enterprise data products, convert data from multiple systems into clear datasets, and deliver reliable reporting via Power BI and SQL-based solutions.

You’ll work closely with BI Analysts and stakeholders to understand business processes, optimise analytics, and support evolving AI capabilities within the platform.

Qualifications

• Strong experience creating dimensional data models (fact/dimension tables).
• Expertise in T-SQL: views, stored procedures, query optimisation.
• Proficient with Power BI and building semantic models for self-serve analytics.
• Knowledge of Kimball data modelling concepts (grain, surrogate keys, conformed dimensions, star schemas).
• Experience turning raw or operational data into trusted datasets.
• Ability to investigate complex data issues and explain technical concepts to non-data users.

Responsibilities

• Designing and building enterprise data products combining data from multiple systems.
• Creating fact and dimension models to simplify complex data.
• Developing views, stored procedures and ETL logic using T-SQL.
• Building and optimising Power BI models to support reporting.
• Translating business requirements into scalable data solutions for teams.
• Supporting performance, quality and reliability of analytics solutions.
• Collaborating with BI Analysts, Data Engineers and stakeholders to solve real problems.
• Sharing knowledge and raising analytics standards across the business.

Skills

Dimensional modelling

T-SQL

Power BI

Kimball methodology

Data modelling

Azure / Microsoft Fabric

Data governance

Job description

Here at innocent, we’re on a mission to make it easier for everyone to get more fruit and veg into their bodies. We started back in 1999 and since then we’ve gone from selling a few smoothies at a music festival to becoming one of Europe’s biggest drinks companies with around 1,000 people (and the B Corp seal of approval).

It’s nice to be able to say things like that but we’re not patting ourselves on the back just yet. We want to show everyone that it’s possible to be a successful business while looking after people and the planet too, so we’re trying to get better in pretty much every way. And that’s where this job comes in.

A Bit About The Role

Data is becoming one of innocent's most important ingredients. We're investing in a modern Microsoft analytics platform that brings together information from across our business to help teams understand what's happening, spot opportunities, and act with confidence to achieve our ambitions as a company

As a BI Developer, you'll help build the trusted data products that sit at the heart of this. You'll turn data from multiple systems into clear, reliable models that people across the business trust and consume via enterprise reports and self-serve analytics. Working with SQL, Kimball data modelling concepts, Microsoft Fabric and Power BI, you'll help create the foundations that supports reporting today and future Artificial Intelligence (AI) capabilities tomorrow.

This isn't a role for someone who wants to spend all day hidden behind code. The best solutions come from understanding how the business actually works, so we'll be looking for someone who's naturally curious, asks good questions, and enjoys getting close to the processes, people and decisions behind the data.

You’ll be

• Designing and building enterprise data products that combine data from multiple business systems into trusted analytical datasets.
• Creating fact and dimension models that make complex business data easy to understand and use.
• Developing views, stored procedures and transformation logic using Transact-SQL (T-SQL).
• Building and optimising Power BI semantic models that support reporting and self-serve analytics.
• Turning business requirements into scalable data solutions that can be reused across teams.
• Supporting and improving the performance, quality and reliability of analytics solutions.
• Working closely with BI Analysts, Data Engineers and business stakeholders to solve real business problems.
• Sharing knowledge, contributing to development standards and helping raise the bar for analytics across innocent.

You’ll have

• Strong experience creating dimensional data models using fact and dimension tables.
• Excellent T-SQL skills, including views, stored procedures and query optimisation.
• A good understanding of Kimball data modelling concepts including grain, surrogate keys, conformed dimensions, and star schemas.
• Experience turning raw or operational data into trusted, business-ready datasets.
• The ability to investigate complex data issues and work through them logically.
• Confidence explaining technical concepts to people who don't live and breathe data.

You’ll get

• The chance to shape how trusted data is built and used across innocent.
• Exposure to Microsoft Fabric, SQL Server, Power BI and Azure as part of our evolving analytics platform.
• Opportunities to work with teams across Commercial, Marketing, Finance, and Supply Chain
• The opportunity to build data products that will be used by hundreds of people across the business.
• A seat at the table as we develop our future data and AI capabilities.
• Colleagues who care about good design, simple solutions and helping each other learn.
• The freedom to introduce better ways of working, challenge assumptions, and leave things in a better place than you found them.

We want innocent to be a great place to work, so we do lots of stuff to make people feel at home and try to make sure everyone’s career is shaping up the way they want it to. There are plenty of opportunities to have a go at something new or take things further.

In exchange for helping us do business in the right way, you’ll get a solid rewards package that includes a salary (phew), private healthcare, a target-based bonus, and a bunch of other nice things like a day off on your birthday. And yes, you get free smoothies.

We also know that not all our drinkers come from the same background, or think the same – so why should we? At innocent, we want to be a great place to work where a diverse bunch of people from all backgrounds can turn up and thrive. When we hire, we want all the juice, bits, and pulp that make you who you are.

Even if you don’t think you can tick all the boxes, if the job sounds right for you, come and throw your hat in the ring.

Probably best to get your skates on though, as we might close this early if we get loads of applications.