Data Engineer (Consultant - Mid Level)

Capco; London; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading financial consulting firm in London is seeking a mid-level Data Engineer to design and develop scalable data pipelines. You'll work with top financial institutions and use modern technologies to transform raw data into actionable insights. The ideal candidate has strong experience in Python or Java, and proficiency with Spark and Hadoop. This role offers a hybrid work model and a competitive benefits package.

Benefits

Discretionary bonus

Competitive pension

Health insurance

Flexible holiday options

Continuous learning and training

Family-friendly leave options

Gympass

Travel insurance

Dental insurance

Qualifications

• Strong experience in Python, Scala, or Java for data engineering.
• Proficiency with Spark, Hadoop, Databricks, Hive, and similar big data tools.
• Hands-on experience with schema design (structured/semi-structured data), SQL/NoSQL, ETL/ELT.
• Familiarity with event-driven streaming tools (Kafka, Kinesis, Spark Streaming).
• Good understanding of secure data protocols (TLS, OAuth, encryption).

Responsibilities

• Build robust and scalable data pipelines using modern technologies and frameworks.
• Develop both on-prem and cloud-native data solutions.
• Collaborate with clients to interpret data requirements and design optimal solutions.
• Automate and optimise data workflows, ensuring security, resilience, and performance.
• Contribute to internal capability development by sharing knowledge and best practices.

Skills

Python

Scala

Java

Spark

Hadoop

Databricks

Hive

SQL

NoSQL

ETL

ELT

Kafka

Kinesis

Spark Streaming

TLS

OAuth

encryption

Tools

Snowflake

Redshift

BigQuery

data lake

graph databases

Git

Jenkins

CircleCI

Job description

Data Engineer (Consultant - Mid Level)
Location: London (Hybrid) | Practice Area: Data & Analytics | Type: Permanent

Power data-driven decisions in financial services. Build smarter pipelines, deliver deeper insights.

The Role
We're looking for a mid-level Data Engineer to join our Data & Analytics practice. You'll design, develop, and deploy scalable data pipelines and architectures for some of the world's leading financial institutions. You'll combine hands-on coding with engineering best practices, transforming raw data into actionable intelligence across on-premise and cloud platforms.

What You'll Do

• Build robust and scalable data pipelines using modern technologies and frameworks
• Develop both on-prem and cloud-native data solutions, supporting digital transformation at scale
• Collaborate with clients to interpret data requirements and design optimal solutions
• Automate and optimise data workflows, ensuring security, resilience, and performance
• Contribute to internal capability development by sharing knowledge and best practices

What We're Looking For

• Strong experience in Python, Scala, or Java for data engineering
• Proficiency with Spark, Hadoop, Databricks, Hive, and similar big data tools
• Hands-on experience with schema design (structured/semi-structured data), SQL/NoSQL, ETL/ELT
• Familiarity with event-driven streaming tools (Kafka, Kinesis, Spark Streaming)
• Good understanding of secure data protocols (TLS, OAuth, encryption)

Bonus Points For

• Experience with Snowflake, Redshift, BigQuery, or data lake/data warehousing tools
• Knowledge of containerisation, graph databases, and machine learning concepts
• Proficiency with Git and CI/CD pipelines (Jenkins, CircleCI)
• Experience with data solutions across hybrid cloud environments
• Enthusiasm for learning new tools and solving real-world problems with data

Why Join Capco

• Deliver high-impact technology solutions for Tier 1 financial institutions
• Work in a collaborative, flat, and entrepreneurial consulting culture
• Access continuous learning, training, and industry certifications
• Be part of a team shaping the future of digital financial services
• Help shape the future of digital transformation across FS & Energy.

Benefits

We offer a competitive, people-first benefits package designed to support every aspect of your life:

• Core Benefits: Discretionary bonus, competitive pension, health insurance, life insurance and critical illness cover.

• Mental Health: Easy access to CareFirst, Unmind, Aviva consultations, and in-house first aiders.

• Family-Friendly: Maternity, adoption, shared parental leave, plus paid leave for sickness, pregnancy loss, fertility treatment, menopause, and bereavement.

• Family Care: 8 complimentary backup care sessions for emergency childcare or elder care.

• Holiday Flexibility: 5 weeks of annual leave with the option to buy or sell holiday days based on your needs.

• Continuous Learning: Your growth, your way - minimum 40 hours of training annually. Take your pick; workshops, certifications, e-learning. Also, Business Coach assigned from Day One: Get one-on-one guidance to fast-track your goals and accelerate your development.

• Healthcare Access: Convenient online GP services.

• Extra Perks: Gympass(Wellhub), travel insurance, Tastecard, season ticket loans, Cycle to Work, and dental insurance.

Inclusion at Capco
We're committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know - we'll be happy to help. We value each person's unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration - a mindset that shapes how we work with clients and each other every day.