ClickHouse Operations Engineer
Manage and optimize ClickHouse databases to power PostHog's self-driving product analytics platform
Maintain and scale ClickHouse databases, ensuring high performance and reliability for PostHog's growing customer base. Collaborate with engineers to implement data pipelines and optimize queries.
Why This Role?
Work on a cutting-edge product with a well-funded, product-led company that values transparency and autonomy.
Key Responsibilities
- Administer ClickHouse databases to support PostHog's product analytics platform
- Optimize database performance and query efficiency
- Collaborate with engineering teams to design and implement data pipelines
- Monitor and maintain database health and security
- Contribute to PostHog's open-source community and internal documentation
Requirements
- Proven experience with ClickHouse database management
- Strong understanding of SQL and database querying
- Experience with data warehousing and analytics tools
- Knowledge of cloud infrastructure (AWS, GCP, Azure)
- Familiarity with Docker and Kubernetes
- Experience with data modeling and schema design
Required Skills
Indonesia Context
- Working Hours Overlap:
- Flexible — work your own hours
View Original Description from Ashby Job Boards
Original description from Ashby Job Boards
ABOUT POSTHOG Product development used to mean manually writing code, running analysis, diagnosing bugs, and rolling out changes using dozens of tools. PostHog makes products self-driving https://posthog.com/self-driving. It's the only platform that acts like a co-pilot for you (and your AI agents) to do it all – autonomously. We started with open-source product analytics, launched out of Y Combinator's W20 cohort https://posthog.com/handbook/story. We've since shipped more than a dozen products https://posthog.com/products, including: - PostHog Desktop https://posthog.com/desktop, the only AI devtool that understands your product, not just your codebase. - A built-in data warehouse https://posthog.com/docs/data-warehouse, so users can query product and customer data together using custom SQL insights. - PostHog AI https://posthog.com/ai, an AI-powered analyst that answers product questions, helps users find useful session recordings, and writes custom SQL queries. We are: 1. Product-led. More than 450,000 organizations have installed PostHog, mostly driven by word-of-mouth. We have intensely strong product-market fit. 2. Default alive https://paulgraham.com/aord.html. Revenue is growing incredibly quickly, and we're very efficient. We raise money to push ambition and grow faster, not to keep the lights on. 3. Well-funded. We've raised more than $180m 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 https://posthog.com/deskhog. 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 https://posthog.com/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 https://posthog.com/handbook/wide-company and make product decisions https://posthog.com/handbook/which-products. Teams are flexible and easy to change when needed. - Shipping fast: Why not now? https://posthog.com/handbook/values#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 https://posthog.com/founders/cracked-manifesto 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 https://posthog.com/handbook/company/culture#were-on-the-makers-schedule, 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 https://posthog.com/deskhog with dubious shareholder value. Doing weird stuff is a competitive advantage. And it's fun. WHAT YOU'LL BE DOING ClickHouse is the core piece of infrastructure at PostHog https://posthog.com/docs/how-posthog-works/clickhouse. 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. You'll build systems and automations for the provisioning and scaling of our large ClickHouse clusters, handling over 100 PB's of data. You'll have the ability to investigate and experiment using the latest hardware that cloud providers have to offer in order to find the optimal setup for our solution. And yes, You'll have a budget to do this. You'll be using Terraform, Ansible, and Kubernetes to automate the dynamic provisioning of instances and work on a bleeding edge ClickHouse implementation, like open format backed tables, and not just maintenance. We're also building a query optimizer for ClickHouse, which means you will work on query performance tooling. YOU’LL FIT RIGHT IN IF: - You bring OLAP Database Experience. This role is focussed on ClickHouse, but if you bring strong experience with other OLAP Databases, that's great. We're looking for people that went into the internals of ClickHouse and other OLAP Databases, not high level users. - You bring experience in automating Dynamic provisioning instances. Strong experience with utilizing Terraform, Ansible and K8s is important. - You bring experience with Scale and Complexity! We're building and operating high-scale complex data storage solutions, we need you to have experience with the challenges this brings. - You bring the Stack we need. We build using Python, Terraform, Ansible, Kubernetes, AWS, and Zookeeper (An alternative to Zookeeper is fine) - You’re ready to do the best work of your career. We have incredible distribution, a big financial cushion and an amazing team. There’s probably no better place to see how far you can go. If this sounds like you, we should talk. We are committed to ensuring a fair and accessible interview process. If you need any accommodations or adjustments, please let us know.
Salary Context
Similar Engineering roles on LokerDollar pay around $170k/yr (range $855–1000k/yr, n=709 active listings).
Hiring at PostHog
PostHog has 8 other active roles on LokerDollar and has been hiring here since May 11, 2026 — across Engineering, Writing & Content.
- Technical Content Writer
- Member of the Technical Writing Staff
- Backend Engineer - Ingestion (Europe/UK timezone)
Openness not stated by employer — check the listing
Frequently asked questions
- Is ClickHouse Operations Engineer at PostHog a remote job?
- Yes. ClickHouse Operations Engineer at PostHog is a fully remote role open to candidates worldwide.
- What type of employment is ClickHouse Operations Engineer at PostHog?
- This is a full time position.
- How do I apply?
- Click the "Apply" button on this page to go to the official application at PostHog.
Explore related
Market data & reports
Salary & skill-demand research built from our own listings data.
- Indonesia IT Jobs vs Global Remote (2026)Primary analysis of 2,049 listings: methodology, classification rules, downloadable datasets.
- AI-Skill Demand: Indonesia vs Global Remote (2026)10,000+ postings, taxonomy-first classifier, Wilson CIs, pre-registered before analysis.
- Remote ≠ Remote: The Skills That Open Global Work to Indonesians (2026)12,891 remote listings: the highest-paid coding skills are the most geo-locked for Indonesia-based applicants. CC BY 4.0 aggregate dataset.
- Indonesia Hiring Report: Tech vs Non-TechJob demand by field from aggregate open-job counts — never individual listings.
- Indonesia Salary BenchmarkAggregate salary ranges across roles, with open methodology and dataset.
- Indonesian Remote Work Salary & Demand IndexHow much of the global remote job corpus is open to Indonesia, and what it pays (USD) by role.
- Indonesia Quarterly Labor Market ReportLayoffs, funding, salaries & skills per quarter — open aggregates.
- Remote Market Reports by RoleAuto-generated per role family — skills, seniority, companies, salary.
- Global Remote Salary BenchmarkAnnual salary by role & currency, plus the share of listings open worldwide.
From the blog
- Remote Work Salary Myths: Are Viral JobsViral videos claim high-paying remote roles for everyone. We cut through the hype to find out what entry-level USD remote jobs actually look like.
- Remote Jobs: Exploring Telus AlternativesDiscover remote job opportunities with Telus alternatives, salary ranges, and in-demand skills. Learn how to find and apply for remote jobs globally.
- Remote Job Market Update: September 2026Explore the latest remote job trends, salary comparisons, and hiring insights from top global companies.