Job Profile Summary 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. To learn more about us please visit our website. 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. Chaucer are a leading specialty (re)insurance group working with brokers, coverholders and clients to protect and support business activities around the world. Our services are accessed both through Lloyd’s of London and the company markets. We are defined by an enterprising, bespoke approach to (re)insurance, enabled by the individual character, experience and imagination of our expert teams. Chaucer is a member of the China Re Group and backed by their financial and operational resources. China Re is one of the world’s largest reinsurance companies whose outstanding and comprehensive strength is rated A (excellent) by AM Best and A (strong) by S&P Global Rating. Chaucergroup.com
