Analytical Assistant

Analytical Assistant

Full-Time 30000 - 40000 £ / year (est.) No home office possible
Cambridge County Council

At a Glance

  • Tasks: Support data collection, analysis, and visualisation to improve children's services.
  • Company: Join Cambridgeshire County Council's dynamic Policy, Performance & Intelligence Service.
  • Benefits: Enjoy flexible working, additional leave options, and a comprehensive wellbeing package.
  • Other info: Inclusive workplace with opportunities for personal and professional growth.
  • Why this job: Make a real difference in your community through impactful data-driven decisions.
  • Qualifications: Strong technical skills in data analysis and good communication abilities.

The predicted salary is between 30000 - 40000 £ per year.

We are looking to recruit to an expanding team to help the Council harness the potential of data, using evidence and best practice to support and inform the development of policy, strategy, plans and budgets, and in turn deliver the Corporate Strategy for Cambridgeshire County Council. The post holder will support with a range of data and analytical tasks that support the Council's education and children's social care functions plan and deliver good quality services.

The post holder will lead on primary data collection and extraction, data handling, data analysis and visualisation, supporting team and service colleagues make the best use of our data. The post holder will work with a large volume of complex data from multiple sources. As an Analytical Assistant, you will provide practical support to team colleagues working on different projects as required to enter, clean, reformat and analyse data, and be able to think strategically about how the Council can use it.

The post holder will need to be able to draft clear report work specifications, work to deadlines, produce accurate analysis and high-quality outputs, scorecards and management, performance and benchmarking information. This position offers an exciting opportunity for the post holder to develop and strengthen their analytical skills and to build a strong understanding of how education and children's services operate, as well as experience of how the Council works as a whole.

The breadth of the work will help the post holder build transferable skills, learn new ways of working, grow confidence in supporting a wider range of services, refine problem-solving and collaborative skills and support longer-term career development. 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 roles sit within Cambridgeshire County Council's newly formed Policy, Performance & Intelligence Service. A team of 50 individuals who provide data, analysis, insight and policy expertise to support the operational management and strategic planning of services. We are a family-friendly employer and will be happy to negotiate on working arrangements to achieve a good work/life balance. Both roles are available on a fixed-term basis with the option of flexibility on working hours.

What will you be doing?

  • This is an exciting role supporting the council and partners through the collection and provision of data, insight, and analysis.
  • Obtaining, extracting and analysing national and local datasets.
  • National and regional benchmarking.
  • Dashboard creation using Power BI.
  • Assisting in the provision of statutory inspection datasets.
  • Assisting in the compilation and submission of statutory data returns.
  • Assisting in the analysis to support FOI requests.
  • Ad hoc data provision and analysis for a range of teams within the Children & Families directorate.
  • Work with other experts within the team as well as colleagues from the wider service to support directorate change programmes.

About you

Can you help data make a difference? Are you ambitious, innovative, good with data and passionate with an enthusiasm for supporting evidence-led decision making? If so, we may have the role you've been searching for! We are looking for individuals with strong technical skills, with a sound understanding of a range of data sources and a hunger and curiosity to get behind the numbers and understand how they can be applied to service improvement.

Good communication skills, both oral and written, are essential as you will be given the opportunity to work closely with service leads and present complex, and sometimes technical information, to a range of internal and external audiences. Experience in a similar field is preferable. A high level of competence with Power BI, data analysis, and specialist data analytical software are also desirable. Successful applicants will be well supported to further develop their subject knowledge and technical skillsets.

Our benefits

  • A comprehensive wellbeing package to cover all aspects of wellbeing, both in and out of work, which can also be accessed by your family.
  • Buy up to 4 weeks additional annual leave (pro-rata) through our salary sacrifice scheme.
  • Take your bank holidays flexibly to better suit your personal circumstances.
  • Make Additional Voluntary Contributions (Shared AVCs) to your pension with tax and National Insurance savings.
  • Access to development opportunities, apprenticeships and qualified coaches to support your personal and professional growth.
  • Paid volunteering hours each year so you can make a positive impact on our community during your normal working day.
  • Access to Peer Support Groups through our IDEAL staff equality, diversity and inclusion network.
  • Opportunities to nominate and receive Employee Recognition Awards.
  • An Our Cambs Rewards account, giving you access to in-store and online discounts as well as our Car Lease and Cycle to Work schemes.

Equality, diversity and inclusion

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 do not meet every single requirement in the job role but think this could be you, 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 to monitor any trends throughout the recruitment processes so that we can take meaningful action. We are proud to be a Disability Confident Leader. 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.

Through a Guaranteed Interview Scheme, we will offer an interview to all applicants who disclose a disability and meet the essential criteria for a job vacancy. On your application form you can indicate you are disabled. Some examples of reasonable adjustments during the recruitment process 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.

Analytical Assistant employer: Cambridge County Council

Cambridgeshire County Council is an exceptional employer, offering a supportive and inclusive work environment that prioritises employee wellbeing and professional growth. With a strong commitment to work-life balance, flexible working arrangements, and a comprehensive benefits package, employees are empowered to thrive both personally and professionally. The role of Analytical Assistant provides a unique opportunity to make a meaningful impact on the community while developing valuable analytical skills within a collaborative team dedicated to improving services for children and families.
Cambridge County Council

Contact Detail:

Cambridge County Council Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Analytical Assistant

✨Tip Number 1

Network like a pro! Reach out to current employees at Cambridgeshire County Council on LinkedIn or other platforms. Ask them about their experiences and any tips they might have for landing the Analytical Assistant role.

✨Tip Number 2

Prepare for the interview by brushing up on your data analysis skills. Be ready to discuss how you've used data in past projects and how you can apply that to support the Council's education and children's services.

✨Tip Number 3

Show off your passion for data! During interviews, share examples of how you've used data to drive decisions or improve processes. This will demonstrate your enthusiasm for evidence-led decision making.

✨Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're serious about joining our team at Cambridgeshire County Council.

We think you need these skills to ace Analytical Assistant

Data Collection
Data Extraction
Data Handling
Data Analysis
Data Visualisation
Power BI
Statistical Analysis
Report Writing
Communication Skills
Problem-Solving Skills
Attention to Detail
Project Support
Understanding of Data Sources
Team Collaboration

Some tips for your application 🫡

Tailor Your Application: Make sure to customise your application to highlight how your skills and experiences align with the role of Analytical Assistant. Use keywords from the job description to show that you understand what we're looking for.

Showcase Your Data Skills: Since this role is all about data, don’t shy away from showcasing your technical skills. Mention any experience you have with data analysis, Power BI, or similar tools, and provide examples of how you've used these skills in past roles.

Be Clear and Concise: When drafting your application, clarity is key! Make sure your writing is straightforward and free of jargon. We want to see that you can communicate complex information effectively, just like you would in the role.

Apply Through Our Website: We encourage you to apply through our website for a smoother process. It’s the best way to ensure your application gets to us directly and allows you to keep track of your application status easily!

How to prepare for a job interview at Cambridge County Council

✨Know Your Data

Before the interview, brush up on your data analysis skills and be ready to discuss specific datasets you've worked with. Familiarise yourself with Power BI and any other analytical tools mentioned in the job description, as this will show your technical competence.

✨Understand the Council's Needs

Research Cambridgeshire County Council's current policies and strategies, especially those related to education and children's services. This will help you demonstrate how your analytical skills can directly support their goals during the interview.

✨Prepare for Scenario Questions

Expect questions that ask you to solve hypothetical problems using data. Practice articulating your thought process clearly, showing how you would approach data collection, analysis, and presentation to inform decision-making.

✨Showcase Your Communication Skills

Since you'll need to present complex information to various audiences, prepare examples of how you've effectively communicated data insights in the past. Highlight your ability to simplify technical details for non-technical stakeholders.

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>