Skip to content

Junior Analyst

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

About the role

Cambridgeshire County Council’s Policy & Insight Team provides data, analysis insight and policy expertise to 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. 

The Policy & Insight Team are looking to recruit a new Junior Insight Analyst to assist with providing data, analysis and insight to the wider County Council and partners for a fixed term period of 12 months. The role is offered on an up-to full-time basis, and part time applications would be considered. We are a hybrid working team, working flexibly from home, our main office in Papworth and Council offices located around the county.  Our technology platform supports remote working and flexible working patterns. 

Our Junior 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. 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 with our current provider Estio

We encourage our analysts to work across a variety of subject areas, supporting Cambridgeshire County Council and partners in the wider public sector to make well evidenced decisions. The role currently being offered will predominantly focus on drawing insights from adult education data working to support the Cambridgeshire and Peterborough Combined Authority and the wider skills and economy portfolio. 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. Please be aware that due to the nature of the data we handle, this role will require a basic DBS check. 

For further information about the role, please see the attached job description. If you have any questions or would like to arrange an informal chat, please contact Rob Kemp (  

Please note: The application period for this role closes at midnight on Sunday 10th March 2024.  

Shortlisted candidates will be invited to complete an Excel assessment task on Thursday 21st March 2023 which will test basic data management and analysis skills. Candidates will require access to spreadsheet software such as Microsoft Excel, Google Sheets or Numbers. The assessment will take place online via Microsoft Teams.

Successful candidates will then be invited to an in person interview, taking place on Wednesday 28th March 2024. We can provide an online interview on a different date in certain circumstances. The interview will include a short presentation task to allow candidates to demonstrate their ability to explain their approach to and conclusions from a small piece of data analysis. Instructions for the data analysis and presentation task will be provided to candidates following the Excel assessment. 

What will you be doing?

As a Junior Analyst you will work under the guidance of Analysts and Senior Analysts to: 

  • provide data, insight and analysis to the wider County Council and its partners.  

  • work on projects to enter, clean, reformat and interpret data, analysing what it is saying and being able to think strategically about how the Council can use it.  

  • work with elected members, colleagues and partners to support high-quality, evidence-led planning, decision-making and performance improvement. 

Please see the attached 'Day in the life of the Policy & Insight Team' document which outlines what a day working in the P&I team might look like. 

About you

This role would suit someone with knowledge of data collection 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. 


As a minimum you will have 5 GCSEs or equivalent including English and Maths and ideally a higher education qualification (level 4 or above). You will be fully proficient using Microsoft Windows and Office packages and have a high standard of numeracy, literacy 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 description for full details.

Our benefits

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

  • 25 days annual leave plus bank holidays (pro-rated if part-time) 

  • Flexible working hours 

  • Flexible Bank Holidays 

  • Hybrid working - working from home, our main office in Papworth and occasionally other Council and partner office locations

  • Opportunities for learning and development including an optional level 4+ data analyst apprenticeship scheme

  • A comprehensive wellbeing package 

  • Our Cambs Rewards employee discounts 

  • Access to the Local Government Pension Scheme (LGPS). 

  • IDEAL staff equality, diversity and inclusion network 

  • 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