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.