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. It requires knowledge of traditional and modern data engineering skills. Depending on experience, you may also help shape best practices within the team and support or mentor junior team members. This is a full‑time, permanent position working 37 hours per week Monday to Friday, with hybrid working flexibility (office, City Hall or remote), but at least two days in a non‑home location. The role is career graded (LG Band 07 – LG Band 08). The level will depend on the selection process and the candidate’s experience.
Responsibilities
* Design, build, and maintain robust and efficient ETL pipelines.
* Implement and manage Data Lakehouse and data warehouse solutions.
* Design and develop dimensional (star schema) reporting models.
* Collaborate with analysts, data scientists, and business stakeholders to define data requirements.
* Contribute to improving data engineering standards and ways of working.
* Support and, where appropriate, mentor junior team members.
Qualifications
* 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.
Benefits
We offer generous annual leave, membership of the Local Government Pension Scheme, and flexible working options. Additionally, you can develop your skills and expertise through a variety of training and development opportunities, and receive flexible benefits such as discounts on city buses and trains. We understand that candidates may not meet every requirement, but if you have a strong foundation in BI and data and wish to develop further, we would still like to hear from you.
#J-18808-Ljbffr