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 CandidateWe'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