Senior Data Engineer - Microsoft Fabric & Azure

Job description

**Location:** Hybrid **Division:** Engineering **Reports to:** Chief Architect - Data and Insights **ABOUT US**  Agilisys is at the forefront of digital transformation and innovation in the public services sector. With over two decades of experience, we have established ourselves as a trusted partner for governments, local authorities, and organizations nationwide. Our mission is to empower our clients to deliver exceptional public services by harnessing the full potential of technology and data.  **OUR VALUES**  **Partnership:**we become one team and family with organisations, helping them to navigate change and stay agile.  **Integrity:**our people really care, going beyond the brief to make change happen for organisations and citizens.  **Innovation:** we bring together the right technologies and services to design solutions that work.  **Passion:**we are passionate about - and dedicated to - public services and improving people’s lives.    **THE ROLE** The Senior Data Engineer – Microsoft Fabric & Azure is a senior, hands-on role within Agilisys’ Data & AI Practice. You will take engineering ownership of modern data-platform workstreams from approved design through build, testing, production deployment and handover, with Microsoft Fabric and the Azure Data Platform at the core. Working closely with architects, analysts, delivery teams and client stakeholders, you will help turn architecture into secure, scalable and supportable solutions. You will also contribute to engineering standards, mentor other engineers and help clients move from proof-of-value or legacy data platforms to production-grade services. **KEY RESPONSIBILITIES** - **Deliver Fabric and Azure data platforms end to end:** Build and productionise Microsoft Fabric solutions using OneLake, Lakehouses, Warehouses, Data Pipelines, Notebooks, Dataflows and Azure Data Factory, including integration with legacy, cloud and on-premises data sources. - **Engineer reliable data pipelines and models:** Design batch, incremental and near-real-time ETL/ELT using SQL, Python and PySpark; apply medallion, dimensional/Kimball, normalised and data-product patterns as appropriate; and use production-grade techniques such as CDC, SCD, schema-change handling, idempotency, retry/replay, backfill and source-to-target reconciliation. - **Own Dev/Test/Production delivery and CI/CD:** Configure Fabric workspace structures and environment-specific settings, and implement controlled promotion using Git, Azure DevOps/GitHub, Fabric Deployment Pipelines, APIs or controlled manual steps where Fabric item limitations require them. Apply branch protection, peer review, testing, approvals, rollback and release evidence. - **Build for security, governance and compliance:** Implement secure-by-design controls using Microsoft Entra ID, RBAC, Fabric workspace/item/data permissions, managed identities or service principals, encryption and appropriate network controls. Work with architects and governance specialists on Fabric-native governance and Microsoft Purview requirements where these are in project scope. - **Optimise, monitor and troubleshoot production workloads:** Tune SQL, Spark, Delta/Parquet storage, partitioning and compute for performance, cost and reliability. Establish monitoring and alerting for pipelines, notebooks, semantic-model refreshes, data freshness and Fabric capacity, and diagnose failures, data-quality issues and performance problems during delivery and hypercare. - **Support Power BI and data consumption:** Work effectively with data analysts for Power BI semantic models and reporting solutions, including Direct Lake and Import concepts, refresh, RLS/OLS, performance and deployment considerations, and enable governed consumption through semantic models, SQL endpoints, data products and APIs where required. - **Lead engineering delivery and handover:** Own assigned engineering workstreams, collaborate with stakeholders, mentor engineers, contribute to design and engineering standards, and produce clear technical documentation including implementation details, HLD/LLD contributions, operational runbooks and knowledge-transfer materials for client and support teams. **ESSENTIAL TECHNICAL EXPERIENCE** You will have a strong track record of hands-on data engineering delivery, with the technical depth to work independently and the communication skills to operate confidently with technical and business stakeholders. - 5+ years’ commercial data engineering experience, including experience operating at Senior Data Engineer level, with strong recent hands-on Microsoft Fabric delivery experience (ideally 18–24+ months) and demonstrable delivery of at least one production-grade Fabric implementation. - Strong Microsoft Fabric experience across OneLake, Lakehouse, Warehouse, Data Pipelines, Notebooks and Dev/Test/Production workspace patterns. - Advanced SQL, Python and PySpark, with practical experience of Delta/Parquet, medallion architecture and production-grade batch/incremental ETL/ELT. - Strong Git and CI/CD experience using Azure DevOps and/or GitHub, including controlled release, testing, deployment, rollback and environment promotion practices. - Good Azure data-platform experience, including Azure Data Factory and secure cloud/on-premises connectivity using gateway, managed private endpoint or related network patterns where required. - Working knowledge of Power BI semantic-model integration, Direct Lake/Import concepts, refresh, RLS/OLS, performance and deployment. - Practical experience of Microsoft Entra ID, RBAC, managed identities/service principals, secure engineering, data quality, testing, troubleshooting, operational documentation and runbooks. - Strong stakeholder management, mentoring and communication skills, with the ability to work in fast-moving multidisciplinary teams and contribute constructively to architecture and engineering decisions. - Experience of public-sector, local-government or other regulated environments is strongly valued. You must hold active Security Clearance or be eligible and willing to undertake BPSS/security clearance appropriate to client requirements. **DESIRABLE EXPERIENCE & CERTIFICATION**