SlipstreamJobs tracks this role from the company's public career site. Apply directly on the employer's site.
Solidus Labs is a fintech company providing trade surveillance technology for detecting market manipulation, financial crime, and fraud across traditional financial assets, prediction markets, and crypto. Headquartered on Wall Street with offices in Singapore, Tel Aviv, and London, the company monitors over a trillion events daily for financial institutions and regulators worldwide.
You will own the design, optimization, and operation of Solidus's ClickHouse data infrastructure at billion-event scale. This is a hands-on senior role where you'll architect and maintain the data layer that powers the company's core surveillance capabilities.
Key responsibilities include:
• Design and optimize the ClickHouse data layer—table engines, partition strategies, materialized views, and storage policies—to achieve high performance at massive scale.
• Own ClickHouse cluster sizing, topology decisions, and capacity planning for both real-time ingestion and T+1 batch workloads, balancing cost, latency, and throughput.
• Drive data reliability and deduplication strategies using ClickHouse engine-level features (ReplacingMergeTree, CollapsingMergeTree, etc.) and pipeline-level controls to guarantee data completeness and consistency.
• Establish and continuously improve monitoring, alerting, and observability for the ClickHouse layer—covering replication health, merge performance, query latency, and resource utilization.
• Serve as the internal ClickHouse authority, coaching engineering teams on query optimization, data modeling best practices, and efficient use of ClickHouse-specific constructs.
• Act as the primary liaison with the ClickHouse vendor team—triaging issues, incorporating product feedback, evaluating new features, and translating vendor guidance into actionable improvements.
• Collaborate with downstream consumers (analytics, ML, product) to understand access patterns and continuously refine data storage and serving—improving query performance, schema design, and data formats.
• Define and enforce schema versioning and governance standards within the ClickHouse environment, ensuring schema evolution does not compromise pipeline reliability or consumer compatibility.
The company values independence, accountability, organization, self-starter attitude, and willingness to tackle work beyond official scope while maintaining focus on goals and the bigger picture.
Requirements: The posting does not explicitly state years of experience, education, or formal certifications. However, the role requires strong software engineering fundamentals with demonstrated experience in data engineering, proficiency in building robust and scalable data pipelines on cloud environments, and deep expertise with ClickHouse (or equivalent columnar OLAP databases). Candidates should be comfortable with infrastructure-level work, vendor management, and mentoring other engineers.
