Junior Data Analyst Admin Apprenticeship

Summary

They are now on the hunt for an apprentice for both their Southport Office and also their Liverpool office. The role will be based on summarising and explaining gathered data, blending this data from multiple sources and presenting it when appropriate through the use of tools and techniques in-house to identify live trends.

Annual wage: £14,000 a year
Minimum wage rates (opens in new tab)
Training course: Data technician (level 3)
Hours: Working Monday-Friday, 9am-5pm.
37 hours a week
Possible start date: Friday 29 November
Duration: 1 Year 3 Months
Positions available: 1

Work

As an apprentice, you’ll work at a company and get hands-on experience. You’ll gain new skills and work alongside experienced staff.

What you’ll do at work

Access the magistrates court system to find out data around cases they are dealing with or may have dealt with in the past to perform tasks around data presentation within tables, graphs, charts etc.
Access data from key database source ‘LEAP’ which will be to continuously organise, check, and maintain wills, probate documents, etc.
Collate and format data from this for further analysis and reporting – this analysis and reporting will be for paralegals and other staff meetings identifying trends for the current market and research for further business
Using Excel, Teams, emails, and their internal case management system along with external data from post office site for addresses
Access the solicitor regulation authority for checking contact details, updating the franking machine and being responsible for uploading new postal rates to their system which change frequently through Royal Mail updates
Required to provide evidence for solicitors and line managers by scanning and creating PDF formats and versions of any documentation, which will then need to be uploaded into the case management system which involves a range of all platforms across Microsoft Office 365
Check and validate data with the involvement of removing duplicates, checking and monitoring data system daily, completing quality checks on information that may need adding, removing or updating along with formatting it correctly

Where you’ll work

Elbow Lane

Formby

Liverpool

L37 4AB

Training

An apprenticeship includes regular training with a college or other training organisation. At least 20% of your working hours will be spent training or studying.

College or training organisation

BALTIC TRAINING SERVICES LIMITED

Your training course

Data technician (level 3)

Equal to A level

Course contents

Source and migrate data from already identified different sources.

Collect, format and save datasets.

Summarise and explain gathered data.

Blend data sets from multiple sources and present in format appropriate to the task.

Manipulate and link different data sets as required.

Use tools and techniques to identify trends and patterns in data.

Apply basic statistical methods and algorithms to identify trends and patterns in data.

Apply cross checking techniques for identifying faults and data results for data project requirements.

Audit data results.

Demonstrate the different ways of communicating meaning from data in line with audience requirements.

Produce clear and consistent technical documentation using standard organisational templates.

Store, manage and distribute in compliance with data security standards and legislation.

Explain data and results to different audiences in a way that aids understanding.

Review own development needs.

Keep up to date with developments in technologies, trends and innovation using a range of sources.

Clean data i.e. remove duplicates, typos, duplicate entries, out of date data, parse data (e.g. format telephone numbers according to a national standard) and test and assess confidence in the data and its integrity.

Operate as part of a multi-functional team.

Prioritise within the context of a project.

Source and migrate data from already identified different sources.

Collect, format and save datasets.

Summarise and explain gathered data.

Blend data sets from multiple sources and present in format appropriate to the task.

Manipulate and link different data sets as required.

Use tools and techniques to identify trends and patterns in data.

Apply basic statistical methods and algorithms to identify trends and patterns in data.

Apply cross checking techniques for identifying faults and data results for data project requirements.

Audit data results.

Demonstrate the different ways of communicating meaning from data in line with audience requirements.

Produce clear and consistent technical documentation using standard organisational templates.

Store, manage and distribute in compliance with data security standards and legislation.

Explain data and results to different audiences in a way that aids understanding.

Review own development needs.

Keep up to date with developments in technologies, trends and innovation using a range of sources.

Clean data i.e. remove duplicates, typos, duplicate entries, out of date data, parse data (e.g. format telephone numbers according to a national standard) and test and assess confidence in the data and its integrity.

Operate as part of a multi-functional team.

Prioritise within the context of a project.

Your training plan

https://www.balticapprenticeships.com/programmes/microsoft-junior-data-analyst/?apprentice=1

Requirements

Essential qualifications

GCSE in:

English (grade C)
Maths (grade C)

Let the company know about other relevant qualifications and industry experience you have. They can adjust the apprenticeship to reflect what you already know.

Skills

Communication skills
Attention to detail
Organisation skills
Problem solving skills
Administrative skills
Number skills
Analytical skills
Logical
Team working
Initiative

About this company

Brown Turner Ross Solicitors are looking for an enthusiastic apprentice to join and assist with their team of highly skilled professionals. For over 135 years Brown Turner Ross have been providing legal advice to individuals and businesses from around the country. They are now on the hunt for an apprentice for both their Southport Office and also their Liverpool office. The role will be based on summarising and explaining gathered data, blending this data from multiple sources and presenting it when appropriate through the use of tools and techniques in-house to identify live trends & patterns across the sector & database. Apprentices will use the full office 365 suite to store, develop and maintain data through use of Brown Turner Ross’ case management system called LEAP along with the opportunity to use the full Microsoft 365 products and access all external database systems we have access to. From this, as an apprentice, you will collect reports for staff within the business to evidence within internal and external meetings.

Company benefits

Birthday off work Medicash £50 voucher for no sickness Quarterly staff awards Ability to buy or sell at least 3 days holiday Opportunity for full-time employment and further employment training after successful completion of apprenticeship.

After this apprenticeship

Opportunity for full-time employment and further employment training after successful completion of apprenticeship.

Ask a question

The contact for this apprenticeship is:

BALTIC TRAINING SERVICES LIMITED

Lucy Oliphant

lucy.oliphant@balticapprenticeships.com

The reference code for this apprenticeship is VAC1000280234.

Apply now

Closes on Thursday 28 November

When you apply, you’ll be asked to sign in with a GOV.UK One Login. You can create one at the same time as applying for this apprenticeship.

After signing in, you’ll apply for this apprenticeship on the company's website.

Cookies on Find an apprenticeship

Contents