Data Analyst

Kingston upon Thames London Borough Council; Greater London; Hybrid; GBP 38,000 - 47,000; Full time

Benefits offered by this job

Hybrid Working

Job summary

Kingston Council is seeking a Data Analyst to own the highways and transport data strategy, analyze and visualise transport data to influence service delivery across Kingston and Sutton.

The role requires SQL and Python to build automated dashboards, index digital assets, and present clear reports to varied audiences while collaborating with external bodies like TfL to maximise data opportunities.

Qualifications

• Proven ability to turn raw data into actionable insights.
• Experience with analytical tools and reporting.
• Ability to learn quickly and manage multiple priorities.

Responsibilities

• Own the Highways & Transport Data Strategy and map digital assets.
• Use SQL and Python to extract, clean and automate dashboards.
• Create clear, visual reports for diverse audiences.
• Upskill project managers to build analytical capacity.
• Collaborate with external bodies like TfL to maximise data opportunities.

Skills

SQL

Python

GIS mapping

Data analysis

Dashboards

Job description

Data Analyst

Employer

Kingston Council

Location(s)

Kingston, Sutton

Workplace Type

Hybrid Working

Contract Type

Fixed Term

Length of Employment / Contract End Date

2 years

Working Hours

Full Time

Grade

G/H

Hours Per Week

36

Salary Range

£38,256 - £46,968

Salary Basis

Per annum

Leave Entitlement

27/30 days

Application Deadline

18/09/2026, 23:55

About the Borough

Joining us, you get to work for not just one high performing London Borough, but two.

Kingston and Sutton councils have a number of shared services serving both authorities, with some teams and roles more focussed on one council than the other, but the majority are shared across both, meaning you get multiple opportunities to learn from a wider pool of activities and two different political bodies.

We work flexibly in both Kingston and Sutton offices, and support working at home or flexible working patterns that enable you to tailor your working and personal life. We provide the equipment and tools to enable you to work flexibly, and in return ask you to use that flexibility to be creative and ambitious in the services we deliver.

There are some really exciting things happening in both boroughs. In Sutton, we are developing the London Cancer Hub, a world leading cancer research and treatment hub that will bring together professionals from across different sectors to identify and test new treatments and therapies. Over in Kingston, we are undertaking the largest housing regeneration programme ever delivered in the borough, building new energy efficient housing that will transform some of our oldest Council owned housing. Both boroughs have publicly committed to doing what they can to tackle the climate emergency and are investing in new technologies and societal change that will help bring carbon emissions down and improve our climate impact.

You should choose Kingston and Sutton if you are looking for an opportunity that will challenge you to deliver more, support you to achieve personal ambitions, and expect you to put borough residents at the heart of what you do.

Kingston is a beautiful Royal borough with a historic setting on the banks of the Thames with excellent schools and a bustling retail centre, all surrounded by open green spaces such as Richmond Park and Bushy Park, former recreation grounds for Tudor Kings and Queens. The Council is controlled by a Liberal Democrat Administration and has a council plan "Greener, Fairer, Safer, Together", that sets out a vision to be a vibrant, diverse and inclusive borough where residents are active, empowered, engaged and able to remain independent and resilient. The Council engages with residents through a number of forums and events through the year, and like Sutton plays a leading role in developing the South West Region of London.

Sutton is a well connected attractive part of London that has a reputation for excellent schools, green and leafy open spaces, and a history that drives a thriving heritage and culture offer through our museums and libraries. The Council is controlled by a long established Liberal Democrat Administration and has high ambitions set out in its corporate plan "Ambitious for Sutton", that will ensure Sutton remains a great place to live, work and raise a family. The Council plays a leading role in a number of local partnerships and places great emphasis on engaging effectively with its residents, listening to local voices and making their message heard across London Government.

About the Role and our Ideal Candidate

In this role, you won't just manage datasets; you will own and deliver the Highways and Transport Data Strategy. Your mission will be to manage, analyse, and visualise transport and highways data to directly shape service delivery, inform strategy, and guide key decision-making across a variety of projects and programmes within both boroughs.

What the successful candidate will be expected to do:

• Own the Highways & Transport Data Strategy by indexing all digital data assets and maintaining accurate GIS mapping layers.
• Use SQL and Python to extract and clean large backend datasets, replacing manual extraction with automated dashboards.
• Turn dense transport data and traffic surveys into clear, highly visual reports for a variety of audiences.
• Upskill internal project managers to build analytical capacity, as well as collaborating with external bodies like Transport for London (TfL) to maximise data opportunities.
• Work directly with Highways and Transport project managers to unpack their problems, gather data requirements, and independently run analytical projects from start to finish.

About You

Are you passionate about turning raw data into powerful, strategic insights? Do you want to play a key role in shaping the future of transport across two vibrant London boroughs?

We are seeking a proactive and highly analytical individual who is a quick learner and able to manage multiple priorities in a busy and varied work environment. You are able to explain complex analysis to various audiences to ensure data insights are understood. And are skilled in working with colleagues to understand the problem they are trying to solve and what sources, analysis or data products can help them achieve their goals.

If you're someone who loves to help colleagues build their own analytical skills, or if you enjoy building partnerships with organisations like Transport for London (TfL), you'll fit right in. You're comfortable with ambiguity, happy to take the lead on new projects, and ready to champion a culture of evidence-based thinking.

About Us

We are seeking a Data Analyst to join our Highways and Transport Programme and Support Team. Operating as a shared service across the Royal Borough of Kingston and the London Borough of Sutton, our team is central to delivering and supporting critical highways services. With the support of the central Council data team, you will act as our lead departmental analyst, driving our transition from being a data-rich service to an information-led service.

Our Offer To You

As an organisation that values and nurtures talent, we're committed to helping you fulfil your potential and will offer you a supportive, friendly and collaborative environment to grow and develop your career and skills. We're constantly striving to improve our ways of working so putting your ideas across however big or small; will be fully encouraged and supported by your colleagues and our dynamic and experienced management team.

Employees have access to a wide range of benefits to enable staff to achieve a work life balance, some of which include:

• A generous annual leave entitlement of 25-32 days, plus bank holidays (pro-rata if part-time working hours apply) depending on service and grade.
• Enhanced Maternity, Paternity, shared parental, adoption and dependents leave
• Three volunteering days per year in Kingston
• Hybrid working (dependent on the role)
• Flexible and agile working arrangements using Google Chromebooks
• Learning and development portal offering a range of courses
• Discounts on a range of local shops, restaurants, gyms and leisure centres
• Interest free season ticket loans
• Local Government Pension Scheme
• Bicycle loan facilities and cycle to work scheme
• Electric vehicle leasing scheme
• Confidential health & wellbeing and counselling support

Additional Information

We are proud to be a diverse and welcoming Borough and we strive to create a workforce which reflects the community we serve, and instil a sense of belonging in our staff. We celebrate and respect differences and appreciate the value of having a diverse workforce, therefore we welcome applications from under represented groups.

To support our workers and their families we offer a range of family friendly, inclusive employment policies, flexible working arrangements, staff engagement forums and inclusive staff networks who help drive our diversity agenda.

We are also proud to be a disability confident employer and guarantee to interview all disabled applicants who meet the minimum essential criteria for a role. As an accredited London Living Wage Employer all our employees are guaranteed the London Living Wage regardless of their length or type of contract.

The UK has a points-based immigration system affecting EU and Non-EU workers and sponsorship requirements. We advise checking the for right to work guidance. Sponsorship availability varies and is subject to eligibility requirements and budget limitations. As a result, we cannot guarantee sponsorship for all roles and will evaluate sponsorship requests on a case-by-case basis.