Data Automation Engineer

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. RollOnFriday 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 team you will join

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 work you will be doing

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.

What we are looking for

Essential skills and experience:

• 4-6 years' experience in Data Engineering, Integration Engineering, Automation Engineering or a similar role.
• Strong SQL Server and T-SQL skills.
• Experience developing ETL/ELT processes and data pipelines.
• Experience with APIs, integrations and data exchange technologies.
• Experience using Microsoft Azure services.
• Experience with Microsoft Fabric or similar cloud data platforms.
• Good understanding of cloud-based data solutions.
• Strong troubleshooting and analytical skills.
• Experience supporting production systems and business-critical services.

Desirable skills and experience:

• Microsoft Fabric platform architecture and governance.
• Cloud data platform design and strategic architecture.
• AI Agents, Microsoft Copilot Studio and agentic AI solutions.
• Azure AI and Machine Learning technologies.
• Working closely with AI-focused delivery teams and AI initiatives.
• Coaching and mentoring junior engineers.
• Data platform strategy and enterprise data architecture.
• Power BI development and analytics platforms.
• Azure DevOps, CI/CD and Infrastructure-as-Code practices.

Key attributes:

• Passionate about automation and continuous improvement.
• Strong attention to detail and a structured approach to problem solving.
• Able to balance project delivery with support responsibilities.
• Self-motivated, proactive and comfortable taking ownership.
• Excellent communication and stakeholder engagement skills.
• Collaborative approach, with the ability to work effectively across IT and the wider business.

Hybrid Working

Birketts is a flexible business which has embraced a hybrid working model where our colleagues enjoy a mix of home and office working. This role attracts a split of 60% office days and 40% working from home days per week.

We welcome applications from people looking for flexible, agile, and part-time roles and we are happy to explore your preferred working patterns as part of your application.

Benefits

As a Birketts colleague, you will be eligible to receive a wide range of benefits: