We have implemented a modern cloud-based analytics tech stack, bringing together data from our various systems into a data warehouse platform which will provide real-time accurate and critical insights and analytics for the business.  

This is where you come in. As a Data Engineer, you will be part of the team that is responsible for the development and operation of the data warehouse stack and data quality, integrating additional data sources and providing processed data for consumption, BI and reporting.  

This is a key role in the business that will enable us to make data-driven decisions that will support innovation and continuous sustainable growth. The role requires someone with strong data mindset, ideally with experience of working with complex data sets. You will work with our current Data Engineer to provide reliable, accurate and timely data, and ensure the growth and accuracy of the data warehouse and its information. 

Requirements

• Thrive in a fast paced and dynamic environment  
• Exceptional SQL skills including an appreciation for performance tuning on a variety of database engines 
• Data pipeline development experience in Python (especially using pandas, parsing API responses, posting data to API’s etc.) 
• Excellent analytical and problem-solving skills 
• An appreciation for the big picture while delivering short/mid-term solutions 
• Experience of building data warehouses, enterprise data warehouses or data lakes with ETL pipelines  
• Experience with AWS tools including Glue, Lambda, S3, RDS, is preferred 
• An understanding of CICD concepts including having a working knowledge of GitHub 
• Understanding of different data warehouse architectures is preferred (especially dimensional modelling and data vault 2.0 architectures)  

Key Responsibilities:

• Build and maintain scalable data pipelines written in Python and SQL and ran on AWS/Snowflake 
• Taking ownership of data quality within projects 
• Managing and educating a range of stakeholders when gathering requirements and delivering data projects 
• Building effective and collaborative relationships with technical and non-technical colleagues  
• Reacting to change within the business in a positive and constructive way 
• Documenting processes and data pipelines 
• Maintaining a backlog of future improvements/features in Jira 

Benefits

• Hybrid working, with regular collaboration days in our Sheffield HQ 
• Opportunity to work at an established but rapidly growing EdTech scaleup 
• NEST Pensions scheme 
• Buy & Sell Holiday scheme offering an opportunity to boost holiday allowance to up to 38 days annually 
• Access to company Life Assurance scheme  
• SmartHealth - access to 24/7 virtual GP, mental health support, financial advice and more 

Who are The National College 

The National College are a fast growing and innovative EdTech business headquartered in Sheffield. We are a market-leading and multi-award-winning provider of professional development and software tools that support over 45,000 schools worldwide to ensure compliance and drive up standards. Our cutting-edge platform has revolutionised online training and now boasts the world's largest professional development library for educators!  

The National College is part of the National Education Group.