Junior Data Analyst Apprenticeship

Baltic Apprenticeships
Sunderland
1 day ago
Create job alert

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.


#J-18808-Ljbffr

Related Jobs

View all jobs

Junior Data Analyst Apprenticeship

Data Analyst Apprenticeship

Senior Data Engineer in Bristol)

Senior Data Engineer

Senior Data Engineer in Nottingham)

Junior Data Analyst

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.