Senior Data Engineer / Architect (Legal Tech)
Location: London / RemotePosition Type: Full-time, Permanent
About Our ClientOur client is a globally operational professional services organisation dedicated to delivering top-tier strategic, advisory, and technological solutions to a prestigious international clientele. As they continue to modernise their global data infrastructure, they are seeking a visionary and execution-focused Senior Data Engineer / Architect with a specialised background in the legal sector to drive their enterprise data strategy.
Position Overview
In this pivotal role, you will bridge the gap between enterprise data architecture and legal tech execution. You will be responsible for designing, building, and optimising a scalable global data estate that integrates critical legal practice management systems with cutting‑edge analytics platforms. The role requires deep expertise in Aderant (expert-level understanding of its underlying data structures and schemas) and a proven track record of architecting modern, cloud‑native data solutions using Microsoft Fabric.
Key Responsibilities
- Architect, build, and maintain the global data infrastructure, transitioning legacy data warehouses into a modern, unified data lakehouse environment using MS Fabric.
- Serve as the subject matter expert for Aderant data structures and design and implement robust ETL/ELT pipelines to extract, transform, and load data from Aderant Expert/Sierra and other legal tech systems (e.g., iManage, Intapp) into the central data ecosystem.
- Design high‑performance relational and dimensional data models tailored for legal metrics (e.g., lockup, realisation rates, WIP, billable hours, and utilisation) while ensuring strict data governance, security, and compliance across global jurisdictions.
- Partner with Business Intelligence (BI) teams to deliver clean, curated, and near‑real‑time data products, enabling advanced reporting and AI‑driven insights via Power BI.
- Act as a technical liaison between global legal operations, finance teams, and IT leadership to translate complex business requirements into scalable technical solutions.
Required Experience & Qualifications
- Minimum of 5+ years of data engineering or architecture experience specifically within the legal sector (top‑tier law firms or legal professional services firms).
- Deep, hands‑on experience navigating and querying the Aderant database schema, with a thorough understanding of how legal financial data, time‑keeping, and billing workflows map to the back‑end tables.
- Proven experience working within the MS Fabric ecosystem (OneLake, Data Factory, Synapse Data Engineering/Data Science, and Real‑Time Analytics).
- High proficiency in advanced SQL, Python/PySpark, and data lakehouse architectures (Delta Lake).
- Strong understanding of Microsoft Azure data services (Azure Data Factory, Azure Synapse, Azure SQL, Key Vault) as they relate to Fabric integrations.
- Strong familiarity with legal operations terminology and financial metrics (KPIs for partners, practice groups, and matter management).
Preferred Qualifications
- Certifications such as Microsoft Certified: Azure Data Engineer Associate or Fabric Analytics Engineer Associate.
- Experience migrating on‑premise Aderant environments to cloud‑based setups (Aderant Expert Sierra).
- Familiarity with international data privacy laws (GDPR, UK DPA 2018) within a legal framework.
What We Offer
- Exposure to cutting‑edge AI and data analytics tools within the Microsoft ecosystem.
- Highly competitive compensation package.
- Flexible working arrangements (Hybrid/Remote).
- Clear paths for executive‑level career progression.
#J-18808-Ljbffr…