Lead Data Engineer – Data Warehouse

Borough of Havering; Romford; On-site; GBP 54,000 - 59,000; Full time

Job summary

A local council in Romford is looking for a Lead Data Engineer to take charge of the corporate Data Warehouse and Data Marts, enhancing data processes and leading their migration to Azure. The candidate will manage existing SQL Server environments and develop reporting solutions, ensuring data integrity and governance. This role demands experience in SQL development, Azure services, and data management, contributing to the council's operational and analytical needs.

Benefits

Flexible working policies

Training and development opportunities

Qualifications

• Proven experience managing SQL Server Data Warehouse and Data Mart environments.
• Advanced SQL development and query optimisation skills.
• Experience with Azure SQL Database, Data Factory, and Power BI.

Responsibilities

• Maintain and enhance the Council's existing SQL Server-based data warehouse.
• Lead the migration of the data warehouse into Microsoft Azure.
• Ensure data integrity, security and governance across all data systems.

Skills

SQL development

Data warehouse management

Azure services

SSIS ETL development

C# development

Data governance

Problem-solving

Education

Microsoft certifications (e.g., Azure Data Engineer Associate)

Tools

SQL Server 2019

Microsoft Azure

Power BI

Azure Data Factory

PowerApps

Job description

Grade 9 54267 to 58461 per annum

Lead Data Engineer (Data Warehouse & Data Mart (SQL Server / Azure))

The Council is seeking an experienced Data Lead to take ownership of its corporate Data Warehouse and Data Marts which support critical operational and analytical needs across all service areas. The current data platform is based on Microsoft SQL Server SSIS and a C# enquiry application developed in Visual Studio. This role will lead the modernisation and migration of this environment.

Purpose of the Role

This role ensures that the Council's data infrastructure remains secure, efficient and aligned with its digital transformation and data strategy objectives. The post holder will manage existing SQL Server data warehouse environments, lead modernisation, develop reporting solutions and support service areas in accessing accurate and timely data.

Key Responsibilities

• Maintain and enhance the Council's existing SQL Server-based data warehouse and data marts.
• Design, develop and optimise SQL queries, stored procedures and SSIS ETL packages.
• Lead the migration of the existing on-premise data warehouse into Microsoft Azure.
• Implement Azure Data Services including Azure SQL Database, Data Factory, Power BI and PowerApps.
• Ensure data integrity, security and governance across all data systems.
• Develop Power BI dashboards and reports for operational and strategic insight.
• Collaborate with internal teams across Housing, Social Care, Council Tax, Benefits and Finance.
• Provide technical leadership and mentoring to data team members.
• Promote best practices in data quality, data management and reporting.

Essential Skills & Experience

• Proven experience managing SQL Server Data Warehouse and Data Mart environments (SQL Server 2019 or later).
• Advanced SQL development and query optimisation skills.
• Strong experience with SSIS for ETL development and maintenance.
• Experience with Azure SQL Database, Data Factory, Power BI and PowerApps.
• Experience developing or maintaining C# applications connected to SQL Server.
• Experience delivering data migration or modernisation projects to Azure.
• Understanding of data governance, security and compliance within public sector environments.

Desirable Skills & Knowledge

• Experience with local government datasets including Housing, Social Care, Council Tax, Benefits and Revenues.
• Knowledge of data modelling (star/snowflake schemas) and BI architecture design.
• Familiarity with APIs, Azure DevOps or CI/CD pipelines.
• Awareness of GDPR and UK Data Protection Act compliance requirements.

Microsoft certifications such as Azure Data Engineer Associate or Power BI Data Analyst are desirable.

Personal Attributes

• Strong analytical and problem‑solving skills.
• Excellent communication and stakeholder engagement abilities.
• Self‑motivated and able to manage multiple priorities effectively.
• Commitment to continuous improvement and service excellence in public sector data management.

Reports to: Head of User‑Centred Design and Digital Experience

Pay: Grade 9 54267 to 58461 per annum

The closing date for the receipt of applications is 31 / 1 / 26; however, interest in this job may be high and we therefore reserve the right to close the vacancy early.

Additional Information

We want everyone to choose Havering. When you apply for a job with us your application is considered on its merits regardless of your age, disability, ethnicity, faith, gender identity or sexual orientation. Our residents and service users come from all walks of life and so do our employees. Find out what it means to Choose Havering.

The London Borough of Havering has important responsibilities for safeguarding and promoting the welfare of children, young people and vulnerable adults. If you are appointed to a job that involves working with these groups you may be subject to a Disclosure and Barring Service (DBS) check.

Please attach your supporting statement explaining in no more than two A4 sides why and how you meet the criteria for this role.

We practice anonymised recruitment. Please ensure that you remove all personal information from any documents that you upload.