Colehouse Group
Clickhouse Solutions Architect
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
The Role
We are looking for a ClickHouse Solutions Architect to join our team supporting the design and implementation of a greenfield, enterprise-scale ClickHouse observability platform for a global banking client.
This is a genuine greenfield build at significant scale — there is no incumbent platform to inherit or work around. You will be shaping the architecture from first principles, in an environment where the performance, multi-tenancy and retention requirements are demanding enough that the design decisions made early will determine whether the platform holds up in production.
About the Project
We are architecting a central repository for three classes of time-series telemetry — metrics, traces and logs — serving the bank's application estate. The system requirements are:
Ingest Path
- 3 million events per second sustained, each event carrying a timestamp and full transaction payload
Read Path
- Approximately 1,000 concurrent users
- Several hundred real-time dashboards
Multi-Tenancy and Workload Isolation
- Hundreds of distinct application codes as tenants
- Throttling and quota control required on both read and write paths, so that no single tenant can degrade another
Standards and Tooling Constraints
- OpenTelemetry-native throughout: native OTel agent and native OTel collector
- No proprietary components anywhere in the agent or collector pipeline
Retention and Storage Tiering
Getting this right means solving for ingest throughput, query concurrency, tenant isolation and storage cost simultaneously — the interesting part of the work is that these pull against each other, and the architecture has to reconcile them rather than optimize for any one in isolation
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Key Activities
Discovery and Architecture
- Run technical discovery with client stakeholders to establish workload characteristics — query patterns, latency targets, concurrency, 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 a single answer
- Define the semantic and consumption layer — BI tool integration, API access patterns, downstream contracts
Build and Validation
- Stand up the reference environment and prove the architecture against representative data volumes and query shapes
- Build and tune the ingestion pipelines to agreed throughput and freshness SLOs
- Benchmark and tune query performance against the stated latency targets; iterate on the data model where benchmarks disprove the design
- Establish infrastructure-as-code, CI/CD and environment promotion for schema and configuration changes
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Productionisation
- Define and implement observability — system table monitoring, metrics, alerting thresholds, capacity headroom tracking
- Establish backup, restore and disaster recovery, and validate them by test
- Implement security and governance — RBAC, row/column-level access, encryption, network isolation, audit, and any sector-specific compliance requirements
- Define upgrade, patching and capacity-management procedures
Client Enablement and Handover
- Set engineering standards and guardrails the client's teams work within — naming, modelling patterns, query review criteria, anti-patterns
- Coach and upskill the client's data engineers through pairing, review and structured sessions
- Run the handover to the client's run team against an agreed readiness checklist
- Act as escalation point for complex performance and design questions during transition
Advisory and Practice Contribution (Weighted More Heavily at Principal Level)
- Support pre-sales, bid and scoping work — estimating, technical qualification, solution shaping
- Build reusable assets, reference architectures and accelerators from delivered work
- Represent the practice credibly in client and community forums
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location