Our client is a growing, international, PE-backed professional services organisation.
This new role has been created to build and run the technical foundation of the company's data strategy. You’ll bring data from our source systems into their Lakehouse on Microsoft Fabric, process it through a medallion architecture, and deliver modelled, trusted data that’s ready for reporting, AI and machine learning.
You’d be working with Data Analysts on modelling, and with IT, Information Security and system owners on secure integration. It’s a small team and a genuine build role, which means real influence over the architecture, the tooling and the standards adopted.
As the data platform grows so will the role and there’s scope to move into advanced analytics, and AI-assisted tooling such as Fabric MCP, Fabric IQ, Copilot and data agents.
Key responsibilities:
- Building and maintaining scalable data pipelines, pulling data in from core business systems and third-party sources.
- Designing and developing data solutions with Python, PySpark, SQL, notebooks and dataflows across a modern medallion architecture
- Creating and optimising data models that power high-quality Power BI reporting and analytics.
- Putting data quality, validation and reconciliation processes in place so the numbers can be trusted.
- Monitoring, troubleshooting and keeping the platform fast, reliable and available.
- Configuring and supporting master data management and entity resolution, so data stays consistent across systems.
- Owning master data management approach defining golden records for clients, contacts and matters, setting matching, de-duplication and survivorship rules, and using entity resolution tooling such as Aptitude or Senzing to link records across systems.
- Owning source control, code reviews and CI/CD pipelines through Azure DevOps.
- Implementing secure, compliant data access role-based security, auditing and governance controls.
- Keeping technical documentation, data lineage and platform standards in good order.
- Helping shape where the platform goes next, including future analytics, AI and machine learning capability.
Required skills & experience:
- You’re an experienced Data Engineer who knows Microsoft Fabric and the Azure data stack well
- You’ve built, optimised and supported pipelines that people actually depend on.
- Python, PySpark and SQL are comfortable territory, and you’ve designed lakehouse architectures that hold up under real business intelligence workloads.
- You’re a proactive problem-solver who works methodically and delivers to a high standard, with data quality, security and platform reliability built into everything you do.
- You can talk to technical and non-technical colleagues just as easily, and you enjoy an environment where collaboration, ownership and continuous improvement genuinely matter.
Advantageous:
Experience with master data management, data governance, Azure security or real-time data solutions would be a real bonus, as would professional or financial services industry experience.
Although this is a remote role, candidates must be UK-based and be able to work in the UK on a long-term basis without visa sponsorship. Candidates must be prepared to visit the office monthly.
Data Engineer (Fabric, SQL, Python), Professional Services industry, fully remote employer: Ethos BeathChapman
As a premier international law firm, we offer an exceptional work environment that fosters collaboration and innovation within our Asia-Pacific Disputes & International Arbitration practice. Our commitment to employee growth is evident through comprehensive training programmes and opportunities to work alongside industry leaders on high-stakes cases. Located in London, our firm not only provides competitive benefits but also promotes a vibrant work culture that values diversity and encourages professional development.
