We are seeking a skilled Data Engineer to join the growing team behind MATpad, 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 using Azure Data Factory, managing complex SQL 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 robust ETL/ELT pipelines using Azure Data Factory and related services.
* Develop and optimize SQL-based data models, stored procedures, and scripts for performance and scalability.
* Build and manage data warehouses using Azure 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 in T-SQL and relational database concepts.
* Proven experience with Azure Data Factory, Azure SQL Database, and Synapse Analytics.
* Experience designing and managing data lakes and data warehouses.
* Understanding of data integration patterns, data modelling, and cloud-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 with Power BI or other BI tools.
* Knowledge of Databricks, Azure Functions, or Logic Apps.
* Understanding of DevOps practices in a data engineering context.