Business Intelligence Data Engineer

As part of an ambitious transformation and improvement programme, a Local Authority based in Croydon are seeking a talented Business Intelligence Data Engineer to join their growing Business Intelligence team. This is a unique opportunity to use your technical expertise to develop data solutions that directly support frontline services, operational managers and senior leaders.

About the Role

Working closely with the Business Intelligence Strategic Lead, transformation teams, service managers and technical colleagues, you will play a key role in the ongoing development of our Microsoft Azure-based Business Intelligence platform.

You will help design, build and maintain robust data pipelines, corporate data models and Power BI datasets that bring together information from multiple source systems. Your work will support the delivery of accurate, accessible and actionable intelligence that helps shape services across CYPE.

You will also contribute to the development of dashboards and reporting solutions that enable colleagues across the directorate to better understand demand, performance, costs and outcomes, while supporting greater self-service use of data., * Develop, maintain and enhance data solutions within the Council’s Azure-hosted BI platform.

• Design and implement scalable ELT processes to ingest and transform data from multiple systems.
• Build and maintain robust data models and datasets to support reporting and analytics.
• Support the development of Power BI dashboards and self-service reporting capabilities.
• Work closely with stakeholders to understand business needs and translate requirements into technical solutions.
• Ensure data quality, governance, security and performance standards are maintained.
• Support transformation and improvement programmes through the delivery of meaningful data insights.
• Contribute to the continuous improvement of Business Intelligence practices, standards and processes.

Our Technology Stack

You will work with a modern Microsoft data platform including:

• Azure Data Factory
• Azure Data Lake Gen2
• Azure SQL Database / SQL Server
• Microsoft Power BI
• Tabular Models
• T-SQL
• PowerShell
• Azure Cloud Services

Experience with the following would be advantageous:

• Synapse Analytics
• Databricks
• Python
• Master Data Management (MDM)

We’re looking for someone who combines strong technical expertise with excellent stakeholder engagement skills., * Proven experience delivering data and Business Intelligence solutions within a Microsoft data environment.

• Strong knowledge of modern data warehousing principles and data modelling techniques.
• Experience working with large and complex datasets from multiple sources.
• Expertise in Azure Data Factory, Azure Data Lake and Azure SQL technologies.
• Strong Power BI and data visualisation experience.
• Advanced SQL and data transformation skills.
• Excellent analytical and problem-solving capabilities.
• The ability to communicate technical concepts clearly to non-technical audiences.
• Experience working with a wide range of stakeholders to develop practical data solutions.

Experience within local government, education, children’s services or public sector environments would be beneficial, although this is not essential.

Adecco acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. The Adecco Group UK & Ireland is an Equal Opportunities Employer.