Senior Data Engineer The National Institute of Teaching (NIoT)

Senior Data Engineer The National Institute of Teaching (NIoT)

Full-Time 56667 - 56667 £ / year (est.) Home office (partial)
Society of Research Software Engineering

At a Glance

  • Tasks: Design and maintain Azure-based data pipelines for impactful teacher development insights.
  • Company: Join the National Institute of Teaching, dedicated to improving education through data.
  • Benefits: Enjoy 27 days holiday, flexible working, and lifestyle discounts.
  • Other info: Diverse team environment with excellent professional development opportunities.
  • Why this job: Make a real difference in education while developing your data engineering skills.
  • Qualifications: Experience in data engineering and strong T-SQL skills required.

The predicted salary is between 56667 - 56667 £ per year.

£56,667 per annum, plus benefits (+ London weighting if applicable)

Hybrid – within commuting distance of one of our campuses

We are seeking a motivated and enthusiastic Senior Data Engineer to join our TED team and play an important role in building and maintaining the technical infrastructure that supports the NIoT and TED.

About Us

The National Institute of Teaching (NIoT) has an unswerving commitment to high‑quality, evidence‑informed teacher education, and is on a mission to improve teacher and leader development across the education system. A key part of that mission is our Teacher Education Dataset (TED), an ambitious data and research initiative focused on building better evidence about teacher development and what makes teaching impactful. By bringing together education, research and digital infrastructure, TED will support new insight into how teachers develop, improve and thrive across their careers.

About the Role

Working at the intersection of data engineering, data and research, the postholder will help develop secure, reliable and scalable systems that enable robust analysis and contribute to high‑quality, evidence‑informed improvement across the sector.

Corporate Responsibilities

  • To ensure that the responsibilities of the role are carried out in a way which reflects the mission and the values of the NIoT.
  • To be aware of and observe all policies, procedures, working practices and regulations, and in particular to comply with policies relating to Equal Opportunities, Health and Safety, Confidentiality, Data Protection and Financial Regulations, reporting any concerns to an appropriate person.
  • To comply with all reasonable management requests.

Key Responsibilities

  • Design, build and maintain Azure‑based data pipelines to support the ingestion, transformation and curation of TED datasets.
  • Develop and maintain Azure SQL databases and research‑facing schemas across raw, transformed and curated data layers.
  • Write efficient, secure and well‑structured T‑SQL to support ingestion, validation, transformation and optimisation.
  • Contribute to the development and ongoing refinement of a Common Data Model across multiple education data providers.
  • Integrate and harmonise data from school MIS and EdTech platforms, including Bromcom, Arbor and Wonde.
  • Build and maintain robust validation, logging, auditing and reconciliation processes to improve data quality and trust.
  • Support secure data handling, including pseudonymisation, access control and compliance with data‑sharing agreements and security requirements.
  • Work closely with analysts, researchers, architects and partners to deliver scalable, analytics‑ready data solutions.
  • Contribute to agile planning, technical design, documentation and operational handover.

Essential Criteria

  • Proven experience in data engineering, including building and maintaining production‑grade data pipelines.
  • Strong experience with Azure Data Factory and Azure SQL Server.
  • Strong T‑SQL skills, including schema design, stored procedures and query optimisation.
  • Experience implementing validation, monitoring, logging and reconciliation controls within data pipelines.
  • Strong understanding of secure data architecture and the handling of sensitive personal data.
  • Experience with Azure DevOps, version control and CI/CD practices.
  • Strong analytical and problem‑solving skills, with excellent attention to detail.
  • Ability to communicate effectively and work successfully in a multidisciplinary team.

Desirable Criteria

  • Experience with education datasets, school MIS systems or EdTech platforms.
  • Experience with common data models, longitudinal datasets or research‑oriented data infrastructure.
  • Experience with Power BI, Fabric or related analytics technologies.
  • Experience in a public sector, education or high‑governance data environment.
  • Interest in applying data engineering to improve education and teacher development.

Benefits

  • Generous annual leave – 27 days’ holiday a year (plus 8 bank holidays), rising to 33 days after five years’ service.
  • Flexible working – we offer flexible start and end working times, with hybrid working in place for all roles.
  • Pension – Entry to the Local Government Pension Scheme.
  • Salary sacrifice schemes – we offer salary sacrifice schemes for bikes, cars and tech!
  • Lifestyle benefits – We offer discounts on gyms, cinema, retail and much more!
  • Parenthood leave – We offer above the statutory minimum for maternity, adoption and paternity leave.
  • Working environment – We have a stimulating, supportive and rewarding working environment with a dedicated team of like‑minded professionals.
  • Support: Our Employee Assistance Programme (EAP) provides confidential support for employees on personal or work‑related matters.
  • Development: We fully support the development of our staff and ensure that you have a high level of continuous professional development.

We think a wide range of different work and educational experiences could support you to be successful in this role. We encourage applications from all backgrounds, communities and industries, and are committed to employing a team that has diverse skills, experiences and abilities.

If you have any queries about this role, please email us at recruitment@niot.org.uk

For more information and to apply, please visit our vacancies page.

Closing date: 10:00am on Monday, 1st June 2026.

Please note, we reserve the right to close this vacancy early if we receive a high volume of applications.

This post requires a satisfactory enhanced disclosure from the Disclosure and Barring Service (DBS) with a Children’s Barred List Check and Occupational Health Check is required as a condition of employment.

Senior Data Engineer The National Institute of Teaching (NIoT) employer: Society of Research Software Engineering

The National Institute of Teaching (NIoT) is an exceptional employer dedicated to fostering a supportive and innovative work environment for its employees. With generous annual leave, flexible working arrangements, and a strong commitment to professional development, NIOT empowers its team to thrive while contributing to meaningful improvements in teacher education. Located within commuting distance of vibrant London campuses, employees benefit from a collaborative culture that values diverse experiences and skills, making it an ideal place for those passionate about enhancing the education sector.

Society of Research Software Engineering

Contact Details:

Society of Research Software Engineering Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Data Engineer The National Institute of Teaching (NIoT)

Tip Number 1

Network like a pro! Reach out to current or former employees at NIoT on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.

Tip Number 2

Prepare for the interview by brushing up on your Azure skills. Make sure you can talk confidently about data pipelines and T-SQL. We want to see that you’re not just a fit on paper but also in practice!

Tip Number 3

Show your passion for education! Be ready to discuss how your data engineering skills can improve teacher development. We love candidates who align with our mission and values.

Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re serious about joining our team at NIoT.

We think you need these skills to ace Senior Data Engineer The National Institute of Teaching (NIoT)

Data Engineering
Azure Data Factory
Azure SQL Server
T-SQL
Schema Design
Stored Procedures
Query Optimisation

Some tips for your application 🫡

Tailor Your Application:Make sure to customise your CV and cover letter to highlight your experience with Azure Data Factory and T-SQL. We want to see how your skills align with the role, so don’t hold back on showcasing your relevant projects!

Show Your Passion for Education:Since we’re all about improving teacher development, let us know why you’re interested in this mission. Share any experiences or insights that connect your data engineering skills to the education sector – it’ll make your application stand out!

Be Clear and Concise:When writing your application, keep it straightforward and to the point. Use bullet points where possible to make it easy for us to read through your qualifications and experiences. We appreciate clarity!

Apply Through Our Website:Don’t forget to submit your application via our vacancies page! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy to do!

How to prepare for a job interview at Society of Research Software Engineering

Know Your Data Engineering Stuff

Make sure you brush up on your data engineering skills, especially with Azure Data Factory and SQL Server. Be ready to discuss your experience in building production-grade data pipelines and how you've implemented validation and monitoring controls.

Show Your Problem-Solving Skills

Prepare to share specific examples of how you've tackled complex data challenges in the past. Think about times when you had to optimise queries or handle sensitive data securely, as these are key aspects of the role.

Understand the NIoT Mission

Familiarise yourself with the National Institute of Teaching's mission and values. Be prepared to explain how your work aligns with their commitment to high-quality, evidence-informed teacher education and how you can contribute to their Teacher Education Dataset initiative.

Communicate Effectively

Since you'll be working in a multidisciplinary team, practice articulating your thoughts clearly. Think about how you can convey technical concepts to non-technical colleagues and demonstrate your ability to collaborate effectively.