Senior Data Engineer

About the role

Join IMP, a rapidly growing finance software company for Multi-Academy Trusts. As a Senior Data Engineer, you'll be instrumental in building our data platform, shaping the technical standards, and mentoring future team members. Enjoy a remote work environment with optional coworking days and a competitive salary of up to £70,000. Key missions: Design and implement data pipelines to ingest data from source systems into the data warehouse/lakehouse.. Build the centralised data model and the dbt transformation layer, ensuring version control, testing, and documentation.. Establish data quality validation, monitoring, and alerting, and implement row-level security for multi-tenant data. Profile: <p> <span> <strong> Job title: </strong> Senior Data Engineer </span> </p> <p> <span> <strong> Salary: </strong> up to £70,000 </span> </p> <p> <span> <strong> Reports to: </strong> Head of Data Engineering </span> </p> <p> <span> <strong> Location: </strong> Remote (UK), with optional coworking in Peterborough, Exeter, or Leeds </span> </p> <p> <span> <strong> The Opportunity </strong> </span> </p> <p> <span> IMP builds the finance software that Multi-Academy Trusts use to plan budgets, manage their money, and run procurement across their schools. Since 2019 we&#39;ve grown to around 550 trusts and 6,000 schools, roughly half the MAT market, with a 4.9/5 customer rating and fresh investment behind us. We hold one of the richest datasets on MAT finance in the sector, and we&#39;re building a data platform to unlock it: cross-trust benchmarking, AI-driven querying, and a new wave of analytics. </span> </p> <p> <span> You&#39;ll join right at the start as our first Data Engineer, building that platform hands-on alongside the Head of Data Engineering. You&#39;ll own the design and delivery of major components, set the technical patterns and quality bar early, and grow into mentoring as the team expands. The work you ship in the first year will be the foundation everything else is built on. </span> </p> <p> <span> <strong> The Work </strong> </span> </p> <p> <span> Working within the architecture set by the Head of Data Engineering, you&#39;ll: </span> </p> <ul><li> <p> <span> Help design and stand up the data warehouse / lakehouse, and build the pipelines that ingest data from our source systems into it. </span> </p> </li> </ul> <ul><li> <p> <span> Build the centralised data model and the dbt transformation layer, version-controlled, tested, and documented. </span> </p> </li> </ul> <ul><li> <p> <span> Build data quality validation, monitoring, and alerting, and implement row-level security for multi-tenant data. </span> </p> </li> </ul> <ul><li> <p> <span> Build and maintain the semantic / metrics layer: one governed definition of each metric, in parity with our agreed source of truth (ASOT), feeding Power BI, in-product reporting, and the AI layer alike. </span> </p> </li> </ul> <ul><li> <p> <span> Build the data foundations for our AI and intelligence layer, so &quot;chat with your data&quot; and proactively pushed insights are accurate and safe to surface to trusts inside the product. </span> </p> </li> </ul> <ul><li> <p> <span> Help drive platform and tooling decisions, and set the bar on engineering quality. </span> </p> </li> </ul> <p> <span> <strong> What You&#39;ll Need </strong> </span> </p> <p> <span> <strong> Essential </strong> </span> </p> <ul><li> <p> <span> Hands-on experience designing, building, and running data pipelines into a cloud warehouse or lakehouse in production. </span> </p> </li> </ul> <ul><li> <p> <span> Experience with a modern cloud data platform: Snowflake, Databricks, or similar. </span> </p> </li> </ul> <ul><li> <p> <span> Strong SQL and data modelling: dimensional modelling and slowly changing dimensions. </span> </p> </li> </ul> <ul><li> <p> <span> Solid experience with a modern transformation framework such as dbt (ideal), Matillion, or PySpark. </span> </p> </li> </ul> <ul><li> <p> <span> Experience extracting data from source databases, with bonus points for multi-tenant SaaS data or single-tenant to centralised migrations. </span> </p> </li> </ul> <ul><li> <p> <span> Strong judgment on data quality, and the ability to own technical decisions and explain the trade-offs. </span> </p> </li> </ul> <ul><li> <p> <span> Solid software engineering practices: version control with Git, CI/CD, and a disciplined software development lifecycle (SDLC). </span> </p> </li> </ul> <ul><li> <p> <span> Comfortable as a senior IC, setting standards and mentoring as the team grows, without needing formal line management to do it. </span> </p> </li> </ul> <p> <span> <strong> Nice to have </strong> </span> </p> <ul><li> <p> <span> Python for data engineering: pipelines, tooling, and automation. </span> </p> </li> </ul> <ul><li> <p> <span> AI-assisted engineering: comfortable using AI coding agents (e.g. Claude Code) to build and ship faster. </span> </p> </li> </ul> <ul><li> <p> <span> Some data science grounding (statistical or machine-learning methods) relevant to benchmarking and analytics. </span> </p> </li> </ul> <ul><li> <p> <span> AI/ML data patterns (LLM-ready data, text-to-SQL, RAG), and semantic / metrics layers (dbt metrics, </span> <a> <span> Cube.dev </span> </a> <span> , or similar). </span> </p> </li> </ul> <ul><li> <p> <span> Data governance, GDPR, or anonymisation; SQL Server background; experience in a SaaS or product company. </span> </p> </li> <li> <p> <span> Typically 5+ years in data engineering, with a track record of owning production pipelines and data models end to end. Depth of craft and judgment matter more than an exact number of years. </span> </p> </li> </ul> <p> <span> <strong> Working Here </strong> </span> </p> <p> <span> We use AI coding tools extensively, and the platform you build will be the foundation for IMP&#39;s AI features, so you should be excited about that direction. We&#39;re remote-first, collaborating over Teams with optional coworking d