Lead Data Engineer – Data Warehouse

Havering
Romford
23 hours 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 SQL Not-for-profit

Lead Data Engineer SQL Python...

Vice President, Lead Data Engineer

Data Engineer - Junior

Tech Lead - Data Engineering

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.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

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

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.