Back to search

ClickHouse Developer

City of London Permanent £60,000 - £90,000 per year View Job Description
This role offers the opportunity to lead the migration of analytical databases to ClickHouse, focusing on designing, optimising, and maintaining robust data infrastructure. You'll play a pivotal role in shaping best practices, ensuring high performance, and supporting cross-functional teams to scale the platform across the business.
  • Lead ClickHouse implementation at a top-tier global investment bank
  • Own a high-impact role with long-term growth and visibility

About Our Client

My client is a prestigious global financial services firm with a strong reputation for innovation in banking and investment solutions. They are committed to sustainability and ethical business practices, providing a wide range of services to clients across various industries, with a focus on cutting-edge technology and data-driven decision-making.

Job Description



  • Design and implement high-performance ClickHouse environments


  • Drive the migration of analytical databases to ClickHouse with minimal disruption


  • Manage database query optimisation for scalability and performance


  • Operate production-ready clusters with high availability and fault tolerance


  • Develop and maintain backup, disaster recovery, and data security strategies


  • Collaborate with teams to align database solutions with business goals


  • Monitor performance with Prometheus and Grafana, addressing issues proactively


  • Implement best practices for data modelling and processing


  • Guide and mentor junior developers in ClickHouse best practices


  • Stay up-to-date with ClickHouse advancements and implement innovative solutions


  • Deliver documentation for system architecture and troubleshooting

The Successful Applicant

The successful candidate will have:
🔹 Extensive experience with ClickHouse in a production environment
🔹 Proficiency in Linux/Unix and database performance optimisation
🔹 Strong knowledge of query optimisation, data modelling, and ETL
🔹 Experience with DevOps tools (Jenkins, Ansible) and CI/CD pipelines
🔹 Solid understanding of data security, backup, and disaster recovery
🔹 Familiarity with Prometheus, Grafana, and C++ for customisation
🔹 Strong problem-solving, analytical, and communication skills
🔹 Ability to collaborate effectively with cross-functional teams

What's on Offer

This role offers a competitive salary of up to £90k DOE, with a 12% non-contributory pension for long-term financial security. Flexible hybrid working (50% onsite) provides a great work-life balance, with the option to work 3 days one week and 2 days the next in the London office.

Contact
Cameron Mason
Quote job ref
JN-042025-6718299
Phone number
+442030778397

Job summary

Job function
Technology
Subsector
Data Warehousing
Sector
Financial Services
Location
City of London
Contract type
Permanent
Consultant name
Cameron Mason
Consultant phone
+442030778397
Job reference
JN-042025-6718299