Apprentice Data Analyst

At Somerset County Council we pride ourselves on our can-do attitude and increasing innovation in the way we deliver public services for the people of Somerset. Working as an apprentice with us is a fantastic opportunity to start or progress your career within the public sector. We want to learn as much from our apprentices as they learn from us. We deliver a diverse number of services, from social care and flood protection to civil engineering and cyber security and want the best people to work with us to continue our ambitions. This is a Level 4 Apprenticeship for 18 months.

We are looking for Data Analyst to join our busy Business Intelligence Team within the Adult Social Care reporting team or the Data Engineering team. You’ll gain hands on experience of using information and data to support the delivery of Council services and improve the outcomes for local people. On the job training from our supportive team and in-person training with our educational provider will aid you in achieving a BCS Level 4 Data Analysis qualification.

Apprentices will join our Business Intelligence Team which supports the delivery of Council Services through the provision of data infrastructure, analysis, intelligence and insight. Apprentices will gain knowledge and experience of data analysis tools and techniques using a range of cloud hosted databases and reporting systems.

Regular tasks and roles would include

• Ensuring accurate collection and collation of datasets from a range of sources

• Gain an understanding of data structures, data systems and reporting tools and techniques

• Use a range of techniques to analyse and interpret data with a view of turning data into information into intelligence into insight and thus drive improve services and outcomes

• Perform database queries across multiple platforms

• Implementing best practice when designing data architecture

• Assist in the production of a range of routine and adhoc reports. These reports are required by a wide range of audiences and as such will call on the use of varying tools and techniques for data presentation and visualisation

• Gain an understanding of data quality and sharing principles
• Develop a knowledge of how large and complex organisations can use data and information to improve the way they operate and achieve better outcomes for their “clients”

A few things about you

We are looking for the following skills and personal qualities

Skills Required

• Strong communication skills both written and verbal

• Excellent organisational skills

• An aptitude for mathematics

• Good IT skills: word processing, spreadsheet, email and internet and ability to learn new software

• Excellent attention to detail and ability to work with a high level of accuracy

Personal Qualities

• The ability to learn and apply new software

• Experience or interest in learning how to write code

• The ability to work as part of a team

• High levels of personal motivation

• Able to be flexible and deal with varying tasks

Entry Requirements for the position

• GCSEs at grade C/5 or equivalent in English and Maths

• Having attained, or working towards a level 3 qualification (e.g. A levels or equivalent, Level 3 Apprenticeship, etc.)

Please ensure you list your GCSE’s on your application form.

Salary: National Minimum Wage Pay Rates for an Apprentice:

Under 18: £4.81

18-20: £6.83

21-22: £9.18

23+: £9.50

(per hour)

From 1 April 2023 the County and District councils in Somerset will be replaced by a new single unitary authority – Somerset Council. It’s a genuinely exciting time to join us as we work together with the four district councils to deliver the new council for Somerset.

This role offers flexible working arrangements, including home working and flexible working hours.

For more information or an informal discussion about this post please contact Josh Pimm JzPimm@Somerset.gov.uk

We are proud to offer an environment that is supportive and rewarding, working as part of a team who are passionate about the work they do to improve the lives of people in Somerset. We offer great training and development opportunities, with supportive management. As well as this, we have some fantastic employee benefits available:

• We promote a healthy work-life balance and offer flexible working arrangements wherever possible, including working from home.

• Generous annual leave allowance, with the opportunity to purchase additional leave.

• Employee Assistance for the times you may need some support and a variety of employee wellbeing services.

• Auto enrolment onto our generous Pension Scheme and optional pension enhancement through our Additional Voluntary Contribution scheme.

• A Flexible Benefits Scheme via salary sacrifice to obtain a car or bicycle for work
• Staff benefit scheme offering discounts in shops, online shopping, restaurants, cinema tickets, insurance benefits, holidays, gym membership and more.

This role requires a Basic check via the Disclosure procedure.