> Markdown version of [/jobs/ext/3280185-bi-developer-sql-data-modelling-power-bi](https://www.wearedevelopers.com/jobs/ext/3280185-bi-developer-sql-data-modelling-power-bi). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# BI Developer (SQL, Data Modelling, Power BI)

- **Company:** Innocent Ltd
- **Location:** London, UK
- **Contract:** Permanent contract
- **Skills:** Artificial Intelligence, Business Analytics Applications, Business Systems, Data Warehousing, Operational Data Store, Query Optimization, Power BI, Standard Sql, SQL Stored Procedures, SQL Databases, Transact-SQL, Microsoft Fabric
- **Published:** September 4, 2026
- **Apply:** https://www.totaljobs.com/job/developer-data-and-bi/innocent-drinks-job107942268

## About the Role

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

## Description

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.


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Developer Experience, Platform Engineering and AI powered Apps](https://www.wearedevelopers.com/videos/990-developer-experience-platform-engineering-and-ai-powered-apps)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)
- [Analytics in the Age of Agentic AI: A tour of ClickHouse and Langfuse](https://www.wearedevelopers.com/videos/100240-analytics-in-the-age-of-agentic-ai-a-tour-of-clickhouse-and-langfuse)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [UK Business Culture and Etiquette](https://www.wearedevelopers.com/magazine/326-uk-business-culture-and-etiquette)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)