Staff Engineer (Clickhouse)

Staff Engineer (Clickhouse) HockeyStack is building the agent infrastructure for enterprise revenue. We spent five years building the only data architecture that preserves causality across the full revenue stack — every interaction, every signal, in sequence. On top of that foundation, we built Nex-lm, a purpose-built AI engine that compiles natural language into deterministic agent workflows. The result is a platform that can extract the revenue blueprint from a company's data, encode it into repeatable automations, and execute it across sales, marketing, and customer success — consistently, at scale. We are not building a dashboard tool with an AI feature. We are building the operating layer that replaces the human bottleneck in enterprise revenue organizations. This is a category being defined right now, and we intend to own it. We have raised $50M+ from Bessemer Venture Partners, General Catalyst, Y Combinator, and others. We operate fully in-person in San Francisco. We move fast and we hire people who want to win. Since launching late 2023, we have grown to 8-figures in ARR, process over 60 TB of revenue data monthly, and we are working with some of the largest B2B companies in the world like Microsoft, Harvey, New Relic, Collibra, etc. 🚀 YOUR MISSION As a ClickHouse Staff Engineer, your mission is to turn massive volumes of GTM data into a fast, reliable, and accurate analytics infrastructure that our customers and our AI Agents depend on every single day. Build a data platform that can enrich 10s of Terabytes an hour, insert 10M records a second, and process complex queries for human & Agents. Push ClickHouse to its performance limit while achieving 99.999% uptime. 🔧 WHAT YOU’LL DO - Manage and scale ClickHouse clusters (replication, sharding, distributed tables) to 100s of TBs. - Maintain data consistency across replicas and shards. - Profile and optimize heavy ETL/ELT queries and table engines. - Tune key configs (max_threads, max_memory_usage, merge settings, I/O schedulers). - Benchmark cluster performance (ingest throughput, query latency, merge rate). - Proactively work with engineers to optimize schema and query patterns. - Improve observability stack on DataDog. - Set up alerting on query performance, merges, replicas, and disk usage. - Own backup and restore processes (to secondary cluster and S3). - Plan and execute upgrades with zero or minimal downtime. - Test and document disaster recovery scenarios. - Own security within ClickHouse, including access control, encryption where applicable, and adherence to internal and regulatory data protection requirements. - Resolve production issues and figure ways to prevent them. - Participate in the Architecture Review process to ensure major changes to the product portfolio have data flow and ClickHouse considerations represented at the very start. 🧬 WHAT WE’RE LOOKING FOR - Ownership-first mindset — you take initiative, move fast, and figure things out - Thrive in early-stage, high-urgency environments where speed and impact matter - Curious, self-aware, and feedback-driven — you bring energy, not ego - See this role as a defining chapter — not a stepping stone or side quest - 5+ years hands-on ClickHouse experience and 8+ years working as a DBA with distributed OLAP databases - Have dealt with data volume at scale (i.e. 100s of TBs) & understand the challenges this brings - Strong systems background with deep understanding of IO performance and network protocols, specifically for high-volume high-throughput analytical workloads (reads and writes!) - Proficiency in writing and optimizing complex SQL queries - Experience with Linux server administration and storage (i.e. RAID) - Experience with monitoring/alerting tools is a strong plus, particularly for database metrics and observability - Familiarity with data infrastructure, reporting systems, or analytics-heavy SaaS products ✨ WHY JOIN NOW? We’re at an inflection point. The p ... (truncated, view full listing at source)