At a Glance
- Tasks: Design and optimise data pipelines on our Snowflake platform for impactful analytics.
- Company: Join Chaucer, a leading insurance group at Lloyd's with a global presence.
- Benefits: Flexible working arrangements, competitive salary, and a commitment to diversity.
- Why this job: Be part of a dynamic team shaping the future of data engineering in insurance.
- Qualifications: Experience with Snowflake, SQL, and data modelling; a passion for innovation is key.
- Other info: Collaborative environment with opportunities for professional growth and development.
The predicted salary is between 28800 - 48000 £ per year.
We are seeking a skilled Data Engineer to join the Data Platform Team, working on the design, build, and optimisation of data pipelines and solutions on our Snowflake-based data platform. This role is critical to delivering robust, scalable, and efficient data solutions that underpin analytics and reporting across the organisation. The Data Engineer will work closely with the Head of Data Platforms and the Data Engineering Lead, contributing to the execution of our data platform strategy and ensuring alignment with architectural standards, governance frameworks, and security requirements. This is a hands-on engineering role focused on technical delivery rather than line management.
Key Responsibilities
- Data Engineering & Development
- Design, develop, and maintain data pipelines and workflows using Snowflake, DBT, and related technologies.
- Implement efficient data models (star and snowflake schemas) to support analytics and reporting needs.
- Optimise SQL queries and transformations for performance and cost efficiency.
- Automate data ingestion and transformation processes to ensure reliability and scalability.
- Platform Integration & Architecture
- Integrate Snowflake with upstream and downstream systems, including Azure services, legacy systems, and external data sources.
- Collaborate with architects and engineering leads to ensure solutions align with enterprise architecture and security standards.
- Contribute to the adoption of modern frameworks (e.g., FiveTran, ADF) to enhance platform capabilities.
- Quality & Best Practices
- Apply engineering best practices for coding, testing, and deployment, including CI/CD and automated testing.
- Ensure data quality through validation, monitoring, and error-handling mechanisms.
- Contribute to reusable patterns and frameworks for data engineering tasks.
- Collaboration & Support
- Work closely with the Head of Data Platforms, Data Engineering Lead, architects, and delivery teams to translate requirements into technical solutions.
- Troubleshoot and resolve data pipeline issues, providing timely support to stakeholders.
- Participate in code reviews and knowledge-sharing sessions within the team.
- Governance & Compliance
- Implement and adhere to standards for data security, access control, and metadata management.
- Ensure compliance with internal policies and external regulations such as GDPR.
- Support data governance initiatives, including data lineage and quality frameworks.
- Documentation & Enablement
- Maintain clear documentation for data pipelines, processes, and engineering standards.
- Support onboarding and enablement activities for new team members.
Skills and Competencies
- Snowflake Expertise – Proven experience in developing, optimising, and tuning Snowflake solutions for performance and cost efficiency.
- Data Engineering Proficiency – Advanced skills in SQL, DBT, and data modelling (including star and snowflake schemas) to deliver scalable, high-quality solutions.
- Cloud Integration – Familiarity with Azure services and modern data engineering tools for seamless integration across platforms.
- Governance & Compliance Awareness – Strong understanding of data governance, security, and regulatory requirements (e.g., GDPR).
- Collaboration & Communication – Ability to work effectively in a fast-paced environment and communicate complex technical concepts to both technical and non-technical stakeholders.
- Automation & DevOps Practices – Hands-on experience with CI/CD pipelines, automated testing, and engineering best practices.
- Domain Knowledge – Exposure to insurance or financial services data domains (desirable).
- Problem-Solving & Innovation – Strong analytical skills with a proactive approach to continuous improvement and innovation.
- Technical Curiosity – Ability to stay current with emerging technologies and contribute to the evolution of the data platform.
Education
Bachelor's degree; industry certifications in business/data analysis or insurance domain desirable.
ABOUT US
Chaucer is a leading insurance group at Lloyd's, the world's specialist insurance market. We help protect industries around the world from the risks they face. Our customers include major airlines, energy companies, shipping groups, global manufacturers and property groups. Our headquarters are in London, and we have international offices in Bermuda, Copenhagen, Dubai and Singapore to be closer to our clients across the world.
Chaucer is committed to diversity, actively values difference and respects people regardless of the protected characteristics which are outlined in the Equality Act 2010 (UK legislation) as a result of the Equal Treatment Directive 2006 (EU legislation). A diverse workforce and an inclusive workplace are core to our success as a business and integral to our winning strategy and culture. We recruit from the widest available pool of talent, and our hiring, assessment and selection process is fair, free from bias and one which ensures we select the right person for the job, based on merit. We are committed to promoting a culture that actively values difference, and recognises that everyone has the right to be treated with dignity and respect throughout their employment. We are open to considering flexible working arrangements for all roles and encourage you to outline your needs during the interview process.
Data Engineer in London employer: Chaucer Group
Contact Detail:
Chaucer Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data engineering projects, especially those involving Snowflake and DBT. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data engineering questions and scenarios. Practice explaining your thought process and problem-solving approach, as this will help you shine during technical discussions.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining our team at Chaucer.
We think you need these skills to ace Data Engineer in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your experience with Snowflake, SQL, and data modelling. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our team. Keep it concise but impactful.
Showcase Your Projects: If you've worked on relevant projects, don’t hold back! Share examples of data pipelines you've built or optimised. We love seeing real-world applications of your skills.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Chaucer Group
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake skills before the interview. Be ready to discuss how you've designed, developed, and optimised data pipelines using Snowflake. Prepare examples of how you've tackled performance issues or cost efficiency in your previous projects.
✨Show Off Your SQL Skills
Since SQL is a big part of this role, practice writing and optimising queries. Be prepared to explain your thought process when it comes to data modelling, especially with star and snowflake schemas. Having a few real-world examples handy will really impress the interviewers.
✨Understand the Bigger Picture
Familiarise yourself with the integration of Snowflake with Azure services and other systems. Be ready to discuss how you’ve collaborated with architects and engineering leads in the past to ensure alignment with enterprise architecture and security standards.
✨Emphasise Collaboration and Communication
This role requires working closely with various teams, so highlight your experience in collaboration. Share examples of how you've communicated complex technical concepts to non-technical stakeholders and how you’ve contributed to team knowledge-sharing sessions.