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 Technical Analyst and undertake the ETL (extraction, transformation and load) process for the data that is used for the wider team. All roles are offered on an up-to full-time basis, and part time applicants 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.
The successful applicants can expect to develop their knowledge and expertise further and will be given any necessary support and mentoring in the role. This could include the opportunity to complete a level 4 Data Analyst Apprenticeship with our current provider Estio.
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.
For further information about the role, please see the Job Specification attached at the bottom of this advert. Please also take time to read the attached Personal Statement Guidance as applications are assessed against the Person Specification based on the information given.
If you have any questions or would like to arrange an informal chat about this opportunity please contact Sally Purcell (sally.purcell@cambridgeshire.gov.uk) or Debbie Ablett (debbie.ablett@cambridgeshire.gov.uk).
Please note: The application period for this role closes on Friday 1st September 2023. We expect interviews to take place on the week commencing 18th September 2023.
Shortlisted candidates will be expected to complete a coding or presentation exercise, the details of which will be shared a week in advance of the interview date.
What will you be doing?
Working as part of a team led by a Senior Analyst, this role supports a variety of the Council’s services and functions through the extraction, transformation and provision of data.
Key duties include:
- Writing ETL (extract, transform, load) scripts and code in order to provide and support large, complex datasets to allow users to analyse data across multiple systems
- Implement data flows to connect operational systems, data for analytics and business intelligence systems
- Reporting for system migration projects
- Building accessible data for analysis
- Assisting in the data requirements of a project
- Working with key stakeholders in the Council to determine their requirements, design and build effective data solutions and reports to meet their needs
About you
This role would suit someone with knowledge and experience of data transformation and analysis as well as working with customers to design and deliver data needs. 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 coding software (for example SQL, Python, etc).
The P&I team come from a variety of study and work-based backgrounds such as geography, politics, philosophy, maths, social care and IT 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 working with data and coding.
Our Technical Analysts are expected to be proficient in extracting, transforming and packaging data tools. They will have 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 below for full details.
Our benefits
We value our colleagues in Cambridgeshire County Council and have developed a number of benefits:
- Opportunities for learning and development including an optional level 4+ data analyst apprenticeship scheme
- 25 days annual leave plus bank holidays (pro-rated if part-time)
- Flexible working
- Flexible Bank Holidays
- Hybrid working - working from home, our main office in Papworth and occasionally other Council and partner office locations
- 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 believe benefits our employees, the organisation and our communities.
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.
Attached documents
The following content displays a map of the job's location.
