Lead Data Engineer – Data Warehouse

Havering
Romford
1 month ago
Applications closed

Related Jobs

View all jobs

Lead Data Engineer (Snowflake)

Lead Data Engineer

Lead Data Engineer (Snowflake)

Lead Data Engineer

Lead Data Engineer

Lead Data Engineer

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

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.

Careers

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

Jobs

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

Education

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.