Kennedys Law Llp

Business Intelligence Apprenticeship - Higher (Level 4)

Kennedys Law Llp (Employer)

Ginger Nut Media Limited (Training Provider)

Annual wage £18,550.00
35.0 hours per week The apprenticeship will involve working at Kennedys four days a week and having one day a week to study. The office hours are Monday - Friday, 09:30 – 17:30.
24 months (duration)
1 October 2022(start date)
Data analyst (apprenticeship standard)
Digital (route)
31 August 2022 (application closing date)
Register interest

Job Description

This is aimed at those that have completed A Levels or equivalent studies and are looking to embark on an exciting career and earn as they learn. The apprenticeship will provide an insight into Kennedys Business Intelligence team who are responsible for delivering valued business intelligence to key clients and senior internal audience.


What will the apprentice be doing?

The apprenticeship will be based in Chelmsford will have the opportunity to get involved in a vast number of data related activities across our business. Activities ranging from the production of: Client reports (development through to delivery), business insights and dashboard visualizations via PowerBI.


In addition to a dedicated supervisor at Kennedys, you will have a tutor at Kaplan to ensure that you have all the support you need at work and with your studies. We offer a competitive salary (paying at a minimum the UK Living wage both in and outside London).


Ginger Nut Training will be our learning provider for the Level 4 Data Analyst apprenticeship which will take place remotely. The apprenticeship will involve working at Kennedys four days a week and having one day a week to study. 


Your duties will include but are not limited to: 

  • Utilise in depth knowledge of Excel to ensure client reporting is produced efficiently and accurately
  • Ensure reports are delivered to a high standard, on time and to the requirement of the contract
  • Champion the importance of data quality, and work towards the vison of the Kennedy’s Client Reporting and Insight team being deemed as Industry best.

What training will the apprentice take and what qualification will the apprentice get at the end?

Data Analyst – Level 4

Standard -


Assessment Plan -


With regards to the Data Analyst level 4 standard we would be able to deliver this remotely and (potentially in future) at your offices.  Delivery would be based on visits every month alongside monthly classroom sessions, curated video channels, workbooks, webinars and other learning materials. 


The specific outline for each learner will depend on a number of factors such as their roles, priorities and needs but course outlines but based on all knowledge delivered to a learner there would be approximately 85 hours of tutor led over the duration of the apprenticeship alongside 20 hours of SQL training. This would leave approximately 5 hours per week of additional learner tasks and other learning activities (based on a fully working week).


The course teaches learners to collect, organise and study data, using a range of analytical techniques to provide business insight and technical data solutions to stakeholder/customer issues.


This includes a number of skills:


Identify, collect and migrate data
Manipulate and link data sets
Perform database queries and statistical analyses
Use analytical and modelling techniques to identify and predict trends
Produce reports and present results

And covers these areas of knowledge:


Data life cycle
Different types of data
Data structure
Database design
Quality issues
Defining customer requirements
Processes and tools for data analysis and integration

The two knowledge modules are primarily covered in the classroom sessions:

·         Data Analysis Tools

·         Data Analysis Concepts


Alongside this we include the SQL for Developers and Analysts with MS SQL Server course which includes 3.5 hours of additional video learning alongside online workbooks and takes approximately 20 hours to complete.


Evidence collected will cover knowledge, skills and behaviours and helps the learner build the experience and portfolios they need to successfully complete their apprenticeship. 

We also give the learners mock synoptic projects and EPA interviews to ensure they are ready for the End Point Assessment and know precisely what to expect at all points in the process. The EPA itself includes:


·         Portfolio –produced towards the end of the apprenticeship, containing evidence from real work projects

·         Project - a business-related project over a one-week period away from the day to day workplace

·         Employer Reference

·         A structured interview with an assessor - exploring the portfolio and the project

What is the expected career progression after this apprenticeship?

Depending on team requirements, there is opportunity to become a permanent member of the team after qualification.

Skills Required

Communication skills, Attention to detail, Team working, Time Management, Microsoft Office

Qualifications Required

A Level or equivalent Any 3 subjects (Grade B or above) Desired
Register interest