Senior Clickhouse Engineer

Summary

Join Consensus, a dynamic SaaS company, as a high-caliber backend engineer specializing in data and analytics architectures. You will design, build, and optimize analytics stores using ClickHouse, translate business needs into performant queries, and collaborate with product and development teams. Responsibilities include owning end-to-end delivery, contributing to architecture discussions, debugging production systems, and mentoring team members. This role requires a Bachelor's degree in Computer Science or equivalent experience, 4+ years of backend engineering experience, and deep experience with SQL and columnar analytics stores. The ideal candidate will possess strong Java and/or PHP skills, familiarity with Kafka, and experience with cloud infrastructure and containerization. Consensus offers a robust benefits package including health and wellness benefits, retirement plans, paid parental leave, unlimited PTO, flexible work options, professional development opportunities, and paid volunteer days.

Requirements

• Bachelor's degree in Computer Science or equivalent practical experience
• 4+ years of backend engineering experience in high-scale systems
• Deep experience with SQL and columnar analytics stores (ClickHouse strongly preferred)
• Strong background in Java and/or PHP (including frameworks like Spring Boot or Laravel)
• Proven experience designing and optimizing data models for fast analytical queries
• Familiarity with Kafka and event-driven systems
• Experience with cloud infrastructure (AWS preferred) and containerization (Docker, Kubernetes)
• Solid understanding of RESTful API design and microservices architecture
• Pragmatic engineering instincts: balancing performance, simplicity, and business needs
• Passion for performance: you know how to identify bottlenecks and how to fix them

Responsibilities

• Design, build, and optimize analytics stores using ClickHouse for speed, scale, and reliability
• Translate complex business needs into performant queries and data models that support deep analytical use cases
• Apply strong Java and/or PHP skills to evolve our service layer, with a focus on integration with high-volume data platforms
• Collaborate with product and development teams to define requirements and ensure data solutions are accurate, scalable, and maintainable
• Own end-to-end delivery: from architecture to deployment, including tests, monitoring, and performance tuning
• Shape our platform’s future by contributing to architecture discussions, POCs, and long-term scaling strategies
• Debug and optimize production systems, especially those handling large-scale query loads or ingest pipelines
• Mentor team members on best practices in data engineering, backend architecture, and efficient querying

Benefits

• Benefit from a generous employer contribution towards health insurance, with a variety of plans that include dental and vision coverage
• Enjoy employer contributions to your HSA, and take advantage of HSA/FSA programs to maximize your tax savings
• Secure your future with our 401(k) plan featuring company-matching contributions
• We offer paid parental leave, so you can prioritize what matters most—your family
• Enjoy unlimited PTO and 12 company holidays to recharge and refresh
• Celebrate your birthday with a day off, and enjoy Flex Fridays, where every third Friday of the month is yours to unwind
• Work in a flexible, remote environment that suits your lifestyle, with a top-tier WFH setup provided when you join
• Participate in our professional development program to expand your skills and advance your career
• Make a difference in your community with two paid volunteer days each year at a charity of your choice