Permanent

BI Developer

cLogo
SoCode Limited

Job Description

The OpportunityWe 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 ResponsibilitiesDevelop, 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 ..... full job details .....