Senior Data Engineer (Snowflake)

Lorien; City Of London; Hybrid; GBP 85,000 - 100,000; Full time

Job summary

An international insurance company is seeking a Senior Data Engineer to design and implement Snowflake-based data warehousing solutions. This role involves leading modernization efforts, collaborating with stakeholders, and mentoring team members. Ideal candidates should have proven experience in AWS and Snowflake, strong SQL skills, and a collaborative mindset. The position offers a salary up to £100,000 plus a bonus and hybrid working arrangements.

Benefits

Salary up to £100,000

15% bonus

25 days annual leave plus bank holidays

Qualifications

• Proven experience as a data engineer with focus on Snowflake and AWS.
• Strong SQL skills for complex data queries.
• Experience in large-scale enterprise environments.

Responsibilities

• Lead the modernization to Snowflake-based data solutions.
• Design and implement scalable data solutions using AWS.
• Drive CI/CD practices for data workflows.

Skills

Leadership and communication

Snowflake expertise

AWS services

SQL proficiency

Python programming

Tools

AWS Glue

AWS Lambda

AWS S3

AWS Redshift

Job description

You will join an international insurance company specialising in commercial insurance and reinsurance products. Our client is looking for an experienced Senior Data Engineer to play a pivotal role in designing and implementing next-generation data warehousing solutions, with a focus on Snowflake and AWS technologies. This is a fantastic opportunity to shape the future of data architecture and drive innovation in a dynamic, collaborative environment.

Main Responsibilities

• Lead the modernisation journey to Snowflake-based data warehousing solutions within an AWS environment.
• Design and implement scalable, secure, and cost-efficient data solutions using AWS services such as Glue, Lambda, S3, Redshift, and Step Functions.
• Develop robust data pipelines and analytics platforms, ensuring high availability, performance, and maintainability.
• Drive automation and CI/CD practices for data workflows, ensuring reliable deployment and monitoring.
• Mentor and support team members through code reviews, pair programming, and knowledge sharing.
• Collaborate with stakeholders, product owners, and developers to ensure alignment between requirements and data solutions.
• Hybrid working (approximately 2 days a week in the office)
• Salary up to £100,000 + 15% bonus
• 25 days annual leave + bank holidays + option to buy and sell

Requirements

• Strong leadership and communication skills as you will be working closely and presenting to senior stakeholders, along with leading and mentoring teams
• Proven experience as a data engineer with a strong focus on Snowflake and AWS services in large-scale enterprise environments
• Extensive experience with AWS services (e.g., EC2, S3, RDS, DynamoDB, Redshift, Lambda, API Gateway)
• Strong SQL skills for complex data queries and transformations
• Python programming for data processing and analysis is a plus
• Strong leadership, communication, and collaboration skills

For more information and immediate review, please apply now!

Carbon60, Lorien & SRG - The Impellam Group STEM Portfolio are acting as an Employment Business in relation to this vacancy.