Junior Data Analyst Apprenticeship

Baltic Apprenticeships; Sunderland; On-site; GBP 16,000; Full time

Job summary

A focused training provider is seeking a Junior Data & Systems Analyst Apprentice in Sunderland. You'll capture and analyse business data to improve efficiency and profitability while receiving training in essential data skills. Responsibilities include designing dashboards, developing automated reporting tools, and supporting IT functions. The role offers a salary of £15,808, 25 days annual leave plus bank holidays, and a supportive learning environment.

Benefits

25 Days Annual Leave + Bank Holidays

Employee Assistance Help

Loyalty Holidays

Death in Service Policy

Qualifications

• Strong attention to detail and ability to organise complex information.
• Eager to learn about automation, analytics, and digital transformation.
• Ability to communicate clearly with both technical and non-technical colleagues.

Responsibilities

• Collect, clean, and manage business data from core systems.
• Design and build dashboards in Power BI to track business performance.
• Develop automated reporting tools to enhance data accessibility.
• Analyse patterns and trends in various business operations.
• Support the creation of a central data model for reporting.
• Provide first-line IT support and maintain user accounts.

Skills

Data analysis

Excel

Power BI

Data cleaning

Problem-solving

Education

Grade 4/C in Maths & English GCSE

Tools

Microsoft 365

Power Automate

SharePoint

Power Query

Job description

Are you fascinated by data and how it drives better decisions? Do you enjoy using technology to turn numbers into stories that help people work smarter? At Sotech, they're on an ambitious digital journey — combining precision manufacturing with real‑time data and analytics. From their advanced machinery and production systems to their digital backbone built on Microsoft 365, Business Central, Power BI, and Power Automate, every part of the business is becoming more connected, measurable, and insight‑driven.

Junior Data & Systems Analyst (Apprentice)

Your Mission

You’ll help the business capture, clean, analyse, and visualise key data streams, making sure the right people see the right information at the right time.

You’ll be part of projects that directly improve efficiency, accuracy, and profitability — while learning how data underpins every aspect of a modern manufacturing business.

What You’ll Do

• Collect, clean, and manage business data from core systems such as Microsoft Business Central, SharePoint, and production databases.
• Design and build dashboards in Power BI to track business performance — from production throughput and waste reduction to customer project timelines and on‑time delivery.
• Develop automated reporting tools using Power Automate to replace manual spreadsheets and ensure live data is always available.
• Analyse patterns and trends in sales, estimating, engineering, and operations to highlight opportunities for efficiency and improvement.
• Support the creation of a central data model that links multiple systems, helping Sotech build a “single source of truth” for reporting.
• Assist with data governance, ensuring information is accurate, standardised, and secure across the company.
• Collaborate with teams to understand what insights they need — translating questions into meaningful visual analytics.
• Use Power Query and Excel to transform raw data into structured, actionable information.
• Support business planning by contributing data for forecasting, KPIs, and performance analysis.
• Document data processes and insight frameworks for future scalability.

Systems & IT Support (25%)

• Provide first‑line support for IT queries related to data access, reporting tools, or system logins.
• Help maintain user accounts, devices, and permissions within the Microsoft 365 environment.
• Support SharePoint administration, ensuring data storage and sharing follow best practice.
• Work with external IT partners on integrations or troubleshooting when data systems overlap.
• Keep up to date with new features across Microsoft 365, Power Platform, and Business Central that can enhance reporting.

Who You Are

• You’re naturally curious about data — how it’s created, connected, and used to make decisions.
• You enjoy solving problems and spotting trends in information.
• You’re confident with Excel or Power BI, or you’re eager to learn.
• You have strong attention to detail and like organising complex information.
• You can communicate clearly with both technical and non‑technical colleagues.
• You’re motivated to learn about automation, analytics, and digital transformation.
• You want to be part of a forward‑thinking business that values innovation and insight.
• Have a grade 4/C in Maths & English GCSE – Required

Salary, Hours & Benefits

• Mon – Thur: 8.00 am – 5.00 pm | Fri – 8:00 am – 12 pm
• Salary – £15,808
• 25 Days Annual Leave + Bank Holidays
• Employee Assistance Help
• Loyalty Holidays
• Death in Service Policy

Your Training with Baltic Apprenticeships

Baltic Apprenticeships were the first training provider to offer a completely tech‑focused, tech‑driven training solution. We help people transform their knowledge and passion into skills that employers need.

This apprenticeship will teach you essential data skills, including how to source, format and present data; data validation and analysis; and how to apply legal and ethical principles when gathering and manipulating business data.