BI Developer (SQL, Data Modelling, Power BI)

innocent drinks; Greater London; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Private healthcare

Bonus scheme

Free smoothies

Job summary

innocent is seeking a BI Developer to turn data from multiple systems into trusted analytical datasets and to build enterprise data products using SQL, Kimball modelling concepts, Microsoft Fabric and Power BI. You’ll design and optimise semantic models, support reporting and enable self-serve analytics across the business.

Collaborate with BI Analysts, Data Engineers and business stakeholders to translate requirements into scalable data solutions, improve performance and contribute to evolving

Qualifications

• Experience creating dimensional data models with fact and dimension tables.
• Strong T-SQL skills including views, stored procedures and query optimisation.
• Knowledge of Kimball data modelling concepts including grain, surrogate keys, conformed dimensions, and star schemas.

Responsibilities

• 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.

Skills

Dimensional data modeling

T-SQL

Power BI

Kimball data modelling concepts

Data warehousing

Stakeholder communication

Tools

Microsoft Fabric

SQL Server

Azure

Power BI

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.