Boodle Hatfield LLP is a highly successful private capital and real estate focused law firm providing bespoke legal services to UHNW and HNW individuals, families, businesses and entrepreneurs for over 300 years. We serve the full spectrum of commercial and private clients, both domestically and internationally from our offices in London and Oxford.
Advising on the creation, management and protection of private capital and supporting the needs of private businesses is central to our firm. The interplay of skills between five major areas or practice – private wealth, real estate, corporate, litigation and family means that we are well placed to serve these individuals and businesses.
We have always taken a long-term view on strategy - our success and reputation is a result of the deep and lasting relationships we have built with all of the businesses and families we have acted for over the years. We are the long-term trusted adviser to leading wealth creators and owners as well as their commercial and investment enterprises.
Having a holistic view of our clients' structures and affairs means we can leverage this to provide the most appropriate personal and commercial advice to them. This enables us to help them successfully navigate the continually changing and sometimes challenging markets in which they operate.
The immediate priority is to build and develop the Firm’s Microsoft Fabric data platform, deliver trusted Power BI reporting and semantic models, and integrate core systems through SQL, APIs, OData and JSON. Once these foundations are established, the role will progressively contribute to Power Platform automation, AI and wider application enablement. This is primarily a data and platform engineering role, not a broad application-support position.
Initial focus:
- 70% Microsoft Fabric, data engineering and BI
- 20% systems integration
- 10% automation and emerging capability
Initial priorities
- Build and develop Microsoft Fabric. Create reliable pipelines, Lakehouse’s, Warehouses, curated data layers, monitoring, governance and documentation.
- Deliver trusted Power BI data products. Develop reusable semantic models, reports, DAX and paginated reporting that improve decision-making.
- Integrate core systems. Create robust, monitored integrations for Elite 3E, IntApp and other systems using SQL, REST APIs, OData and JSON, with reconciliation and error handling.
Responsibilities
Microsoft Fabric, data engineering and BI
- Build and optimise Fabric pipelines, notebooks, Lakehouses and Warehouses.
- Design curated data layers, dimensional models, semantic models and governed datasets.
- Develop Power BI reports, DAX measures and paginated reports with reliable refresh and deployment.
- Improve SQL performance, orchestration, data quality, lineage, documentation and Fabric capacity use.
- Support the modernisation of legacy SQL Server, SSRS and integration workloads.
Integration, automation and AI
- Integrate Elite 3E, IntApp, databases, files and REST/OData services, including authentication, pagination, monitoring and reconciliation.
- Develop maintainable Power Automate workflows and focused Power Apps once the core data foundations are established.
- Assess practical Microsoft 365 Copilot, Copilot Studio, AI Builder, Azure AI and Fabric AI use cases, considering value, accuracy, privacy, security and supportability.
- Create and troubleshoot JSON payloads and validate APIs using Postman or equivalent tools.
Delivery and operational enablement
- Work with the Business Systems team on the data, integration and automation components of key applications.
- Translate requirements into designs and acceptance criteria; deliver through development, testing, release and early-life support.
- Apply secure design, least privilege, auditability, retention, data loss prevention and change control.
- Maintain technical documentation, runbooks, data dictionaries and release notes; communicate progress, risks and decisions clearly.
Essential skills and experience
- Strong SQL, relational and dimensional modelling, and data-warehousing experience.
- Hands-on Microsoft Fabric experience, or strong Microsoft/Azure data-platform experience with evidence of being able to transition quickly into Fabric.
- Experience building reliable, validated and monitored data pipelines and integrations.
- Strong Power BI experience, including semantic models, reports, refresh and DAX.
- Practical REST, OData, JSON, HTTP and authentication knowledge.
- Ability to translate business needs into maintainable solutions and troubleshoot production issues methodically.
- Clear communication, documentation and stakeholder-management skills.
Experience that can be developed in the role
- Deeper Power Platform development, including Power Apps, Dataverse, custom connectors and application lifecycle management.
- Microsoft 365 Copilot, Copilot Studio, AI Builder, Azure AI and Fabric AI.
- Elite 3E, Elite Data Insights, IntApp and legal/professional-services processes.
- Purview, lineage, sensitivity labels, data loss prevention, Azure DevOps/Git and automated deployment.
Desirable
- Fabric architecture, Delta/Parquet, Spark SQL or PySpark, Data Factory and capacity monitoring.
- Power Automate delivery experience; Power Apps is advantageous but not required at specialist level.
- SQL Server/SSRS modernisation or legal/professional-services experience.
- Relevant Microsoft data, Power BI, Azure or Power Platform certification, or equivalent practical experience.
The candidate
Collaborative, service-focused and keen to learn, with the judgement to balance innovation and pace with stability, security and supportability. Organised and analytical, the successful candidate will take ownership, communicate clearly and build trusted relationships across technical and business teams.
Boodle Hatfield is committed to providing equal opportunities in employment through its inclusive and supportive environment. This means that everyone who either applies to or works for the Firm is treated equally, whatever their gender, age, ethnic origin, nationality, marital status, disability, sexual orientation or religious beliefs. We are fully committed to a working environment in which all people can excel.
Data and Automation Engineer in London employer: Boodle Hatfield
Boodle Hatfield is an exceptional employer, offering a prestigious opportunity for qualified solicitors to advance their careers in Property law within a collaborative and supportive team environment in London. With over 300 years of experience, the firm provides excellent training and growth opportunities, allowing employees to work with a diverse client base on high-quality commercial property matters while fostering professional development and building valuable networks.