Clickhouse Solutions Architect
- Location
- Slough, England, United Kingdom
ingest volume and velocity, retention and cost envelope Translate those into a target-state 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 the ingestion 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 ...