data analyst summer internship jobs

Job Purpose

The Data Analyst Apprentice will join our Data Team who play a vital role in ensuring the business use accurate information to guide decision-making, improve services, and deliver value for money. You are being offered an exciting opportunity to work towards a nationally recognised Level 4 Data Analyst qualification in a sector that makes a real difference for its customers. This role combines practical work experience with structured training. The apprentice will work in support of colleagues from a wide range of services such as housing management, maintenance, finance, IT among others to make best use of all available data to achieve the best results.

Castles & Coasts is a social housing association with more than 7,400 homes across the North of England in Cumbria, Northumberland, Tyne and Wear and North Lancashire.  We pride ourselves in focusing on the needs of the local communities we serve, tackling the housing shortage, improving services within our communities, and use our strength and efficiency to meet housing service needs. We are committed to providing excellent services to our customers.

Apprenticeship Overview

• Anticipated duration: 24 months Fixed Term Contract
• Apprenticeship level: Level 4 (Advanced)
• Programme: Level 4 Data Analyst

During this apprenticeship, you will follow a fully supported training programme with LearnTech, delivered through combined weekly remote classroom-based training, workplace assessment/training and online learning working towards completing the Data Analyst Apprenticeship Standard.

The training will prepare the apprentice to competently deliver duties that can be found here: https://skillsengland.education.gov.uk/apprenticeships/st0118-v1-1

Key responsibilities:

During the apprenticeship, the Data Analyst Apprentice will learn and deliver:

Data Collection & Management

• Gather, collate, and validate data from internal systems and external sources.
• Maintain data quality, identifying errors and inconsistencies.
• Apply data protection and GDPR principles when handling information.

Analysis & Interpretation

• Use statistical and analytical techniques to interpret data.
• Support the Data Team in identifying patterns, trends, and insights.
• Contribute to business decisions by providing evidence-based recommendations.

Tools & Technology

• Learn to use data tools such as Excel, SQL, and Power BI.
• Develop coding and querying skills for data extraction and analysis.
• Create reports, dashboards, and visualisations to present findings clearly.

Communication & Collaboration

• Work with colleagues across the organisation to understand their data needs.
• Explain technical findings in clear, accessible language to non-technical audiences.
• Support project teams with data requirements and performance monitoring.

Continuous Learning & Development

• Participate in all apprenticeship training and assessments.
• Apply new knowledge, skills, and behaviours to workplace tasks.
• Reflect on learning and seek opportunities to improve.

Essential skills, characteristics and experience

The successful candidate will be expected to demonstrate or develop the following in line with the Level 4 Data Analyst apprenticeship standard:

Knowledge (to be developed through the apprenticeship):

• Different types of data and how they are used to support decision-making.
• Data structures, databases, and data management principles.
• Data analysis methods, statistical techniques, and validation processes.
• Industry-standard tools (e.g., Excel, SQL, Power BI, Python/R).
• Data legislation, policies, and ethical considerations (e.g., GDPR).
• How organisations use data for business improvement.

Skills (to be demonstrated and applied during the role):

• Collecting, organising, and formatting data from multiple sources.
• Performing data cleansing to ensure accuracy and reliability.
• Applying analytical and statistical methods to identify trends.
• Using tools and techniques to create reports, dashboards, and visualisations.
• Summarising and presenting data in ways that are meaningful for different audiences.
• Communicating findings clearly to colleagues and stakeholders.
• Managing own time and workload effectively to meet deadlines.

Behaviours (to be demonstrated consistently):

• Attention to detail and commitment to data accuracy.
• Logical and creative thinking in problem-solving.
• Professionalism and integrity when handling sensitive information.
• Collaboration and teamwork across departments.
• Proactive approach to learning and applying new skills.
• Commitment to delivering value and positive outcomes for customers and communities.

Requirements

It is a requirement to have five GCSE 4-9 grades or equivalent (A-C) or above (including English and Maths) to apply for this type of apprenticeship. If you do not have these grades but have completed numeracy and literacy Key Skills/Functional Skills at level two you may also apply for these apprenticeships.

Eligibility

You must meet the following eligibility criteria to apply for the role:

• Have been a UK/EEA resident for the last 3 years
• Hold valid residency status
• Have the right to work in the UK
• Can commute weekly to offices in either Newcastle-upon-Tyne or Carlisle as required to meet business needs.

Job Types: Full-time, Fixed term contract, Apprenticeship
Contract length: 24 months

Pay: From £23,015.00 per year

Work Location: In person