Overview
As a Data Automation Engineer, you design, develop and maintain automated data processes across on-premises and cloud platforms to boost operational efficiency. You will work within the Data Systems Team to deliver integrated data pipelines, automation frameworks and reliable data movement using a modern Microsoft stack. You’ll collaborate with IT and business units to standardise automation, monitor production services and support critical workflows. This is a hands-on role with a strong focus on speed, quality and scalable data solutions. You’ll contribute to Birketts’ data-driven strategy and hybrid working culture.
Pay / Benefits
- 25 days holiday (FTE) plus bank holidays
- Long service holiday award – 1 extra week every 10 years
- Private healthcare with BUPA
- Scottish Widows pension scheme (employer/employee contributions)
- Staff Profit Share and Individual Performance Bonus
- Life assurance 4x salary / Permanent Health Insurance (PHI)
Responsibilities
- Design, develop and maintain automated data integrations between business applications
- Build, optimise ETL/ELT processes and data pipelines
- Develop automation solutions using APIs, scheduled events and event-driven workflows
- Monitor, troubleshoot and optimise data automation processes for reliable delivery
- Work with Microsoft Fabric and Data Factory to enable data movement across cloud and on-premises
- Create reusable automation frameworks and standards for repeatable delivery
- Identify opportunities to automate manual processes and improve efficiency
- Provide 3rd line support for automation and integration incidents
- Document technical procedures and support notes
- Collaborate with IT and business teams to deliver sustainable data automation solutions
- Monitor production data platforms, integrations and automation services
- Be prepared for additional duties as needed by line managers
Key requirements
- 4–6 years in Data Engineering, Integration Engineering or Automation Engineering
- 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
- Excellent communication and stakeholder engagement
- Collaborative working style across IT and business units
- Strong attention to detail and structured problem-solving
- SQL Server, T-SQL
- ETL/ELT design and data pipelines
- APIs and data exchange technologies
Data Automation Engineer in Cambridge employer: Birketts
Birketts is an exceptional employer, offering a dynamic work environment that fosters innovation and collaboration across its offices in Ipswich, Norwich, Cambridge, Chelmsford, Bristol, and Sevenoaks. With a strong commitment to employee development, a flexible hybrid working model, and a culture that prioritises inclusivity and community impact, we empower our team members to thrive while contributing to meaningful legal solutions. Our comprehensive benefits package, including private healthcare, generous holiday allowances, and performance bonuses, further enhances the rewarding experience of being part of our esteemed law firm.
