Clickhouse Solutions Architect
- Location
- Slough, England, United Kingdom
architecture: deployment model (ClickHouse Cloud vs self-managed on Kubernetes/VMs), cluster topology, shard and replica strategy, Keeper configuration, storage tiering Design the data model — table engine selection across the MergeTree family, primary/sort key design, partitioning, projections, materialized views, dictionaries, TTL and object-storage tiering Design … architecture — streaming (Kafka/Kinesis, Kafka table engine or ClickPipes), batch and CDC paths, idempotency and deduplication strategy, schema evolution Produce sizing and cost modelling, with options and trade-offs rather than a single answer Define the semantic and consumption layer — BI tool integration, API access patterns, downstream contracts ...