About Us

 Richmond and Wandsworth Councils are looking for a Data Analyst to work across both Councils as we develop our digital strategy.  We are currently rolling out traffic, air quality and other sensors on the highway network to provide comprehensive data coverage across the boroughs.  We are using increasingly powerful sensors and technology to provide comprehensive data sets and we need to be able to use this data innovatively to inform future decisions on where to allocate resources to achieve maximum effect, taking into account our active travel, cycling and air quality plans and objectives.  

This role is an excellent opportunity for a collaborative problem solver who wants to make an immediate impact in a large organisation that serves diverse communities with varied needs. Using internal, external sources and public data, you will have the opportunity to be involved in a wide range of analytical and strategic projects, with significant organisational and social impact.

The postholder will be working closely and supporting the work of managers across both boroughs traffic and engineering teams extracting, cleaning, and summarising highway asset management, traffic and parking data. 

The postholder will also write reports, maintaining, and updating analytical products and responding to requests for data and information. The postholder will work closely with officers in the teams and across the council to support the delivery of the highways and transport work plan and contribute towards advancing data and analytics across the SSA. 

The Role 

You will be joining the Traffic and Engineering Team which manages the highway infrastructure across both London boroughs. 

Your work will enable Richmond and Wandsworth Councils to make informed decisions and implement transformative and innovative ways of working by providing insightful analyses and innovative data solutions to deliver high-quality transport and public realm services for residents. The data produced will also inform the design process for future public realm projects.

Your role 

• Demonstrate curiosity and apply an analytical mindset when approaching analytical problems. 
• Provide analytics support towards products such as annual reports, needs assessments, strategic assessments, service reviews etc. 
• Demonstrate an eagerness to learn and develop.
• Extract, collate, summarise data and develop dashboards and reports that are timely and accurate.
• Clean, manipulate and link various types of data. 
• Summarise and present data and conclusions in the most appropriate format for users.

Your skills 

• Good communications skills, both written and verbal, and be able to maintain effective working relationships across the council and with partner organisations.
• Highly numerate with skills in the analysis, reporting and interpretation of data analyses.
• Ability to clean, analyse, summarise, and manage data.
• Advance MS Excel Skills and proficient in PowerBI 
• Able to query using SQL (desirable) 
• Conduct analysis using R or Python (desirable)
• Eager to learn, curious and motivated to develop new skills. 

Current Post

Current role is a fixed term post for 1 year, although this may be extended.

There will be a short test at the interview. You will be expected to use Power Bi Dashboard and present the findings to the interview panel. 

We offer

• Working arrangements that will enhance your work-life balance.
• A very positive and supportive environment where creativity and hard work are supported and appreciated.
• A supportive management team and peer group that is keen to teach and learn from the position holder.
• 32 days of annual leave plus bank holidays.

In addition, we offer a range of staff benefits such as Performance Related Pay, membership of the Local Government contributory pension scheme, childcare vouchers, new technology scheme, interest-free loans on annual travel cards, discounts at many leisure activities, restaurants, shops and other establishments. A wide range of developmental opportunities are also offered.

We recognise the importance of a good balance between work and home life so we do everything we can to accommodate flexible working including, working from home, compressed or part-time hours, term time only, job shares and other arrangements. Please just let us know in your application or at any stage throughout the process (and beyond) if these are options you’d like to explore.

Indicative Recruitment Timeline

Closing Date:  23rd July 2023

Shortlisting: 24^th July 2023

Interview Date: 1^st August 2023 

Useful Information:

The closing date is given as a guide. We reserve the right to close this vacancy once a sufficient number of applications has been received. We strongly advise you to complete your application as soon as possible to avoid disappointment.

Richmond and Wandsworth Councils are committed to making our recruitment practices as inclusive as possible for everyone. We are committed to promoting equality and diversity and developing a culture that values differences, recognising that employees from a variety of backgrounds bring important and positive contributions to the Councils and can improve the way we deliver services. 

We are proud to be a Disability Confident employer.

This recruitment will be anonymised. 

Richmond and Wandsworth Councils