Data Engineer

We are seeking a skilledData Engineerto join the growing team behindMATpad, our flagship EdTech data platform developed for Multi-Academy Trusts (MATs), local authorities, and education providers. MATpad connects disparate data sources—including assessment, attendance, HR, finance, and safeguarding—and transforms them into meaningful insights through custom dashboards and printable reports.

In this role, you will play a pivotal part in expanding and optimising MATpad’s data architecture. You’ll be responsible for building and maintaining data pipelines usingAzure Data Factory, managing complexSQL data models.You'll work closely with our developers, school partners, and product team to ensure high-quality, timely data is available to support critical decision-making in education.

This is an exciting opportunity to contribute to a product that is actively improving the way school groups use data to support students, staff, and strategic operations.

Key Responsibilities

• Design and implement robustETL/ELT pipelinesusingAzure Data Factoryand related services.
• Develop and optimizeSQL-based data models, stored procedures, and scripts for performance and scalability.
• Build and managedata warehousesusingAzure Synapse Analytics.
• Collaborate with stakeholders to understand data requirements and translate them into technical specifications.
• Ensure data quality, governance, and compliance with security best practices.
• Monitor, troubleshoot, and improve data flows and pipeline performance.
• Participate in solution architecture reviews and recommend improvements for existing systems.
• Maintain thorough documentation of data processes and infrastructure.

Skills & Experience

Essential:

• Strong proficiency inT-SQLand relational database concepts.
• Proven experience withAzure Data Factory,Azure SQL Database, andSynapse Analytics.
• Experience designing and managingdata lakesanddata warehouses.
• Understanding ofdata integration patterns,data modelling, andcloud-based storage.
• Hands-on experience with version control (e.g., Git) and CI/CD pipelines for data solutions.
• Familiarity with performance tuning and monitoring of ETL pipelines.

Desirable:

• Experience withPower BIor other BI tools.
• Knowledge ofDatabricks,Azure Functions, orLogic Apps.
• Understanding ofDevOps practicesin a data engineering context.