Skip to Main Content
Location icon
London

Data and Automation Engineer

Boodle Hatfield
Office & Professional
Office & Professional
Company logo image
Description

Location
London

Hours
Full Time

Salary
Negotiable

About the Role
Boodle Hatfield LLP is a highly successful private capital and real estate focused law firm with over 300 years of history, providing bespoke legal services to UHNW and HNW individuals, families, businesses and entrepreneurs. The firm operates from offices in London and Oxford, advising on private capital creation, management and protection, and supporting private businesses across multiple practice areas including private wealth, real estate, corporate, litigation and family.

The immediate priority for this role 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 including pipelines, Lakehouses, Warehouses, curated data layers, monitoring, governance and documentation. Deliver trusted Power BI data products by developing reusable semantic models, reports, DAX and paginated reporting to improve decision-making. Integrate core systems such as Elite 3E and IntApp using SQL, REST APIs, OData and JSON with reconciliation and error handling.

Requirements

Experience
- Strong SQL, relational and dimensional modelling, and data-warehousing experience
- Hands-on Microsoft Fabric experience or strong Microsoft/Azure data-platform experience with ability 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 knowledge of REST, OData, JSON, HTTP and authentication
- Ability to translate business needs into maintainable solutions and troubleshoot production issues methodically
- Clear communication, documentation and stakeholder-management skills

About you
Collaborative, service-focused and keen to learn, with the judgement to balance innovation and pace with stability, security and supportability. Organised and analytical, able to take ownership, communicate clearly and build trusted relationships across technical and business teams.

Qualifications
Relevant Microsoft data, Power BI, Azure or Power Platform certification or equivalent practical experience is desirable but not essential.

Additional skills that can be developed in the role
- 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 advantageous but not required at specialist level
- SQL Server/SSRS modernisation or legal/professional-services experience

Expiry date: 20/12/2026
Data and Automation Engineer
Company:
Boodle Hatfield
Job Type:
Full-time
Location:
London