BI Developer

SoCode Recruitment

Cambridge

On-site

GBP 50,000 - 70,000

Full time

29 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

SoCode Recruitment is partnering with an established Cambridge technology business to recruit a hands-on BI / Data Developer to support the Microsoft BI stack, including SQL Server, data warehousing, ETL/ELT, SSAS Tabular and Power BI.

You will translate requirements into data models, dashboards and analytical solutions while maintaining performance, reliability and security, including Row-Level Security, and work with stakeholders across the business to deliver scalable BI solutions.

Qualifications

  • Experience in a Microsoft BI-focused role.
  • Strong SQL Server and T-SQL skills.
  • Knowledge of data warehousing and dimensional modelling.
  • Experience developing SSAS Tabular and/or Power BI semantic models.
  • Experience with data security and RLS.

Responsibilities

  • Develop, maintain and support BI databases, data warehouses and data marts.
  • Manage SQL Server environments, including performance monitoring and backups.
  • Design, develop and maintain ETL/ELT pipelines across multiple data sources.
  • Write and optimise complex SQL queries, stored procedures and views.
  • Build and maintain SSAS Tabular models and Power BI semantic models.
  • Develop and optimise DAX measures and data models.
  • Create Power BI dashboards and reports with performance and accessibility in mind.
  • Ensure security and access controls, including Row-Level Security.
  • Monitor data-refreshes and resolve data-quality issues and performance bottlenecks.
  • Collaborate with stakeholders to translate requirements into BI solutions.
  • Maintain technical documentation covering data sources, transformations and architecture.
  • Follow source control, testing, deployment and change-management practices.
  • Support modernisation of BI estate and reduce technical debt.

Skills

SQL Server
T-SQL
Power BI development
DAX
Data modelling
Star schema
ETL/ELT

Tools

SSAS Tabular
Power BI

Job description

The Opportunity

We are working with an established technology business in Cambridge that is looking to recruit a BI / Data Developer to support the development, maintenance and modernisation of its Microsoft BI and data platform.

This is a hands‑on technical role covering the full Microsoft BI stack, including SQL Server, data warehousing, ETL/ELT, SSAS Tabular and Power BI. You will be responsible for ensuring the reliability, performance and scalability of existing reporting solutions, while helping to modernise the wider BI environment and reduce legacy technical debt.

Working closely with stakeholders across the business, you will translate reporting requirements into effective data models, dashboards and analytical solutions, balancing day‑to‑day platform support with ongoing development and improvement.

Key Responsibilities
  • Develop, maintain and support BI databases, data warehouses, data marts and associated data structures.
  • Manage and optimise SQL Server environments, including performance monitoring, indexing, query optimisation, backups and troubleshooting.
  • Design, develop and maintain ETL/ELT pipelines to extract, transform, validate and load data from multiple business systems.
  • Write and optimise complex SQL queries, stored procedures, views and data transformations.
  • Build and maintain SSAS Tabular and Power BI semantic models, applying star‑schema and dimensional‑modelling principles.
  • Develop and optimise DAX measures, calculation groups, relationships, hierarchies and model security.
  • Create and enhance Power BI dashboards and reports, ensuring solutions are performant, reliable and accessible.
  • Implement appropriate security and access controls, including Row‑Level Security (RLS).
  • Monitor and resolve data‑refresh failures, data‑quality issues, reporting errors and performance bottlenecks.
  • Work with internal stakeholders to understand business requirements and deliver effective BI solutions.
  • Maintain technical documentation covering data sources, transformations, models, dependencies and architecture.
  • Follow development best practices around source control, testing, deployment and change management.
  • Contribute to the modernisation of the existing BI estate, simplifying legacy solutions, consolidating datasets and reducing technical debt.
What We’re Looking For
  • Strong commercial experience as a BI Developer, Data Developer or in a similar Microsoft BI-focused role.
  • Strong Microsoft SQL Server and T‑SQL skills, including database development, administration and performance tuning.
  • Good understanding of data warehousing, dimensional modelling, star schemas and ETL/ELT processes.
  • Experience developing SSAS Tabular and/or Power BI semantic models.
  • Strong Power BI development experience, including DAX, Power Query, data modelling and report development.
  • Experience supporting business‑critical BI environments, troubleshooting data‑refresh issues, performance problems and data‑quality challenges.
  • Understanding of data security, access controls and Row‑Level Security (RLS).
  • Ability to work directly with business stakeholders and translate requirements into practical technical solutions.
  • Strong analytical and problem‑solving skills, with the ability to take ownership of technical challenges.
  • Good communication and documentation skills, alongside an organised approach to development and deployment.
Desirable Experience
  • Experience modernising legacy Microsoft BI environments, particularly transitioning towards Power BI, Microsoft Fabric, Tabular semantic models and cloud‑based data platforms.
  • Experience working with Dataverse and the wider Microsoft Power Platform.
The Ideal Candidate

We’re looking for a hands‑on BI / Data Developer who enjoys working across the Microsoft data stack, from SQL databases and ETL processes through to semantic modelling and Power BI reporting.

You’ll be comfortable supporting an established BI environment while identifying opportunities to improve performance, modernise existing solutions and introduce better development practices. The ability to engage with non‑technical stakeholders and take ownership of solutions from requirements through to delivery will be particularly important.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior BI Developer - Power BI
Senior BI Developer - Power BI

Chapman Tate Associates • Wolverhampton

Hybrid
GBP 60,000 - 80,000
Business Intelligence Developer
Business Intelligence Developer

Pearson Whiffin Recruitment Group • Margate

On-site
GBP 45,000 - 65,000
Business Intelligence Developer
Business Intelligence Developer

Harnham • Greater London

Hybrid
GBP 41,000 - 50,000
Hybrid working
One day a week in London office
Career development
+1
BI Engineer - Remote UK Based
BI Engineer - Remote UK Based

Hyper Recruitment Solutions • United Kingdom

Hybrid
GBP 60,000 - 90,000
Flexible working arrangements (remote/
Hybrid work options
Power BI Developer
Power BI Developer

Synergy Resourcing Solutions, Company • Ipswich

Hybrid
GBP 42,000 - 52,000
Senior BI Developer
Senior BI Developer

ParentPay Group • United Kingdom

Remote
GBP 70,000 - 90,000
Business Intelligence Developer
Business Intelligence Developer

Voyage Care Ltd • Lichfield

Hybrid
GBP 42,000 - 56,000
Business Intelligence Developer
Business Intelligence Developer

TrustTech Recruitment • Chester

On-site
GBP 55,000 - 75,000
BI Developer
BI Developer

Harnham • Greater London

Hybrid
GBP 41,000 - 50,000
Business Intelligence Developer
Business Intelligence Developer

i3 • Essex

Hybrid
GBP 59,000 - 72,000