Data Automation Engineer

Main information

Term type:

Permanent

Department:

Business Services

Location:

About us

Birketts is a full service, UK Top 50 law firm. With a heritage spanning 160 years, we have more than 700 lawyers and legal professionals and over 600 staff based in Bristol, Cambridge, Chelmsford, Ipswich, London, Norwich and Sevenoaks. We advise businesses, government and public sector organisations and individuals in the UK and internationally across four principal practice groups:
Real Estate, Corporate Services, Dispute Resolution and Private Client.

We are defined by our Next Level Law proposition. We work with our clients as a proactive partner, horizon scanning and thinking ahead to the changes, challenges or opportunities that they may face.

Next Level Law is also applied to our people. Our collegiate culture means everyone is encouraged to achieve their next level in everything they do. Roll On Friday  recently ranked us as the 6th best law firm to work at in 2026.

With our ambition to succeed, comes a strong desire to make a positive contribution to the communities we serve, and we are committed to delivering the objectives set out in our ESG strategy. Diversity plays an integral part in all that we do, with female partners comprising 45% of our partnership.

The role is based within the Data Systems Team, part of Birketts’ wider IT Business Solutions function. The team is responsible for delivering and supporting the firm’s data platforms, reporting solutions, integrations, automation capabilities and business-critical systems. Working closely with colleagues across the BI Squad and wider IT teams, the Data Automation Engineer will help design, develop and support automated data processes, integrations and data pipelines that improve operational efficiency, reduce manual effort and ensure reliable data movement across cloud and on-premises systems.

The role will contribute to the firm’s modern Microsoft-based data and application technology stack, including Microsoft Fabric, Azure services, APIs and reusable automation frameworks.

The Data Automation Engineer will design, develop and support automated data processes that improve operational efficiency, reduce manual effort and ensure reliable movement of data across business systems. The role will focus on integration, automation, data pipelines and process orchestration across on-premises and cloud-based platforms, helping the firm make better use of modern Microsoft-based data and integration technologies.

• Design, develop and maintain automated data integrations between business applications.
• Build, support and optimise ETL/ELT processes and automated data pipelines.
• Develop automation solutions using APIs, scheduled processes and event-driven workflows.
• Monitor, troubleshoot and optimise data automation processes, ensuring reliable service delivery.
• Design, develop and support data integration, orchestration and automation solutions using Microsoft Fabric, including Data Factory and related platform capabilities.
• Ensure reliable data movement between cloud and on-premises systems.
• Develop reusable automation frameworks, standards and repeatable delivery patterns.
• Identify opportunities to automate manual processes and improve operational efficiency.
• Provide 3rd Line support for automation and integration-related incidents.
• Support business-critical operational processes through automation, monitoring and clear escalation.
• Produce and maintain technical documentation, support notes and operational procedures.
• Work collaboratively with colleagues across IT and the business to deliver sustainable data automation solutions.
• Experience monitoring and supporting production data platforms, integrations and automation services.

Please note that this job profile is not an exhaustive list of duties but merely an outline of the key components of the role. You may be required by your line manager to take on additional responsibilities when requested.

Essential skills and experience:

• 4–6 years’ experience in Data Engineering, Integration Engineering, Automation Engineering or a similar role.
• Strong SQL Server…