At a Glance
- Tasks: Design and develop automated data processes to enhance operational efficiency.
- Company: Join Birketts, a top UK law firm with a collaborative culture.
- Benefits: Enjoy 25 days holiday, private healthcare, and flexible working options.
- Other info: Hybrid working model with excellent career growth opportunities.
- Why this job: Make a real impact with cutting-edge technology in a supportive environment.
- Qualifications: 4-6 years in Data Engineering or similar, strong SQL skills required.
The predicted salary is between 49500 - 60500 £ per year.
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.
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 work you will be doing
- 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.
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:
- 25 days holiday (FTE) plus Bank Holidays
- Long Service holiday award – 1 extra week every 10 years continuous service
- Private Healthcare with BUPA (offered after probation is passed)
- Scottish Widows Pension Scheme (5% employer / 5% Employee)
- Staff Profit Share and Individual Performance Bonus Scheme
- Salary sacrifice (Pensions, Staff Profit Share)
- Life Assurance - 4 x salary / Permanent Health Insurance
- Paid CSR Day
- Enhanced Maternity/Paternity Leave
- Subsidised gym membership
- Electric car scheme
- Dress for your Day Policy
Inclusivity and Culture
At Birketts, our culture is driven by ambition and a commitment to positively impact all the communities we serve. We are dedicated to the success, development, and wellbeing of our colleagues, helping them achieve their goals and seize the opportunities that come with our growth. Birketts is committed to being an Equal Opportunity Employer. Our policy is unequivocal: we do not tolerate discrimination based on age, disability, sex, race, religion or belief, gender reassignment, marriage or civil partnership, pregnancy or maternity, or sexual orientation.
We pride ourselves on being an inclusive organisation that actively promotes equality of opportunity for all, valuing the right mix of talent, skills, and potential. We welcome applications from a diverse range of candidates, and selection for roles is based solely on individual merit.
If you require this advert in an accessible format, please visit https://diversityjobsgroup.com/company/birketts/#IMP
Artificial Intelligence (AI)
At Birketts, we recognise the evolving role of artificial intelligence (AI) in the legal profession and recruitment. We welcome innovation and understand that candidates may use AI tools to support their job applications. However, we expect all applicants to use AI responsibly and ethically.
Our expectations regarding AI use in applications:
- Your application should reflect your own voice, experiences, and insights. AI may assist in structuring or refining your responses, but it must not replace your personal input.
- Do not use AI to misrepresent your qualifications, experiences, or skills. Any form of exaggeration or fabrication may result in rejection from the process.
- If you have used AI tools to assist with your application, be prepared to discuss how and why you used them during the interview process.
- Do not submit content generated by AI tools that may include personal or sensitive data not intended for public disclosure.
- AI-generated content should be reviewed and edited by you to ensure accuracy, relevance, and alignment with the role and our firm’s values.
We are committed to fair and inclusive recruitment practices. The use of AI should enhance, not compromise, your application. We encourage candidates to demonstrate critical thinking, commercial awareness, and a genuine interest in our firm.
If you have any questions about our expectations or the use of AI in your application, please contact our Talent Acquisition Team via talent@birketts.co.uk
Data Automation Engineer in Norwich employer: Birketts
Birketts is an exceptional employer, offering a dynamic and supportive work culture that prioritises employee growth and collaboration. With a focus on high-net-worth clients in the picturesque city of Cambridge, our Senior Private Client Lawyers benefit from a hybrid working environment, competitive remuneration, and opportunities for professional development within a prestigious law firm recognised for its expertise in private client matters.
StudySmarter Expert Advice🤫
We think this is how you could land Data Automation Engineer in Norwich
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Birketts!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Automation Engineer at Birketts.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Birketts.
✨Apply Directly through Our Website
When you find a suitable opening like Data Automation Engineer at Birketts, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Automation Engineer in Norwich
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Birketts, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Birketts. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Birketts
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Birketts!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
