cover image
Lorien

Data Engineer (Snowflake/Kafka)

On site

London, United kingdom

Freelance

16-01-2026

Share this job:

Skills

Leadership Python SQL Data Warehousing Data Engineering CI/CD Monitoring Version Control Programming git AWS Snowflake Kafka

Job Specifications

Data Engineer (Snowflake/Kafka)
Hybrid Working - Edinburgh OR London - 2 days a week on site.
Financial Services

Lorien's leading Banking Client is looking for additional Data Engineers to join the existing team on an expanding project.
The Ideal candidate for this position will have strong hands on practical coding abilities with Snowflake and Kafka.

This role is based in Edinburgh or London.
This role will be Via Umbrella.
Working in a Hybrid Model of 2 days a week on site.

Key Skills and Experience
Core Technical Requirements
Strong experience with Snowflake for data warehousing, including writing efficient SQL and managing schemas.
Proficiency in Airflow for orchestration and workflow management.
Hands-on experience with AWS services, particularly S3 for storage and Lambda for serverless processing.
Familiarity with Kafka concepts (producers, consumers, topics) and ability to integrate with streaming data pipelines.
Solid understanding of data modelling, ETL/ELT processes, and performance optimization.
Programming & Engineering Skills
Proficiency in Python for data engineering tasks and automation.
Ability to design and implement scalable, maintainable data pipelines.
Experience with version control systems (eg, Git) and collaborative development workflows.
Leadership & Mentorship
Ability to lead technical initiatives within the team and drive best practices.
Experience in mentoring junior engineers, providing guidance on coding standards, design patterns, and career development.
Comfortable with code reviews and fostering a culture of continuous improvement.
Best Practices & Mindset
Strong grasp of data quality principles, including validation and monitoring.
Ability to read, understand, and refactor existing code effectively.
Familiarity with CI/CD practices for data pipeline deployment.
Comfortable working in cloud-native environments and following security/compliance standards.
Nice-to-Have
Exposure to streaming data architectures and event-driven systems.
Knowledge of Snowflake performance tuning and cost optimization.
IND_PC3
Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.

About the Company

Lorien is a technology, transformation and telecom talent solutions specialist. We combine tech expertise with the scope, depth and breadth of large-scale talent solutions. Driven by both clients and candidates, covering Europe and the US, we work with all sectors, sizes and tech needs – from start-up to established, tech companies and those who use tech to propel them further - we work with them all. Our unique position in the market means we have the insight to create tailored solutions – keeping our clients ahead of t... Know more