Clickhouse Engineer

Summary

Join PostHog's Clickhouse team as a full-remote engineer and help build and maintain the data infrastructure powering our successful product analytics platform. You will develop tooling for backup/restore, schema management, cluster monitoring, and performance optimization. The role requires proficiency in Python, Kubernetes, AWS, and experience with high-scale data storage solutions. PostHog offers a generous compensation package, unlimited time off, private medical insurance (US/UK), pension contributions, parental leave, training budget, and various other perks. We value autonomy, transparency, and a diverse team.

Requirements

• Proficiency in Python, Kubernetes, and AWS
• Experience building and operating high-scale complex data storage solutions
• Strong interest and experience in ClickHouse (or similar OLAP databases) internals and query performance optimization
• Can thrive in a culture of autonomy and self-direction

Responsibilities

• Develop tooling for full and incremental backup and restore processes for ClickHouse clusters
• Create schema and mutation management tools to make it easy for teams at PostHog to manage their own tables
• Enhance visibility into cluster statuses
• Automate dynamic provisioning of instances, utilizing Terraform and Ansible
• Build query benchmarking and performance tooling to help engineers in identifying and optimize expensive queries
• Make everything—schema, queries, and cluster configurations—faster and more efficient

Preferred Qualifications

Experience with Terraform and Ansible for infrastructure automation

Benefits

• Generous, transparent compensation and employee-friendly equity in PostHog
• Unlimited time off with a 25-day minimum (in 2021 the team on average took 32 days off)
• Private medical insurance, including dental and vision (US and UK only)
• Pension/401k contributions (4% matching)
• Generous parental, bereavement and child loss leave
• Training budget and free books
• $200/month budget towards co-working or café working and $300/month for team socials
• Spill mental health chat
• $100/month budget to provide support to open-source projects
• We'll be your first investor
• Regular team off-sites (we went to Iceland in March) with carbon offsetting for work travel with Project Wren