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



Training to be provided



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)



Peterlee, County Durham, England, SR8 2RU