Data Automation Engineer

Salary: £31,000 - 59,000 per year

Requirements:

• 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.
• 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.
• 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.

Responsibilities:

• 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.
• Monitor and support production data platforms, integrations and automation services.
• Take on additional responsibilities when requested by the line manager.

Technologies:

• Agentic AI
• AI
• AI Agents
• Azure
• CI/CD
• Cloud
• Copilot
• DevOps
• ETL
• Fabric
• Support
• Machine Learning
• Power BI
• SQL

More:

We are Birketts, 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. Our Data Systems Team sits within our wider IT Business Solutions function and supports our modern Microsoft-based data and application technology stack, including Microsoft Fabric, Azure services, APIs and reusable automation frameworks. We offer hybrid working with a 60% office and 40% home working split, and we welcome flexible, agile and part-time working patterns. Our benefits include 25 days holiday plus Bank Holidays, private healthcare, pension, bonus schemes, life assurance, enhanced family leave, subsidised gym membership, an electric car scheme and more. We are committed to an inclusive culture, equal opportunity and continuous development for our colleagues.

last updated 35 week of 2026