ClickHouse Engineer

Help us to increase the number of successful products in the world!

• 🌍 Location: We are full-remote and globally distributed! Our current team is distributed between GMT-8 and GMT+2 so we currently only hire in these timezones.

• 🎤 Interview process: Read more about our interview process.

• 🖥️ Team: Clickhouse

• 💼 Manager:  James Greenhill

• 💰 Compensation: Please check our compensation calculator.

• 🦔 Read more about how we hire and how we think about Diversity & Inclusion.

About PostHog

We’re equipping every developer to build successful products by giving them a suite of products to analyze, test, observe, and deploy new features. We currently offer product and web analytics, session replay, feature flags, experiments, a CDP, SQL access, a data warehouse, and LLM observability… and there’s plenty more to come.

PostHog was created as an open-source project during Y Combinator's W20 cohort. We had the most successful B2B software launch on HackerNews since 2012 with a product that was just 4 weeks old. Since then, more than 100,000 companies have installed the platform. We've had huge success with our paid upgrades, raised bags of money from some of the world's top investors, and have extremely strong product-led growth – 97% driven by word of mouth. 

We're growing quickly, but sustainably. We're also default alive, averaging 10% monthly revenue growth and with more than $20m ARR. We're staying focused on building an awesome product for end users, hiring a handful of exceptional team members, and seeing fantastic growth as a result.

What we value

• We are open source - building a huge community around a free-for-life product is key to PostHog's strategy.

• We aim to become the most transparent company, ever. In order to enable teams to make great decisions, we share as much information as we can. In our public handbook everyone can read about our roadmap, how we pay (or even let go of) people, what our strategy is, and who we have raised money from.

• Working autonomously and maximizing impact - we don’t tell anyone what to do. Everyone chooses what to work on next based on what is going to have the biggest impact on our customers.

• Solve big problems - we haven't built our defining feature yet. We are all about shipping fast, talking to users, and iterating.

Who we’re looking for

The Clickhouse team is responsible for the Clickhouse cluster and query layer that all other teams (and all customers) use to store and query data. You’ll help manage and operate the cluster, figure out the best architecture, and make it 🚀

What you’ll be doing

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

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.

Nice to have

• Experience with Terraform and Ansible for infrastructure automation.

We believe people from diverse backgrounds, with different identities and experiences, make our product and our company better. That’s why we dedicated a page in our handbook to diversity and inclusion. No matter your background, we'd love to hear from you! Alignment with our values is just as important as experience! 🙏

Also, if you have a disability, please let us know if there's any way we can make the interview process better for you - we're happy to accommodate!

BenefitsWhat we offer in return:

• 💰 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