> Markdown version of [/jobs/ext/2457184-clickhouse-engineer](https://www.wearedevelopers.com/jobs/ext/2457184-clickhouse-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # ClickHouse Engineer - **Company:** Reactive Markets - **Location:** Barnby in the Willows, UK - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Big Data, BigQuery, Databases, Data Infrastructure, Linux, Python (Programming Language), MATLAB, Online Analytical Processing, Operational Databases, Query Optimization, SQL Databases, Git, KDB+, Kubernetes, Druid, Vertica, Software Version Control, Data Pipelines, Amazon Redshift, Programming Languages - **Published:** August 11, 2026 - **Apply:** https://www.collegerecruiter.com/job/2815444700-clickhouse-engineer ## About the Role operational depth: you have run a production data platform, owned its capacity plan and its recovery procedures, and stayed calm when it mattered. This hire completes a follow-the-sun team - based in Singapore (office-based) or London - so the platform is supported across time zones rather than by heroics. On-call is a shared, contracted responsibility, planned and paid - not goodwill., * Columnar/OLAP database engineering - ClickHouse strongly preferred; deep experience with another columnar or large-scale time-series store (BigQuery, Redshift, Druid, kdb+ or similar) also works * SQL depth - execution plans, query optimisation, and schema design for very large datasets * Operational/SRE experience - you have carried production responsibility for a data platform: monitoring, capacity, incidents, recovery * Linux and Kubernetes - comfort with the operational layer beneath the database * A programming language - one of Python, Go, R, or MATLAB (Python preferred) * Engineering discipline - you write proposals, strategies, and architectural documents and diagrams well, and you manage change properly * Git - excellent version-control practice ## Description We're looking for a ClickHouse Engineer to share ownership of our data plant: a multi-datacentre, multi-AZ ClickHouse cluster ingesting billions of rows a day, underpinning compliance, billing, and a growing family of real-time and historical analytics. This is a core-platform engineering role, not a DBA role. You'll work across the full engineering scope of a serious ClickHouse estate: cluster operations and upgrades, schema and sorting-key design, materialised views, ingestion performance, query optimisation, workload isolation, capacity planning, storage tiering, backup and recovery, monitoring and alerting, and production support. You'll also work on the data pipelines around the plant - our capture services are Go, and our analytics foundation is Python. You don't need years of ClickHouse specifically - deep experience with another columnar or large-scale time-series database qualifies you, and a strong columnar engineer learns our estate quickly. What we do need is genuine, * Cluster operations at scale - running, upgrading and evolving a multi-AZ ClickHouse estate on Kubernetes, with rehearsed backup and recovery * Schema and query engineering - table and sorting-key design, partitioning, materialised views, and query optimisation against multi-terabyte datasets * Capacity and observability - a measured capacity model, storage tiering and retention, and the Grafana monitoring and alerting that keeps the plant's health visible * Ingestion and data quality - correctness and completeness gates on the pipelines feeding the plant; reconciliation that proves nothing was dropped * Workload isolation - keeping ingest, operations, reporting and ad-hoc analytics from treading on each other as read load grows * AI-assisted operations - modern tooling (including MCP-based AI access to the estate) that lets a small team run a large platform well ## Related Videos - [Analytics in the Age of Agentic AI: A tour of ClickHouse and Langfuse](https://www.wearedevelopers.com/videos/100240-analytics-in-the-age-of-agentic-ai-a-tour-of-clickhouse-and-langfuse) - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client](https://www.wearedevelopers.com/videos/100311-swapping-a-data-warehouse-at-runtime-zero-downtime-migration-without-changing-a-single-client) - [Docker exec without Docker](https://www.wearedevelopers.com/videos/1094-docker-exec-without-docker) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)