Senior Data Engineer in Leicester

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 will 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 will 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 will 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 ongoing supervision.

What you will be doing

Your day-to-day activities will range from designing, building, and maintaining robust and efficient ETL pipelines to implementing and managing data Lakehouse and data warehouse solutions. In addition, you will be responsible for designing and developing dimensional (star schema) reporting models. Within this role, you will collaborate with analysts, data scientists, and business stakeholders to define data requirements. You will contribute to improving data engineering standards and ways of working, whilst also supporting and, where appropriate, mentoring junior team members.

What you will need

As the ideal candidate you will 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 will enjoy generous annual leave, membership of the Local Government Pension Scheme and the option of flexible working. We will 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.

Join us

We are 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 is why we have designed our recruitment process to put you at your ease, make you feel welcome and bring the best out of you. We will 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.