Data Engineer

We are seeking an experienced, skilled and motivated Fabric Data Engineer to join our growing Data & Insight team within a leading law firm. This role will play a critical part in designing, building, and maintaining modern data solutions using Microsoft Fabric, supporting firm-wide analytics, reporting, and data-driven decision-making. You will work closely with the Firm’s data architect, data analysts, business stakeholders, reporting teams and other IT teams to deliver robust, scalable data pipelines and models, ensuring high levels of data quality, governance, and performance in a regulated legal environment. The data team are evolving beyond our traditional role as a reporting function to become a strategic enabler of data across the firm. This next phase focuses on leveraging data more broadly to inform decision-making, drive business insight, and empower teams with greater autonomy. As part of this transformation, we are building capability to ensure data is not only accessible but actively supports the Firm’s strategic objectives and day-to-day operations. This is an excellent opportunity for a mid-level engineer with hands-on Fabric experience looking to expand their impact in a professional services setting. Key Responsibilities Design, develop, and maintain data pipelines and workflows in Microsoft Fabric (including Data Factory, Notebook, Lakehouse, and Warehouse components) Migrate existing on premise and cloud based data architecture into modern Fabric equivalents to remediate technical debt Build and optimise data models to support reporting and analytics use cases across legal, finance, people and other operational domains Integrate data from a variety of sources (case management systems, finance systems, CRM platforms and other legal tools) Implement ELT/ETL processes ensuring data quality, consistency, and performance through all medallion architecture layers Collaborate with data analysts and business stakeholders to translate requirements into scalable data solutions Collaborate with data architects to ensure solution scalability and technological appropriateness. Apply modern CI/CD techniques to data product delivery Support and enhance the firm’s enterprise data architecture ambitions Monitor and troubleshoot pipeline performance, data issues, and system reliability Apply best practices in data governance, security, and compliance, particularly in relation to sensitive legal data Contribute to documentation, standards, and continuous improvement of the data platform Stay up to date with Microsoft Fabric capabilities and recommend enhancements where appropriate Skills, Knowledge and Expertise Essential Hands-on experience with Microsoft Fabric (Data Factory, Lakehouse, Warehouse, Power BI integration, Notebooks) Proven experience in a data engineering role (typically 2–5 years) Strong SQL skills and experience working with relational and analytical data models Experience building and maintaining data pipelines / ETL or ELT workflows Familiarity with Azure data services and cloud-based architectures Understanding of data governance, data quality, and security principles Strong problem-solving skills and attention to detail Ability to communicate effectively with both technical and non-technical stakeholders Desirable Experience with Python (PySpark) and SQL in Microsoft Fabric notebooks Experience with CI/CD for data pipelines Experience working in a law firm or professional services environment Knowledge of legal systems (e.g. Intapp, Elite 3E, VisualFiles) Understanding of data privacy regulations (e.g. GDPR) Agile, practical and flexible approach to delivery Additional Information As a Disability Confident Scheme employer, we’re committed to providing an inclusive and accessible recruitment process. If you need any reasonable adjustments at any stage (including the application, assessment or interview process), please contact [email protected] in confidence with the vacancy reference in the subject line, and we’ll be happy to help.