Skip to content

Insight Analyst

Please Note: The application deadline for this job has now passed.

About the role

The Policy & Insight Team are looking to recruit two Insight Analysts to assist with providing data, analysis and insight to the wider County Council and partners. There are two roles available. 1 X Insight Analyst (Research) which will primarily focus on be crime and community safety, communities, poverty and inequalities. And 1 X Insight Analyst (Intelligence, this second role will focus on Adult Social Care. Please find the different job descriptions attached. It would be beneficial to have experience in one of these subject areas but subject matter training can be provided so this is not essential.

This work will support the operational management and strategic planning of services.  

The demand for our services has never been greater!  With budgets of millions of pounds that impact on thousands of vulnerable people every year, services rely upon the analysis, information and advice provided by our team to make informed decisions – so you’ll really have a chance to make a difference. 

All roles are offered on an up-to full-time basis, and part time applicants would be considered.  

The Policy and Insight Team are a hybrid working team - i.e. employees split their working time between home and a County Council office – our team’s main office is in Papworth Everard. Successful candidates should expect to work from an office at least 1 day per week – this could be in any of our Cambridgeshire County Council offices and can be combined with our monthly team meeting that takes place in Papworth Everard.  

Whilst the majority of our IT support can be delivered remotely, our IT team are based at New Shire Hall in Alconbury and individuals are expected to be able to attend in person when required. 

 The successful applicants can expect to develop their knowledge and expertise further and complete complex analysis using Excel, Power BI, GIS software and other data manipulation tools. This could include the opportunity to complete a level 4 Data Analyst Apprenticeship.

The Policy & Insights Team work across a variety of subject areas, supporting Cambridgeshire County Council and partners in the wider public sector to make well evidenced decisions. Please be aware that due to the nature of the data we handle, this role will require a basic DBS check. In addition the Insight Analyst (Research) role will require an enhanced Police vetting check once in the role.

For further information about the role, please see the attached job specifications.  

If you have any questions or would like to arrange an informal chat, please contact Jack Ossel (

Please note: The application period for this role closes on Sunday March 31st 2024. We expect interviews to take place on the week commencing 15th April 2024.  

Shortlisted candidates will be expected to complete a data analysis and presentation exercise as part of the interview, the details of which will be shared a week in advance of the interview date.   

Your application will be shortlisted against the essential and desirable criteria in the attached job description and person specification. Please ensure that you read this document carefully and provide us with a personal statement that demonstrates your skills experience and attitude.  

Whilst Cambridgeshire County Council’s Recruitment Hub will ask you to outline your employment history; the personal statement is the primary evidence that we will use in determining whether to invite a candidate to interview. Attached to this advert is some guidance around the expectations for this statement.  

What will you be doing?

As an Analyst you will work under the guidance of a Senior Analyst to provide data, insight and analysis to the wider County Council and its partners. Your role will include:

  • Extracting, transforming and quality assuring data.
  • Utilising PowerBI to create dashboards which support service management.
  • Developing in-depth knowledge of the services you support, their policies and practice as well as the underlying Management Information systems that they use.
  • Supporting and liaising with local partnerships and stakeholders
  • Supporting senior analysts by conducting analysis, producing outputs, presenting findings and report writing where necessary.
  • Responding to regular and ad-hoc data requirements, including committee reporting, Freedom of Information requests, and data requests from service leaders.
  • Using varied analytical tools to support policy and wider decision-making, including demand management and resource allocation.

About you

This role would suit someone with knowledge and experience of data transformation and analysis. This knowledge could have been gained through employment or study. You should be prepared to provide examples of scenarios when you have worked with a dataset(s) and with analysis software (for example Excel, PowerBI or GIS).

The P&I team come from a variety of study and work-based backgrounds such as geography, politics, philosophy, anthropology, maths and engineering but we all tend to be numerate, problem-solving individuals. Training and development opportunities will be provided and we encourage applications from anyone that meets the essential criteria and is passionate about drawing meaning from data.

Our Insight Analysts are expected to be technically proficient in data analysis and the use of analytical tools. They will have some experience in research or other analytical roles combined with excellent IT, time management and communication skills. Being well organised with good attention to detail and the ability to consistently produce high quality work is also key. You should also be able to demonstrate awareness and understanding of equality, diversity and inclusion (EDI).

Please see the attached job specification for full details.

Our benefits

We value our colleagues in Cambridgeshire County Council and have developed a number of benefits:

  • Flexible working
  • Flexible Bank Holidays
  • A comprehensive wellbeing package
  • Our Cambs Rewards employee discounts
  • A comprehensive pension scheme
  • IDEAL staff equality, diversity and inclusion network.
  • Camweb our staff intranet helping to keep you informed
  • An employee recognition scheme

About us

Cambridgeshire is a great place to work and live with a diverse population, an urban centre in Cambridge, historic Isle of Ely, Huntingdon and St Ives as well as more rural landscapes.

Our four values are central to our culture, driving everything we do.

We are proud to serve the diverse communities of Cambridgeshire and want our workforce to be reflective of this diversity, which we firmly believe benefits our colleagues, the organisation and our communities. If you don’t meet every single requirement in the job role but think this could be you, please don’t be put off.   We are committed to building a workplace that is compassionate and inclusive as well as diverse, so if you think you could be a good candidate for this role please consider applying and speak to the recruiting manager if you have any questions.

Our Equality, Diversity and Inclusion Strategy, along with our employee network 'IDEAL' and self-organised peer support groups help us to foster an inclusive, supportive and safe working environment where people feel valued, respected, and empowered.  We collect relevant diversity data for monitoring as part of the recruitment process to understand the diversity of our applicants and monitor any trends throughout the recruitment processes so that we can take meaningful action.

We are proud to be a Disability Confident Employer. We fully support providing reasonable adjustments throughout our recruitment process, as well as when you join us, and we encourage candidates to contact the Hiring Manager, whose details can be found in the advert, to discuss any adjustment needs. Some examples of adjustments could include additional time to complete an assessment or printing a document on pastel coloured paper with larger font size and line spacing. We would value talking about what might be possible to enable you to join us and thrive, so if there is something that would help you to do your best during your journey with us, please get in touch.

Visit our jobs and careers section to find out more about our wide range of learning and development opportunities; apprenticeships; our wellbeing package; staff benefits; our commitment to equality, diversity and Inclusion.

This website is using cookies to improve your browsing experience. If you navigate to another page without changing the settings below you consent to this. Read more about cookies.

Disability confident committed Proudly partnering with Diversity Jobs Group Armed Forces Covenant. Proudly supporting those who serve. Happy to talk flexible working