At a Glance
- Tasks: Design and build scalable data solutions for a modern cloud-based analytics platform.
- Company: Leicester City Council, committed to diversity and innovation.
- Benefits: Generous leave, flexible working, and training opportunities.
- Other info: Hybrid working with great career growth potential.
- Why this job: Join a transformative project and make a real impact in data engineering.
- Qualifications: Experience with T-SQL, ETL pipelines, and data warehousing concepts.
The predicted salary is between 35412 - 41771 £ per year.
Full Time / 37 Hours Per Week / Permanent. Leicester City Council is expanding its data and analytics capability and is 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. The foundation supports self‑service reporting, advanced analytics, and data science.
As a key member of the data team, you will design, build, and maintain reliable and scalable data solutions. You will work closely with business stakeholders, analysts, and engineers to understand requirements and deliver high‑quality data products. The role involves both modern cloud‑based solutions and existing on‑premises systems, requiring knowledge of traditional and modern data engineering skills. Depending on experience, you may help shape best practices and mentor junior team members.
The position is full‑time, permanent, 37 hours per week, Monday to Friday, with hybrid working – office or remote – but requires at least 2 days in a non‑home location. This is a career graded post (LG Band 07 – LG Band 08) with promotion potential based on performance.
What You’ll Be Doing
- Your day‑to‑day activities will include designing, building, and maintaining robust and efficient ETL pipelines;
- implementing and managing a Lakehouse and data warehouse solution;
- and creating dimensional (star schema) reporting models.
You will collaborate with analysts, data scientists, and stakeholders to define data requirements, improve data engineering standards, and mentor junior team members where appropriate.
What You’ll Need
- 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 and 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. 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
You will enjoy a work environment that encourages a healthy work/life balance, generous annual leave, membership of the Local Government Pension Scheme, and the option of flexible working. There are opportunities to develop your skills via training and development programmes, and you can choose from flexible benefits such as discounts on city buses and trains.
Join us. We’re committed to recruiting a diverse and highly talented workforce to build a council that reflects Leicester’s great city. We aim to make the recruitment process fair and welcoming.
For an informal chat about this role, please contact David Ku at david.ku@leicester.gov.uk.
Interviews will take place on Tuesday 16th and Wednesday 17th June 2026.
Region: Central Location: Hybrid working – home and Leicester City Offices Salary: GBP 35,412 – GBP 41,771 per year Package: Total benefit value (includes pension contribution and full holiday entitlement): GBP 52,115 Contractual hours: 37 Basis: Full time
Senior Data Engineer in Leicester employer: Leicester Bus Partnership
Leicester City Council is an excellent employer, offering a supportive work environment that prioritises work/life balance and professional development. With flexible working options, generous annual leave, and a commitment to diversity, employees can thrive while contributing to meaningful projects that enhance the city's data capabilities. The opportunity for career progression and mentorship within a collaborative team makes this role particularly rewarding for those looking to grow in the field of data engineering.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer in Leicester
✨Tip Number 1
Network like a pro! Reach out to people in your industry on LinkedIn or at local meetups. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data engineering projects. Whether it’s a GitHub repo or a personal website, let your work speak for itself.
✨Tip Number 3
Prepare for the interview! Research Leicester City Council and think about how your experience aligns with their goals. Be ready to discuss how you can contribute to their data transformation journey.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, we love hearing from passionate candidates who are eager to join our team.
We think you need these skills to ace Senior Data Engineer in Leicester
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior Data Engineer role. Highlight your experience with T-SQL, ETL pipelines, and any cloud-based solutions you've worked on. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our team. Don't forget to mention any relevant projects or experiences that showcase your abilities.
Show Off Your Problem-Solving Skills:In your application, give examples of how you've tackled complex data challenges in the past. We love candidates who can think critically and come up with innovative solutions, so let us know how you've done this before!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved!
How to prepare for a job interview at Leicester Bus Partnership
✨Know Your Data Engineering Stuff
Make sure you brush up on your T-SQL, ETL pipelines, and data warehousing concepts. Be ready to discuss your experience with tools like SSIS or Azure Data Factory, and how you've implemented them in past projects.
✨Show Off Your Collaboration Skills
This role involves working closely with analysts and stakeholders, so be prepared to share examples of how you've successfully collaborated in the past. Highlight your communication skills and how you’ve managed to bridge the gap between technical and non-technical team members.
✨Prepare for Technical Questions
Expect some technical questions during the interview. Brush up on Python/PySpark and C#, and be ready to solve a problem or two on the spot. Practising coding challenges can help you feel more confident.
✨Ask Insightful Questions
At the end of the interview, don’t forget to ask questions! Inquire about the team's current projects, the transition to cloud-based solutions, or how they measure success in this role. It shows your interest and helps you gauge if it’s the right fit for you.
