Lead Data Engineer – Data Warehouse

Havering
Romford
4 days ago
Create job alert

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

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


#J-18808-Ljbffr

Related Jobs

View all jobs

Lead Data Engineer: Data Warehouse & Azure Modernisation

Lead Data Engineer

Lead Data Engineer

Lead Data Engineer Technology (Product, Engineering, Design) · London ·

Lead Data Engineer

Lead Data Engineer DBT

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Machine Learning Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Are you considering a career change into machine learning in your 30s, 40s or 50s? You’re not alone. In the UK, organisations across industries such as finance, healthcare, retail, government & technology are investing in machine learning to improve decisions, automate processes & unlock new insights. But with all the hype, it can be hard to tell which roles are real job opportunities and which are just buzzwords. This article gives you a practical, UK-focused reality check: which machine learning roles truly exist, what skills employers really hire for, how long retraining realistically takes, how to position your experience and whether age matters in your favour or not. Whether you come from analytics, engineering, operations, research, compliance or business strategy, there is a credible route into machine learning if you approach it strategically.

How to Write a Machine Learning Job Ad That Attracts the Right People

Machine learning now sits at the heart of many UK organisations, powering everything from recommendation engines and fraud detection to forecasting, automation and decision support. As adoption grows, so does demand for skilled machine learning professionals. Yet many employers struggle to attract the right candidates. Machine learning job adverts often generate high volumes of applications, but few applicants have the blend of modelling skill, engineering awareness and real-world experience the role actually requires. Meanwhile, strong machine learning engineers and scientists quietly avoid adverts that feel vague, inflated or confused. In most cases, the issue is not the talent market — it is the job advert itself. Machine learning professionals are analytical, technically rigorous and highly selective. A poorly written job ad signals unclear expectations and low ML maturity. A well-written one signals credibility, focus and a serious approach to applied machine learning. This guide explains how to write a machine learning job ad that attracts the right people, improves applicant quality and strengthens your employer brand.

Maths for Machine Learning Jobs: The Only Topics You Actually Need (& How to Learn Them)

Machine learning job adverts in the UK love vague phrases like “strong maths” or “solid fundamentals”. That can make the whole field feel gatekept especially if you are a career changer or a student who has not touched maths since A level. Here is the practical truth. For most roles on MachineLearningJobs.co.uk such as Machine Learning Engineer, Applied Scientist, Data Scientist, NLP Engineer, Computer Vision Engineer or MLOps Engineer with modelling responsibilities the maths you actually use is concentrated in four areas: Linear algebra essentials (vectors, matrices, projections, PCA intuition) Probability & statistics (uncertainty, metrics, sampling, base rates) Calculus essentials (derivatives, chain rule, gradients, backprop intuition) Basic optimisation (loss functions, gradient descent, regularisation, tuning) If you can do those four things well you can build models, debug training, evaluate properly, explain trade-offs & sound credible in interviews. This guide gives you a clear scope plus a six-week learning plan, portfolio projects & resources so you can learn with momentum rather than drowning in theory.