Senior Data Engineer

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Full Time / 37 Hours Per Week / Permanent

Leicester City Council is expanding its data and analytics capability. As part of this journey, we are transitioning from a predominantly on-premises data estate to a modern, cloud-based SaaS analytics platform.

This transformation involves significant data engineering work to establish a strong, clean, trusted, and reliable data layer. This important foundation will underpin a wide range of analytical use cases, including self-service reporting, advanced analytics, and data science.

As a key member of the data team, you'll play a pivotal role in designing, building, and maintaining reliable and scalable data solutions. You will work closely with business stakeholders, analysts, and other engineers to understand requirements and deliver high-quality data products.

Given the hybrid nature of our environment, the role will involve both developing modern cloud-based solutions and supporting existing on-premises systems. As such, a knowledge of traditional and modern data engineering skills is important.

Depending on experience, you may also help shape best practices among the team, in addition to supporting and mentoring more junior team members.

This is a full time, permanent position working 37 hours per week Monday to Friday. You'll have flexibility in hybrid working being both office based, at City Hall or working remotely from home to suit your needs. However, under our new ways of working policy you'll be required to work in a non-home location a minimum of 2 days.

This is a career graded post (LG Band 07 - LG Band 08). Appointment to a level will depend on the outcome of the selection process and experience of the successful candidate. Dependent on availability of work/vacancy at a higher level, progress will be by satisfactory performance, agreed at annual Appraisals and through on-going supervision.

What you'll be doing

Not one day will be the same in this varied role. Your day-to-day activities will range from designing, building, and maintaining robust and efficient ETL pipelines to implementing and managing date Lakehouse and data warehouse solutions. In addition, you'll be responsible for designing and developing dimensional (star schema) reporting models.

Within this role, you'll collaborate with analysts, data scientists, and business stakeholders to define data requirements. You'll contribute to improving data engineering standards and ways of working. Whilst also supporting and, where appropriate, mentoring junior team members.

What you'll need

As the ideal candidate you'll have:

• Strong experience with T-SQL and Microsoft SQL Server
• Experience building and maintaining ETL pipelines (e.g., SSIS, Azure Data Factory, or similar tools)
• Working knowledge of Python/PySpark and C#
• Solid understanding of data warehousing concepts (Kimball), including dimensional modelling and star schemas
• Good communication skills, with the ability to work effectively in a team and with both technical and non-technical stakeholders
• Good attention to detail, strong analytical and problem-solving abilities

We understand that candidates may not meet every requirement. However, if you have a strong foundation in BI and data and are keen to develop further, we would still like to hear from you.

What we can offer you

As well as the satisfaction of helping to improve thousands of lives across Leicester, you can look forward to a work environment that encourages a healthy work/life balance. You'll enjoy generous annual leave, membership of the Local Government Pension Scheme and the option of flexible working. We'll also give you the chance to develop your skills and expertise with a variety of training and development opportunities. In addition, you can choose from a number of flexible benefits, including discounts on city buses and trains. For an illustrative value of your benefits package, take a look at our benefits calculator.

Join us

We're committed to recruiting a diverse and highly-talented workforce as we continue to build a council that is fitting and representative of our great city. That's why we've designed our recruitment process to put you at your ease, make you feel welcome and bring the best out of you. We'll do all we can to make our recruitment process as fair as possible. To help you with your application, take a look at the 'our approach to recruitment' page.

For an informal chat about this role, please contact David Ku at david.ku@leicester.gov.uk

Interviews will take place on Thursday 9th and Friday 10th April 2026.