Data Engineer Apprentice

Job Summary

Join NHSBSA as an Apprentice Data Engineer and gain hands-on experience building and maintaining data pipelines while studying for a Level 5 qualification. You'll support data sourcing, transformation, and integration under expert guidance, ensuring data is accurate, secure, and accessible. Collaborate with analysts, engineers, and governance teams to deliver data solutions. You'll develop coding, documentation, and troubleshooting skills, and apply data protection principles. This hybrid role includes remote work and regular office visits in Newcastle. Ideal for someone curious, detail-oriented, and eager to learn in a supportive, innovative environment.

What do we offer?

• Hybrid working - offering flexibility to work predominantly from home with the opportunity to be office based should you prefer, or if business needs require ito 27 days leave (increasing with length of service) plus 8 bank holidayso Opportunities for developmento Active wellbeing and inclusion networkso Excellent pensiono Various salary sacrifice schemeso Employee Assistance programme, offering free 24/7 support for you and your loved oneso Access to a wide range of benefits and high street and online discounts
  
  
  

Main duties of the job

• Support the design, build, and testing of data pipelines using multiple data sources.
• Assist in creating reusable data products and maintaining accurate documentation.
• Learn and apply data protection and governance principles.
• Write and test simple scripts, troubleshoot issues, and contribute to code reviews.
• Collaborate with analysts, engineers, and governance teams to deliver data solutions.
• Help with metadata and integration tasks, and support data modelling and transformation.
• Engage fully with the Level 5 Data Engineering apprenticeship, attending training, mentoring, and completing academic work.
• Explore new tools and contribute to a culture of learning and innovation.
• Work under supervision while gradually taking on more responsibility as skills develop.
  
  
  

Eligibility Criteria:o You must not currently be in full-time education or hold an existing qualification at the same or higher level in a similar subject.o You must have the right to work in the UK and have lived in the UK/EU for at least three years, currently residing in England (as per government guidelines).

About Us

Here at the NHS Business Services Authority (NHSBSA), what we do matters.We manage the NHS Pension scheme, process prescription payments and much more. Our services are used by NHS organisations, contractors and the public: we're proud to be part of something meaningful, that touches millions of lives.We design our services around customer needs and place people at the heart of our organisation. That's why when you join us, you'll be empowered and supported to help your career grow.As one of the UK's Best Big Companies to work for, we're connected to our values: Collaborative, Adventurous, Reliable and Energetic. We care about our people, our purpose, and your progress.We strive to offer a fantastic colleague experience, where every colleague is heard, supported and respected. Wellbeing, diversity and inclusion is at the centre of this, and you can join our Lived Experience Networks who help us bring our authentic selves to work.We're committed to being a flexible employer and we try to offer a working pattern that suits you where possible, through hybrid working, flexible hours and more.Alongside a competitive salary with pay progression, we offer a people-centric benefits package, connecting you to the rewards and benefits you value most!Ready to join us in delivering business service excellence to the NHS, helping people live longer, healthier lives? Apply today and see where the NHSBSA can take you.We are people connected to care.

Job Description

Job responsibilities

In this role, you are accountable for:

• Supporting the design, build and testing of data pipelines and data products under supervision, using data feeds from multiple systems and working with a range of storage technologies and access methods.
• Contributing to the creation of repeatable and reusable data products, developing an understanding of how tools and processes align with the wider business data architecture.
• Learning and applying Information Governance principles when handling data, ensuring that its storage and use complies with relevant legislation and NHSBSA policies, under guidance.
• Working with metadata to support tasks such as system and data integration analysis, with support from more experienced colleagues.
• Helping to maintain documentation and repositories to ensure information about data assets remains accurate and up to date.
• Writing, testing, and documenting simple programs or scripts under the direction of senior team members and learning how to troubleshoot and fix common issues.
• Taking part in peer reviews and testing of work at a similar level of complexity, learning to give and receive constructive feedback.
• Contributing to code reviews by observing good practice and, with support, applying basic refactoring techniques to help improve code quality and maintainability.
• Applying core technical concepts related to data engineering tasks under supervision and actively building knowledge through training and practical work.
• Exploring opportunities to experiment with new tools and approaches, contributing to a culture of learning and innovation within the team.
• Learning and adopting industry best practices and standards in data engineering and helping to embed them in day-to-day work through observation and participation.
• Collaborating with colleagues across teams, including analysts, data scientists, and data governance professionals building positive relationships, to support the delivery of shared goals and data solutions.
• Engaging with and completing all the academic requirements of the level 5 Data Engineering apprenticeship at the expected standard
• Attending and utilising all the learning, coaching and mentoring events provided by the apprenticeship provider and being proactive in seeking out extra support if/when it is needed.
  
  
  

In addition to the above accountabilities, as post holder you are expected to

• Undertake additional duties and responsibilities in line with the purpose of your role and as agreed by your line manager.
• Demonstrate NHSBSA values and core capabilities in all aspects of your work.
• Encourage an environment where your own and colleagues safety and well-being is promoted.
• Contribute to a culture which values diversity and inclusion.
• Follow NHSBSA policies, procedures, and protocols as they apply to your role.
  
  
  

Person Specification

Skills

Personal Qualities, Knowledge and Skills Essential

• Strong problem-solving skills appropriate to a learning role, with a good level of attention to detail when working with data.
• Good verbal and written communication skills, with the ability to learn how to explain technical ideas clearly to non-technical colleagues.
• Willingness to receive feedback and adapt, demonstrating self-awareness and a positive approach to personal development.
• A collaborative and inquisitive attitude, showing enthusiasm for learning new skills, tools, and technologies.
• Ability to focus and concentrate for extended periods, particularly when supporting the development or troubleshooting of data pipelines and related tasks.
• Ability to build effective relationships with a variety of stakeholders.
• Confident knowledge of Microsoft Office programs.
• Be an effective team member who can work under direction but also use initiative to take the lead when necessary.
  
  
  

Desirable

• Familiarity with NHS data systems or healthcare environments, gained through work experience, study, or interest.
• Awareness of data quality issues and common techniques for identifying and resolving them.
• Basic understanding of good coding practices, including the importance of logging, error handling, and data auditing.
• Interest or experience in using data visualisation tools, even at a basic or exploratory level (e.g. Power BI, Excel, Tableau).
• Organised and self-motivated, with developing time management skills and the ability to follow agreed plans and timelines.
  
  
  

Experience Essential

• Interest in working with large and complex datasets, with an ability to learn techniques for managing, transforming, and analysing data effectively.
• Some experience with Python or another programming language for data manipulation, gained through study, personal projects, or training.
• Basic understanding of how data is used in reporting and analytics environments, with a willingness to develop practical skills in using data to support decision-making.
• Ability to create and maintain technical documentation, and an appreciation of its importance in supporting knowledge sharing and consistent development practices.
• Basic understanding of data protection and information governance principles, with a commitment to handling data responsibly and securely.
• Ability to follow structured methods, standards, and procedures when completing technical tasks, with an understanding of the importance of quality and consistency.
• Ability to learn and apply new technical skills, including working with unfamiliar tools, technologies, or data sources as part of a development programme.
• Experience of working as part of a team to deliver measurable outcomes.
• Experience of working in environment where written and verbal communication are essential to delivery of outcomes.
  
  
  

Desirable

• Awareness of data engineering concepts, including Data Warehousing or ETL processes.
• Exposure to deployment pipelines or CI/CD concepts, with a willingness to learn how code is tested and promoted into production environments.
• Familiarity with reporting and dashboarding tools, such as Power BI, even if only at a basic or learner level.
• Interest in data analytics techniques, and a desire to learn how they are applied in healthcare or public sector settings.
• Curiosity about the use of Generative AI or other modern technologies in data development work.
• Basic understanding of source control tools, such as Git, and how they are used in collaborative development.
• Awareness of Agile methodologies, and an interest in working in an iterative, team-based environment.
• Interest in data modelling for analytics, with a willingness to develop understanding of concepts such as star schemas, fact/dimension tables, and modelling for performance.
  
  
  

Qualifications Essential

• Minimum of 5 GCSEs or equivalent at grade 4 (grade C) or above.
• Relevant Level 3 qualifications that incorporate either maths, science or computer science.
• Proficient in using Microsoft Excel
  
  
  

Desirable

• 120+ UCAS tariff points