BI Developer (SQL, Data Modelling, Power BI)

innocent Alps GmbH; Greater London; On-site; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Private healthcare

Target-based bonus

Birthday day off

Free smoothies

Job summary

innocent Alps GmbH is seeking a BI Developer to turn data from multiple systems into trusted analytical datasets and build scalable data solutions. You’ll design dimensional models, develop T-SQL transformations, and create Power BI semantic models for enterprise reporting and self-serve analytics.

You’ll work with BI Analysts, Data Engineers and business stakeholders to deliver reliable, business-ready data and contribute to evolving analytics and AI capabilities across the organization.

Qualifications

• Experience designing dimensional data models with fact and dimension tables.
• Strong T-SQL skills including views, stored procedures and optimization.
• Understanding of Kimball data modelling concepts (grain, surrogate keys, conformed dimensions, star schemas).
• Experience turning raw/operational data into trusted datasets.
• Ability to investigate complex data issues and reason through them.
• Confidence explaining technical concepts to non-technical stakeholders.

Responsibilities

• Design and build enterprise data products from multiple sources into trusted analytical datasets.
• Create fact and dimension models to simplify complex business data.
• Develop views, procedures and transformation logic using T-SQL.
• Build and optimise Power BI semantic models for reports and self-serve analytics.
• Turn business requirements into scalable data solutions reused across teams.
• Improve performance, quality and reliability of analytics solutions.
• Collaborate with BI Analysts, Data Engineers and stakeholders to solve business problems.
• Share knowledge and raise analytics standards across innocent.

Skills

Dimensional data models

T-SQL

Kimball data modelling

Power BI semantic models

Data integration

Stakeholder communication

Tools

Transact-SQL (T-SQL)

Power BI

SQL Server

Azure

Microsoft Fabric

Job description

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.