Junior Data Analyst Admin Apprenticeship

BROWN TURNER ROSS LTD

Liverpool, L37 4AB

Closes in 20 days (Thursday 28 November)

Posted on 2 October 2024


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 in 20 days (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.