Junior Data Analyst Apprentice

QA Limited; Elland; On-site; GBP 21,000 - 27,000; Full time

Benefits offered by this job

Workplace Pension

25 Days Holiday and Free Tea and Coffe

Supportive office space environment

Job summary

QA Limited is seeking a Junior Data Analyst to translate complex data into actionable insights and robust reports. You will build data models in Excel, Power BI, and Power Query, delivering dashboards that help stakeholders understand performance and drive improvements.

The role emphasises collaboration across departments, attention to detail, and the ability to manage competing priorities while meeting deadlines.

Qualifications

• A-Level Mathematics (Grade 4+) or equivalent.
• Demonstrable interest in data analysis, reporting and business intelligence.
• Relevant apprenticeship, qualification or practical experience in data analysis would be advantageous.

Responsibilities

• Create reporting packages and data models using Microsoft Excel, Power Query, Power Pivot and Power BI to generate meaningful insights from raw data.
• Develop dashboards and visual reports to improve understanding of business performance and operational processes.
• Maintain, enhance and streamline existing reporting packages.
• Liaise with department managers and supervisors to understand reporting requirements and provide analytical insights.
• Present findings, trends and recommendations to stakeholders.
• Cleanse and validate data to ensure reporting accuracy and efficient processing.
• Support the continuous improvement of data analysis and reporting processes.

Skills

Advanced Excel

Power BI

Power Query & Power Pivot

Data visualization

Data cleansing

Stakeholder communication

Analytical thinking

Mathematics

Education

A-Level Mathematics (Grade 4+)

GCSE English (Grade 4+)

Relevant apprenticeship/qualification in data analysis

Practical experience in data analysis

Tools

Power BI

SQL

Python

Power Query

Power Pivot

Microsoft Office

Job description

Terberg DTS is the UK subsidiary of the Royal Terberg Group, specialising in the supply, rental and support of specialist vehicles and equipment for logistics, ports, airports, industrial, rail, and fire & rescue sectors. The company combines vehicle sales with nationwide maintenance, parts and 24/7 support services to help customers maximise fleet up time.

Purpose of the role

The Junior Data Analyst is responsible for providing valuable business insight through the analysis of complex datasets and the creation and maintenance of reports. The role works closely with departments across the business to answer queries from managers and supervisors, supporting informed decision-making and continuous business improvement.

Key responsibilities

• Create reporting packages and data models using Microsoft Excel, Power Query, Power Pivot and Power BI to generate meaningful insights from raw data.

• Develop dashboards and visual reports to improve understanding of business performance and operational processes.

• Maintain, enhance and streamline existing reporting packages.

• Liaise with department managers and supervisors to understand reporting requirements and provide analytical insights.

• Present findings, trends and recommendations to stakeholders.

• Cleanse and validate data to ensure reporting accuracy and efficient processing.

• Support the continuous improvement of data analysis and reporting processes.

Critical skills and knowledge required

• Strong mathematical and IT skills.

• Ability to manage workload independently and prioritise tasks effectively.

• Ability to work under pressure and meet tight deadlines.

• Excellent verbal and written communication skills.

• Ability to communicate confidently with stakeholders at all levels.

• High attention to detail and accuracy.

• Strong interpersonal skills and the ability to build effective working relationships.

• Excellent organisational and time management skills.

• Advanced knowledge of Microsoft Excel.

• Working knowledge of data visualisation tools such as Microsoft Power BI.

• Good knowledge of Microsoft Office applications including Teams, Outlook, Word and PowerPoint.

• Understanding of data cleansing, validation and reporting techniques.

Qualifications and experience required

• A-Level Mathematics (Grade 4 or above) or equivalent.

• GCSE English (Grade 4 or above) or equivalent.

• Demonstrable interest in data analysis, reporting and business intelligence.

• Relevant apprenticeship, qualification or practical experience in data analysis would be advantageous.

If you hold international equivalents of the above qualifications, at the time of your application you must be able to provide an official document that states how your international qualifications compare to the UK qualifications.

For more information please visit the UK ENIC website.

Desirable knowledge and qualifications

• Knowledge of programming languages such as Python and/or SQL.

• Level 3 Data Essentials Apprenticeship.

• Level 4 Data Analyst Apprenticeship.

Working hours: 37.5 hours - Monday to Friday, 8.30am - 5.00pm

Benefits:

• Workplace Pension

• 25 Days Holiday and Free Tea and Coffee

• Supportive office space environment

Future prospects:

90% of QA apprentices secure permanent employment after completing: this is 20% higher than the national average.

About QA:

Our apprenticeships are the perfect way to gain new skills, earn while you learn, and launch yourself into an exciting future. With over 50,000 successful apprenticeship graduates, we're a top 50 training provider, dedicated to helping you succeed.