Business Intelligence Analyst Apprentice

QA; Tees Valley; On-site; GBP 14,000 - 19,000; Full time

Job summary

Zig Up is recruiting a curious, motivated BI Analyst Apprentice to join the Business Intelligence team. This apprenticeship blends hands-on data work with structured training, developing skills in reporting, analysis and visualization using Power BI, SQL and Microsoft Fabric.

You'll work with experienced BI analysts, gain exposure to data modelling and governance, and contribute ideas to improve how the business reports on data.

Qualifications

• Interest in data, technology and how businesses use information.
• A logical and curious approach to solving problems.
• Good attention to detail and willingness to investigate.
• Clear communication and ability to work with others.
• Basic confidence with computers, spreadsheets and numbers.
• Good organisational skills and ability to meet deadlines.
• A positive attitude towards learning and developing new skills.
• Understanding of handling information securely.

Responsibilities

• Create, update and maintain reports, dashboards and visualisations.
• Learn to use Power BI to prepare, analyse and present data.
• Use SQL to explore data, check accuracy and investigate issues.
• Support testing of new reports and data updates for accuracy.
• Document reporting requirements, processes and guidance.
• Develop knowledge of Power BI data modelling, Power Query and DAX.
• Gain exposure to Microsoft Fabric dataflows, pipelines, Lakehouses and SQL databases.
• Learn about data quality, governance, security and best practices.
• Contribute ideas to improve how the business uses and reports on data.

Skills

Data interest

Analytical thinking

Attention to detail

Clear communication

Numerical skills

Task management

Learning mindset

Information security

Education

Level 3 qualification + 12+ months work experience

Business-related degree

Non-business degree + 6+ months work experience

Existing staff with 2+ years relevant work experience

Tools

Power BI

SQL

Microsoft Fabric

Power Query

DAX

Job description

Zig Up are looking for a curious, motivated and analytical individual to join our Business Intelligence (BI) team as an Business Intelligence Analyst Apprentice.

This is a great opportunity to start a career in data and business intelligence, combining hands‑on experience with structured apprenticeship training.

You'll work alongside experienced BI analysts and data engineers, learning how to turn data into meaningful insights that help the business make informed decisions. With plenty of support and guidance, you'll develop skills in reporting, data analysis and visualisation, using tools such as Microsoft Power BI, SQL and Microsoft Fabric. You don't need to be an expert in these tools already. We're looking for someone who enjoys problem-solving, has an interest in data and is keen to learn.

You'll gain experience across a range of business intelligence activities, including:

• Helping to create, update and maintain reports, dashboards and data visualisations
• Learning to use Microsoft Power BI to prepare, analyse and present data
• Using SQL to explore data, check accuracy and investigate reporting issues
• Supporting the testing of new reports and data updates to ensure information is accurate and reliable
• Helping to document reporting requirements, processes and guidance
• Building your knowledge of Power BI, including data modelling, Power Query and basic DAX
• Gaining exposure to Microsoft Fabric, including dataflows, pipelines, Lakehouses and SQL databases
• Learning about data quality, governance, security and best practices
• Contributing ideas to improve how the business uses and reports on data

Required skills:

• An interest in data, technology and how businesses use information
• A logical and curious approach to solving problems
• Good attention to detail and a willingness to investigate and ask questions
• Clear communication skills and the ability to work well with others
• Basic confidence using computers, spreadsheets and numbers
• Good organisational skills and the ability to manage tasks and deadlines
• A positive attitude towards learning and developing new skills
• An understanding of the importance of handling information accurately and securely

Desirable experience:

It would be great if you have some experience or awareness of:

• Microsoft Excel, Power BI or other reporting tools
• SQL, Power Query, DAX or data modelling
• Microsoft Fabric or other cloud-based data platforms
• Working with data through education, employment, volunteering or personal projects
• Agile ways of working or collaborating on team projects
• Business functions such as Finance, Operations, HR or Sales

Don't worry if you haven't used these tools before. You'll have opportunities to develop your knowledge throughout the apprenticeship.

The entry requirements for this programme are one of the following:

• A Level 3 qualification plus 12+ months of work experience
• A business-related degree (e.g. business, finance, economics, maths)
• A non-business-related degree plus 6+ months of work experience
• Existing staff with 2+ years of relevant work experience

Working hours:

37.5 hours per week

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.