Analytical Assistant

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, score cards 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 an 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 fixed-term basis with the option of flexibility on working hours. Your supporting statement is your opportunity to demonstrate your suitability to the position you are applying for, so please indicate how your skills, knowledge, and experience align with the job description and person specification. Please include any relevant examples of analysing complex or multiple datasets, the steps you took to ensure quality, and the tools or software you used and what you achieved. We acknowledge that AI can be a useful tool to support your writing, however, please note that your application should represent your skills and personal experiences accurately and authentically., This is an exciting role supporting the council and partners through the collection and provision of data, insight, and analysis. You will be responsible for:

• 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, 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.
  
  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. 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.

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.

We value our colleagues in Cambridgeshire County Council and have developed a number of benefits in addition to the basics like annual leave, sick pay, pension and mileage…
• 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