Lead Data Engineer – Data Warehouse

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

Job summary

A local government authority in Romford is seeking a Lead Data Engineer to oversee its Data Warehouse and Data Mart initiatives using SQL Server and Azure. This role involves modernizing existing systems, developing reporting solutions, and ensuring data governance. Candidates should have management experience in SQL Server environments, strong SQL development skills, and familiarity with Azure Data Services. The position offers a salary range of £54,267 to £58,461 per annum and includes a commitment to diversity and inclusion.

Benefits

Diversity and inclusion commitment

Qualifications

• Experience managing SQL Server Data Warehouse environments.
• Advanced SQL development skills required.
• Experience with Azure services and data governance.

Responsibilities

• Maintain and enhance SQL Server-based data warehouses.
• Lead migration to Azure and manage data integrity.
• Develop Power BI dashboards for insights.

Skills

Data Warehouse Management

SQL Query Development

SSIS ETL Development

Azure SQL Database

Power BI

Data Governance

C# ASP.NET Development

Data Migration

Data Modeling

GDPR Awareness

Education

Microsoft Azure Data Engineer Associate

Power BI Data Analyst

Job description

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 an ASP.NET 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 the 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.
• 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# ASP.NET 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.
• 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.

Qualifications

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 – £54,267 to £58,461 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.

You will be notified if your application has been successful. Interview date to be confirmed .

Should you require any help or advice with your online application, please contact the Recruitment Helpdesk on 01708 432770

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 x2 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.

About Us

With its excellent transport links into central London, extensive town centre regeneration and the highest concentration of green space anywhere in London, Havering has a unique offer as a place to live, work and visit. By making the most of its position and opportunities, Havering is becoming a hub for start-ups and expanding businesses, as well as construction, logistics, engineering and manufacturing industries.

Find out why you should work for Havering Council .

• Locations TOWN HALL, ROMFORD, RM1 3BD, GB