0 people have applied to this vacancy

0 people have viewed this vacancy

Data Analyst Apprentice

  • QA Apprenticeships
  • Edinburgh, City of Edinburgh
  • £11.25 per hour

Vacancy provider logo for QA

  • GMFJ Reference
  • Wages
    £11.25 p/h
  • Hours
    37.50 per week
  • Date Posted
  • Start Date
  • Duration
    Not Specified

  • Location
  • Status
    Now Taking Applications
  • Sector
    Data analysts
  • Opportunity Type
    Higher Level 4
  • Employer
    QA Apprenticeships


Lothian operates over 80 routes 24/7 throughout Edinburgh and the Lothians, carrying 110 million passengers in 2023. Data is at the heart of what Lothian ds and helps us to understand the needs of our customers and the city we operate in.

As part of a technical apprenticeship in Data Analytics you will learn how to collect, properly store, analyse and report on data, identifying the most important pieces of information and presenting them in a way that makes sense to a variety of audiences. If you’re good with numbers, have good IT skills and like problem solving, this is the apprenticeship for you!


  • Import data from various sources to produce a daily situation report to Garage Managers

  • Export and store data from various systems on a daily and weekly basis to allow our reporting tools to update

  • Provide HR, Payroll, Finance and Insurance departments with weekly data exports and reports

  • Work with other Operations Support team members to design, update and deploy Microsoft Power BI dashboards and reports

  • Prepare data packs for all new drivers to allow them to access key systems on commencement of employment

During your apprenticeship, you will learn:  

  • How to work with large and evolving datasets and apply them to a fast-paced business setting

  • Design and create databases to store data in the most efficient way

  • Aggregate and apply various collections of data to different reporting methods including Microsoft Power BI, Microsoft Excel and various staff and transport-management tools

  • The importance of reporting KPIs and other key information as part of our legal responsibilities as a transport operator

  • How to provide managers with the data tools they need to do their jobs in running busy bus garages throughout our operating area

  • Work with other departments throughout the business to discover new ways to provide the data they need

  • Carry out best health and safety practices

  • Develop your own data knowledge

Desirable skills:

  • Writing and understanding formulas in Microsoft Excel

  • Using pivot tables and other complex data sorting tools in Microsoft Excel

  • An understanding of Business Intelligence products, with a focus on Microsoft Power BI

  • An understanding of Microsoft Access and SQL databases

  • A good knowledge of all Microsoft Office products


£23,400 per annum

Working hours:

37.5 hours per week, Monday to Friday, 9am - 5:30pm, with some flexibility required.


  • Competitive salaries

  • Lothian catering

  • Perkbox

  • Cycle to work scheme

  • Colleague offers

  • Health and wellbeing 

  • HSF Health Plan

Future prospects:

There is the opportunity for continued employment within this team should you perform well during your apprenticeship. We want you to grow, succeed and become a permanent team member.

Important information:

This vocational apprenticeship comprehensively supports your specific job role with this particular employer.  Throughout your learning journey, you are fully supported by your dedicated QA skills coach and your mentor at work.  They ensure you settle in, help you develop all the skills you need to be successful in your job role and pass your assessments, and can provide one to one support.

Starting with insights into your current potential, they plan your growth in a programmatic way, close skills gaps with immersive training and ensure what you learn is applicable to what you do. They talk you through the specifics on the qualifications you gain and how they align in particular to your day to day role.

On completion, as well as the valuable work experience you have gained, you get a nationally recognised qualification at SCQF Level 8. 

If you are interested in starting your career and receiving a work based qualification at the same time APPLY NOW!

For more information about this vacancy please contact QA on 01793696141 (Ref ID: 251980)

Based on this opportunity you might also be interested in.

Skills Bootcamp - Data Analytics

  • Data analysts
  • Competitive p/w
  • Advanced Level 3
  • Virtual

Skills Bootcamp - Data Analytics

The most flexible Skills Bootcamp in Data Analytics with courses starting every week.This 12-week Skills Bootcamp in Data Analytics is designed to provide you with a deep understanding of various data analytics tools and techniques that are crucial in todays data-driven business landscape.

Administration Assistant Apprentice

  • Data analysts
  • 269.15 p/w
  • Advanced Level 3

Administration Assistant Apprentice

Supply Chain Data Apprentice

  • Data analysts
  • 360.75 p/w
  • Advanced Level 3

Supply Chain Data Apprentice

Data Analyst Apprentice

  • Data analysts
  • 351.75 p/w
  • Higher Level 4

Data Analyst Apprentice

Data Analyst Apprentice

  • Data analysts
  • 486.75 p/w
  • Higher Level 4
  • Wallsend

Data Analyst Apprentice

Data Innovation Apprentice

  • Data analysts
  • 324.38 p/w
  • Higher Level 4

Data Innovation Apprentice

Data Entry PA Apprentice

  • Data analysts
  • 346.00 p/w
  • Advanced Level 3

Data Entry PA Apprentice

Data and Sage Specialist Apprentice

  • Data analysts
  • 432.80 p/w
  • Higher Level 4

Data and Sage Specialist Apprentice

Opportunities with QA

At QA, we believe that everything starts with our learners. Transforming their careers, and in turn their lives, is what motivates us. Every day we get to empower people to fulfil their potential – creating capability, building confidence and breaking down barriers to opportunity.

Find Out More
Cyber Essentials
© 2021 GetMyFirstJob Ltd.

Your first steps into the world of work for Apprenticeships, Degree Apprenticeships, Work Experience & Graduate Jobs