Data Engineer
Ambition Institute
·Today
- Salary
- £53k+/yr
- Location
- London, London, GB
- Workplace
- Hybrid
- Type
- Full-time
- Department
- Engineering
- Closing date
- Today
- Source
- Pinpoint
Description
Data Engineer
Application Deadline: 29 November 2026
Department: Data & Insight
Employment Type: Permanent - Full Time
Location: London
Reporting To: Head of Data and Data Science
Compensation: £53,000 / year
Description
This is a chance to use your technical expertise in a role with real purpose. Alongside building automated workflows and improving data quality, you’ll help shape the future of data engineering at Ambition Institute by strengthening standards, improving ways of working and creating more efficient, scalable solutions. You’ll also have the opportunity to grow as a technical leader, taking greater ownership of engineering decisions and helping build the data capability that supports our mission to help educators serving children from disadvantaged backgrounds to keep getting better.
Who are Ambition Institute?
- We train teachers and leaders at all levels to get better at the things that make the biggest difference: what you teach, how you teach it, and how you create the conditions for schools to thrive.
- We share what works. Everyone can benefit from evidence of how great teaching and leadership can improve schools and change lives, so we connect people to the latest research and best practice.
- We champion every teacher and school leader’s potential to develop, as the driving force for sustainable school improvement.
We would like you to:
- Build and maintain reliable data pipelines and platforms using Python, SQL and cloud technologies to ingest, transform, consolidate and deliver data efficiently, with strong monitoring, automation and fault handling.
- Design scalable data architecture and models that bring together data from multiple systems into trusted, well-structured assets for reporting, analytics, statistical modelling and machine learning.
- Apply strong engineering standards and platform integration practices through CI/CD, version control, orchestration, documentation and secure integrations across cloud services, databases, APIs and operational systems.
- Lead on data quality, security and technical direction by improving governance, protecting sensitive data, solving complex technical problems and supporting longer-term development across the Data and Insights function.
Working in a hybrid way, you’ll be attached to either our Birmingham, London or Manchester office and will report to Head of Data and Data Science. In line with our current ways of working, you’ll be expected to be in the office at least 1 day a month, in addition to team days and this may be reviewed by Ambition.
Skills, Knowledge and Experience
They will also demonstrate the following qualifications, knowledge, skills and experience:
Essential
- A minimum of five years of demonstrable professional experience in data engineering or closely related technical roles, with substantial hands-on responsibility for designing, building and maintaining production data systems.
- Demonstrable experience working with multiple data platforms, technologies and source systems.
- Proven experience designing and maintaining production-grade data pipelines and automated data workflows.
- Advanced proficiency in Python, including developing production-quality applications, data processing pipelines, automation scripts and reusable software components.
- Advanced proficiency in SQL, including complex queries, joins, common table expressions, window functions, stored procedures where appropriate, and query optimisation.
- Demonstrable experience optimising database performance, data transformations and large-scale processing workflows.
- Strong understanding of Python libraries and frameworks commonly used in data engineering.
- Strong practical knowledge of relational data modelling, dimensional modelling and database schema design.
- Demonstrable experience designing and implementing data models that support analytics, reporting and operational requirements.
- Experience consolidating fragmented datasets and establishing consistent data structures across multiple source systems.
- Ability to make informed architectural decisions based on scalability, maintainability, performance, security and cost.
- Experience integrating data across multiple systems using APIs, database connections and other ingestion methods.
- Strong practical experience working in Linux/UNIX environments.
- Experience configuring and working with virtual machines and remote computing environments.
- Understanding of secure networking, authentication and access management, including networking tools such as Tailscale or equivalent technologies.
- Ability to troubleshoot infrastructure, connectivity and data processing issues.
- Strong working knowledge of Git and collaborative version-control practices.
- Experience implementing automated testing and validation processes.
- Understanding of deployment automation, environment management and release processes.
- Experience with workflow orchestration and scheduling technologies.
- Familiarity with containerisation technologies such as Docker or equivalent approaches.
- Strong commitment to coding standards, documentation, reproducibility and maintainable engineering practices.
- Experience implementing automated data quality checks, validation processes and monitoring.
- Strong understanding of data integrity, consistency, reconciliation and data lineage.
- Experience working with sensitive or confidential data in secure environments.
- Understanding of data protection principles, including UK GDPR.
- Ability to incorporate security, privacy and governance considerations into technical designs.
- Experience developing or contributing to data governance frameworks, data catalogues or metadata management processes.
- Experience supporting analytics, business intelligence, statistical modelling or machine learning workloads.
- Experience leading teams and ability to jump from operations to strategy.
- Experience working in the education, public, charity or not-for-profit sectors.
- Experience contributing to technology roadmaps, architectural standards or wider data strategy.
What’s in it for you….?
- Competitive annual salary
- Professional development for all staff
- 25 days’ annual leave, plus bank holidays and 'winter shut down’ at the end of December/beginning of January
- Employer pension contribution of 11%
- Agile, hybrid working culture, so you can manage when and where you work
- Staff affinity networks that help keep equality, diversity and inclusion at the heart of our work
- Blind recruitment process to ensure equality and fairness in our hiring
- Enhanced maternity pay after a year’s service
- Shared parental leave package
- Access to free, confidential 24/7 wellbeing and support line
- Comfortable and collaborative workspaces in the city centres of Manchester, Birmingham and London
- Work-from-home technology package to support hybrid working
- Interest free season ticket / bike loans
- You care deeply about educational disadvantage and being part of an organisation that challenges inequality
- You have a good work ethic and strive to make a difference in the job you do
- You always give maximum effort to understand and meet the needs of our partners and participants
- You always have a great attitude so we “can do” for all our colleagues, partners and participants
- You are open to feedback and learning because we want to keep getting better
- You work with your initiative to bring new ideas and a fresh perspective
- You are well organised and can prioritise work that will have the greatest impact
- You want a career with a person-centred organisation with a cause at its heart.
- You have a collaborative work ethos, bring warmth and good humour to work and constructive outlook to every situation
- You enjoy working in a fast-moving workplace, with a great support structure around you
- You would like to grow with an ambitious organisation as it progresses over time
- Want flexibility in how you work – splitting your time between one of our offices and remote working and managing your own working patterns to get the job done.
All applications must be received by the closing date 11:59pm on 29 November 2026. First stage interviews are expected to take place w/c 14 December 2026. Second stage interviews are expected to take place w/c 4th January 2027.
Please note: As part of the interview process for this role, you will be required to complete a pre-interview task that you will be asked to present during your interview.
Ambition Institute is proud to be a Disability Confident Committed employer. We welcome applications from disabled people and, as part of our commitment, offer an interview to applicants who meet the minimum essential criteria for the role (although where we receive a particularly high number of applications through the scheme, we may not be able to interview everyone who meets the criteria). We are committed to making reasonable adjustments throughout our recruitment process and encourage you to let us know if there are any adjustments that would help you participate fully.