Clickhouse Engineer - Data Warehouse (Remote)

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: [insert info about the stages of the interview] Read more about our interview process.

• 🖥️ Team: Data Warehouse

• 💼 Manager:  Eric Duong

• 💰 Compensation: Please check our compensation calculator.

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

About PostHog

PostHog helps engineers build better products. We are a single platform to analyze, test, observe, and deploy new features. We give engineers product analytics, session recording, feature flags, A/B testing, event pipelines, SQL access, and a data warehouse… and there’s plenty more to come.

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

Despite the 📉 tech market, we're default alive and doing better than ever!

PostHog makes money from our cloud product, or people can self host the open source project. We average 10% monthly revenue growth and are aiming for $10m ARR in early 2024. While others are focused on layoffs and struggling to grow into huge valuations, we're focusing on an awesome product for end users, hiring a handful of exceptional team members and seeing fantastic increases in revenue 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

We’re looking for a Clickhouse Engineer to join our Data Warehouse team. The Data Warehouse 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 Te