Click House Operations Engineer Clickhouse

About PostHog We're shipping every product that companies need to run their business from their first day, to the day they IPO, and beyond. The operating system for folks who build software. We started with open-source product analytics, launched out of Y Combinator's W20 cohort. We've since shipped more than a dozen products, including: • A built-in data warehouse, so users can query product and customer data together using custom SQL insights. • A customer data platform, so they can send their data wherever they need with ease. • Max AI, an AI-powered analyst that answers product questions, helps users find useful session recordings, and writes custom SQL queries. Next on the roadmap are CRM, messaging, revenue analytics, and support products. When we say every product that companies need to run their business, we really mean it! We are: • Product-led. More than 100,000 companies have installed PostHog, mostly driven by word-of-mouth. We have intensely strong product-market fit. • Default alive. Revenue is growing 10% MoM on average, and we're very efficient. We raise money to push ambition and grow faster, not to keep the lights on. • Well-funded. We've raised more than $100m from some of the world's top investors. We're set up for a long, ambitious journey. We're focused on building an awesome product for end users, hiring exceptional teammates, shipping fast, and being as weird as possible. Things we care about • Transparency: Everyone can read about our roadmap, how we pay (or even let go of) people, our strategy, and how we work, in our public company handbook. Internally, we share revenue, notes and slides from board meetings, and fundraising plans, so everyone has the context they need to make good decisions. • Autonomy: We don’t tell anyone what to do. Everyone chooses what to work on next based on what's going to have the biggest impact on our customers, and what they find interesting and motivating to work on. Engineers lead product teams and make product decisions. Teams are flexible and easy to change when needed. • Shipping fast: Why not now? We want to build a lot of products; we can't do that shipping at a normal pace. We've built the company around small teams – autonomous, highly-efficient groups of cracked engineers who can outship much larger companies because they own their products end-to-end. • Time for building: Nothing gets shipped in a meeting. We're a natively remote company. We default to async communication – PRs > Issues > Slack. Tuesdays and Thursdays are meeting-free days, and we prioritize heads down building time over perfect coordination. This will be the most productive job you've ever had. • Ambition: We want to solve big problems. We strongly believe that aiming for the best possible upside, and sometimes missing, is better than never trying. We're optimistic about what's possible and our ability to get there. • Being weird: Weird means redesigning an already world-class website for the 5th time. It means shipping literally every product that relates to customer data. It means building an objectively unnecessary developer toy with dubious shareholder value. Doing weird stuff is a competitive advantage. And it's fun. Who we’re looking for ClickHouse is the core piece of infrastructure at PostHog. Every product and customer relies on it to ingest, store, and query data. We need someone to automate, manage, and maintain ClickHouse as we grow towards capturing trillions of events per year and having one of the world’s largest clusters. This includes ClickHouse operations and scaling infrastructure, as well as node and instance-level performance optimization. We want to ensure that we have the right hardware deployed at the right time for each workload on ClickHouse. What you’ll be doing • Build systems and automations for the provisioning and scaling of metal resources (on AWS) for our ClickHouse cluster. • Use Terraform, Ansible, and Kubernetes to automate the dynamic provisioning of instances. • Improve and create monitoring tools, dashboards, and alerts that show the health, usage, and performance of our ClickHouse cluster. • Investigate and experiment using the latest hardware that cloud providers have to offer to find the optimal setup for our solution. You’ll have a budget to do this. 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. • Experience automating dynamic provisioning of instances, utilizing Terraform, Ansible, and K8s. • Can thrive in a culture of autonomy and self-direction. 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! #LI-DNI Salary We have a set system for compensation as part of being transparent. Salary varies based on location and level of experience. Learn more about compensation Location (based on market rates) Country Region Level Step Salary calculator • Benchmark (United States - San Francisco, California) $243,000 • Level modifier 1 • Step modifier 0.95 - 1.04 Salary $230,850 - $252,720plus equity Benefits • Generous, transparent compensation & equity • Unlimited vacation (with a minimum!) • Two meeting-free days per week • Home office • Coworking credit • Private health, dental, and vision insurance. • Training budget • Access to our Hedge House • Carbon offsetting • Pension & 401k contributions • We hire and pay locally • Company offsites Get more details about all our benefits on the Careers page. Your team's mission and objectives Data at PostHog - Mission Data Team's mission is to provide a storage and query engine that meets these requirements: • Continue to meet the needs of the product today now and in the future • Maintain and optimize our current ClickHouse deployment • Elastically scale our capacity with little effort • Support multiple query quality of service (QOS) guarantees (Real-time, Batch, etc.) • Data is stored once and queryable from the appropriate tool • Queries are optimized for arenaflex and performance • Tunable execution performance to allow trade-offs between arenaflex and performance • Storage is durable Data Team's Mission at PostHog Data Team's mission is to provide a storage and query engine that meets these requirements: • Continue to meet the needs of the product today now and in the future • Maintain and optimize our current ClickHouse deployment • Elastically scale our capacity with little effort • Support multiple query quality of service (QOS) guarantees (Real-time, Batch, etc.) • Data is stored once and queryable from the appropriate tool • Queries are optimized for arenaflex and performance • Tunable execution performance to allow trade-offs between arenaflex and performance • Storage is durable In service of this mission, our goals are: Goals for Q3 2025: Clickhouse Tooling • Migration (P1) • Chargeback (P0) - Paweł Szczur • Enable our customers to self service performance issues • Surface resource consumption • Usecase: Query analysis to avoid querying big ranges • SlopCop (query scheduling) (P0) - Ted Kaemming, Paweł Szczur • Rate limiting • Queuing • Debouncing • Inserter & ShuffleHog (P0) - James Greenhill • Mutator (P0) - Daniel Escribano, Ted Kaemming • Dagster + table + interface • Mutation monitoring • Ensure Deletes Run Clickhouse Ops • Make ClickHouse ops easy - Daniel Escribano, James Greenhill • Complete cluster management through IaC • EU coordinators • Bringing up and down nodes should require no thought • Runbook - more ideally automation • Tooling? • Much faster critical procedures (rely on ZK configuration more) • ClickHouseKeeping through Dagster • Part moving • Detached/unneeded parts cleaning • Resizing parts? • Disk management • Automatic disk provisioning based on thresholds (and limits) • Events TTL and actual data tiering • Some tables in Iceberg (Antalya) • Query_log • Query_metrics_log • Plan for events migration to Iceberg • ClickHouse more on K8s Interview process We do 2-3 short interviews, then pay you to do some real-life (or close to real-life) work. • 1 Application (You are here) Our talent team will review your application We're looking to see how your skills and experience align with our needs. • 2 Culture interview 30-min video call Our goal is to explore your motivations to join our team, learn why you’d be a great fit, and answer questions about us. • 3 Technical interview 45 minutes, varies by role You'll meet the hiring team who will evaluate skills needed to be successful in your role. No live coding. • 4 Founder interview 30 minutes You have reached the final boss. It's time to chat with James or Tim. • 5 PostHog SuperDay Paid day of work You’ll meet a few more members of the team and work on an independent project. It's challenging, but most people say it's fun! • 6 Offer Pop the champagne (after you sign) If everyone is happy, we’ll make you an offer to join us - YAY! Apply (Now for the fun part...) Just fill out this painless form and we'll get back to you within a few days. Thanks in advance! Bolded fields are required Apply tot his job

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...