ClickHouse Platform Engineer

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.

Client Details

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.

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

Profile

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

Job 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.