Junior Data & Systems Analyst Apprenticeship

New College Durham; Peterlee; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading apprenticeship provider in Peterlee is looking for a Junior Data & Systems Analyst (Apprentice) to join their team. The role involves collecting and managing business data, building dashboards in Power BI, and providing IT support. Candidates must have a minimum grade 4 in GCSE Maths and English. This apprenticeship offers hands-on experience in data analysis, IT support, and exposure to various Microsoft tools, aiming to foster skills in digital insights and data-driven decision-making.

Qualifications

• Minimum grade 4 or above in GCSE Maths and English.

Responsibilities

• Collect, clean, and manage business data from core systems.
• Design and build dashboards in Power BI to track performance.
• Develop automated reporting tools using Power Automate.

Skills

Data analysis

Power BI

Microsoft 365

Excel

Education

GCSE Maths and English (minimum grade 4)

Tools

Power Automate

Microsoft Business Central

SharePoint

Job description

Opportunity information

Duration: 18 months
Advert closing date: 15/12/2025

Description

SOTECH IS A LEADING DESIGNER AND MANUFACTURER OF THE OPTIMA RANGE OF ENGINEERED METAL RAINSCREEN FACADE CLADDING SOLUTIONS AND ARCHITECTURAL FABRICATIONS. From secret‑fix hook on faade cladding solutions to bespoke extrusion tailored to meet your design, Sotech works closely with architects, specifiers, fire consultants, main contractors and installers to specify the most suitable faade cladding solution.

Shape the Future of Digital Insights at Sotech

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, we’re on an ambitious digital journey combining precision manufacturing with real‑time data and analytics. From our advanced machinery and production systems to our 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.

We’re now looking for a Junior Data & Systems Analyst (Apprentice) to join our team and help us harness data to power smarter decisions across design, manufacturing, sales, and operations.

Entry requirements

Minimum grade 4 or above in GCSE Maths and English.

What You’ll Do

Data & Insights (75%)

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

We’ll support you through every step of your apprenticeship, combining structured training with real‑world project experience.

You’ll Gain Exposure To

• Power BI, Power Automate, Power Apps
• Microsoft Business Central (ERP) and data management principles
• Data modelling, reporting, and visualisation techniques
• Business analytics and KPI development
• Digital transformation and process automation projects

As your skills grow, you’ll contribute to cross‑departmental data projects and continuous improvement initiatives that shape how Sotech measures and manages success.

Things to consider

Skills Required: Array

Future prospects

Hours per week: 37
Working week: Monday – Friday
Apprenticeship standard: Data analyst (Level 4)
Location: Peterlee, County Durham, England, SR8 2RU