Data Analyst Apprentice

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 does 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!

Responsibilities:

• 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

Salary:

£23,400 per annum

Working hours:

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

Benefits:

• 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!