Coronavirus (COVID-19): to find out how we can support you with your apprenticeship including if you have been affected by redundancy, read our updated information.

Business Intelligence Apprenticeship Kennedys Law LLP

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.

This apprenticeship requires you to apply through the employer's website.

Apply now

Closing date: 31 Aug 2022

Apprenticeship summary

  • Annual wage


    £20,650 for London and £18,550 for regional

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

    Total hours per week: 35

  • Expected duration

    24 Months

  • Possible start date

    01 Oct 2022

  • Date posted

    19 Jul 2022

  • Apprenticeship level

    Level 4 (Higher national Certificate)

  • Reference number


  • Positions

    1 available

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.

Requirements and prospects

Desired skills and personal qualities

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


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

About the employer

Kennedys is a global law firm with expertise in dispute resolution and advisory services. With over 2,400 people worldwide across 43 offices in the UK, Europe, Middle East, Asia Pacific and America we have some of the most respected legal minds in their field. Our lawyers handle both contentious and non-contentious matters, and provide a range of specialist legal services, for many industry sectors but we have particular expertise in litigation and dispute resolution, especially in defending insurance and liability claims. We're a fresh-thinking firm, and we're not afraid to bring challenging new perspectives to the table way beyond the traditional realm of legal services. We empower our clients with a diverse range of ideas, tools and technology to make their lives easier, as well as delivering exceptional results, every time.


Kennedys Law LLP


91-99 New London Rd



You must have JavaScript enabled to view a map of the location


Training provider


Apprenticeship standard

Data analyst

Level 4 (Higher national Certificate)

Employer's Application Instructions

This apprenticeship requires you to apply through the employer's website.

Apply now

Closing date: 31 Aug 2022