Lead Data Engineer – Data Warehouse

Romford - UK

Yearly Salary: £ 54267 - 58461

Posted on: 14 hours ago

Vacancies: 1 Vacancy

Job Summary

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 an 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 Councils 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 Councils 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.

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.

Reporting & Salary

Reports to: Head of User-Centred Design and Digital Experience
Pay: Grade 9 54267 to 58461 per annum

Please view Job Profilehere

For an informal discussion about the post please contact @

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

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.

Required Experience:

DescriptionGrade 9 54267 to 58461 per annumLead 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 a...