Lead ClickHouse Engineer

Lead ClickHouse Engineer

Full-Time 75600 - 92400 Β£ / year (est.) Home office (partial)
R

At a Glance

  • Tasks: Lead the engineering of a high-performance ClickHouse data platform for real-time analytics.
  • Company: Join Reactive Markets, the award-winning OTC Trading Platform of the Year.
  • Benefits: Enjoy competitive pay, shared on-call responsibilities, and a supportive team culture.
  • Other info: Work in a dynamic, collaborative team focused on innovation and growth.
  • Why this job: Make a real impact in a cutting-edge tech environment with genuine ownership.
  • Qualifications: Experience with columnar databases and operational responsibility for production platforms.

The predicted salary is between 75600 - 92400 Β£ per year.

Remote (UK-based) | Full-Time

About Us

Reactive Markets is the 2026 OTC Trading Platform of the Year (Risk.net). Our network handles over $50 billion in daily trading volumes across FX, Equities, and Cryptocurrency, connecting 40+ of the world's leading liquidity providers. We build trading systems that operate at the edge of what's technically possible β€” where nanoseconds matter and a dropped message costs real money. Our engineering team is small, senior, and deeply invested in the craft of building cutting edge, reliable, high-performance systems.

The Role

We're looking for a Lead ClickHouse Engineer to own our data plant: a multi-datacentre, multi-AZ ClickHouse cluster ingesting billions of rows a day, underpinning compliance, billing, and a growing family of real-time and historical analytics. This is a core-platform engineering role, not a DBA role. You'll own the full engineering scope of a serious ClickHouse estate: cluster operations and upgrades, schema and sorting-key design, materialised views, ingestion performance, query optimisation, workload isolation, capacity planning, storage tiering, backup and recovery, monitoring and alerting, and production support. You'll also set direction and work on the data pipelines around the plant β€” our capture services are Go, and our analytics foundation is Python.

Beyond your own technical ownership, you'll set the standard for how the estate is run, mentor the engineers who work alongside you, and ensure the plant is genuinely supportable by a team rather than dependent on any one person β€” including yourself. You don't need years of ClickHouse specifically β€” deep experience with another columnar or large-scale time-series database qualifies you, and a strong columnar engineer learns our estate quickly. What we do need is genuine operational depth: you have run a production data platform, owned its capacity plan and its recovery procedures, and stayed calm when it mattered.

This hire helps create a follow-the-sun team β€” so the platform is supported across time zones rather than by heroics. On-call is a shared, contracted responsibility, planned and paid β€” not goodwill.

What You'll Work On

  • Cluster operations at scale β€” running, upgrading and evolving a multi-AZ ClickHouse estate on Kubernetes, with rehearsed backup and recovery
  • Schema and query engineering β€” table and sorting-key design, partitioning, materialised views, and query optimisation against multi-terabyte datasets
  • Capacity and observability β€” a measured capacity model, storage tiering and retention, and the Grafana monitoring and alerting that keeps the plant's health visible
  • Ingestion and data quality β€” correctness and completeness gates on the pipelines feeding the plant; reconciliation that proves nothing was dropped
  • Workload isolation β€” keeping ingest, operations, reporting and ad-hoc analytics from treading on each other as read load grows
  • Team and knowledge leadership β€” mentoring the engineer(s) working on the estate, setting standards for runbooks and documentation, and making the plant supportable by the team, not the author
  • AI-assisted operations β€” modern tooling (including MCP-based AI access to the estate) that lets a small team run a large platform well

What We Need

  • Technical:
  • Columnar/OLAP database engineering β€” ClickHouse strongly preferred; deep experience with another columnar or large-scale time-series store (BigQuery, Redshift, Druid, kdb+ or similar) also works
  • A track record of owning architectural decisions for a production data platform, not just operating within one someone else designed
  • SQL depth β€” execution plans, query optimisation, and schema design for very large datasets
  • Operational/SRE experience β€” you have carried production responsibility for a data platform: monitoring, capacity, incidents, recovery
  • Linux and Kubernetes β€” comfort with the operational layer beneath the database
  • A programming language β€” one of Python, Go, R, or MATLAB (Python preferred)
  • Engineering discipline β€” you write proposals, strategies, and architectural documents and diagrams well, and you manage change properly
  • Git β€” excellent version-control practice
  • Distributed-systems fundamentals β€” replication, consistency, failure modes
  • Financial services experience is a plus but not essential β€” domain knowledge can be learned; operational instinct cannot

How you work:

  • You own production. Calm in an incident, rigorous in a post-mortem, honest about what nearly went wrong
  • You measure first. Topology, storage and optimisation decisions follow observed load and cost β€” not fashion
  • You write things down. Runbooks, schema documentation and clean handovers are part of the craft
  • You share knowledge deliberately. The goal is a platform supportable by a team, not a specialist
  • You communicate across time zones. Follow-the-sun only works with clear, proactive handovers
  • You embrace AI as a tool. You use it to amplify your own effectiveness and help shape how it operates safely around production data

What You Get

  • A serious estate β€” genuine scale, genuine criticality: the system of record for a live trading network, not a reporting sidecar
  • Real ownership β€” architectural and technical leadership of a business-critical core platform
  • An excellent team β€” senior engineers who care about craft, collaborate openly, and hold each other to high standards
  • Sustainable operations β€” follow-the-sun coverage by design; on-call is shared, contracted and planned, not heroics
  • Competitive package β€” competitive compensation and benefits aligned to your local market
  • Modern tooling β€” AI-assisted operations and investigation tooling that removes toil rather than adding process
  • Growth β€” the estate is scaling to multiples of today's volume; the role grows with it

We believe in transparency, honest feedback, and writing things down. We celebrate delivery, not activity. We frame AI as empowering people β€” removing toil, amplifying capability, enabling higher-value work.

Our Hiring Process

We keep our process focused and respectful of your time. Our process follows three stages.

  • Stage 1: Initial Conversation with Talent Acquisition - Format: Video call, ~30-45 minutes
  • Stage 2: Hiring Manager Conversation with the relevant team lead or hiring manager - Format: Video call, ~60 minutes
  • Stage 3: Technical Interview with two members of the relevant engineering team - Format: Video call, interactive session, ~60 minutes

What to expect in each stage will be explained by Talent Acquisition if you're invited to interview. Throughout the process, we aim to keep momentum with no unnecessary delays between stages, and feedback typically comes within a few business days.

How to Apply

Please apply directly via this job posting β€” all applications, including those submitted via LinkedIn, are managed through our applicant tracking system, so you'll always land in the same place regardless of where you found this role.

Right to Work: Candidates must have the existing right to work in the country associated with the location advertised for this role (UK or Singapore, as applicable). We are not currently able to offer visa sponsorship for this role in any location.

Equal Opportunities: Reactive Markets is an equal opportunities employer. We welcome applications from all qualified candidates regardless of age, disability, gender reassignment, marriage or civil partnership, pregnancy or maternity, race, religion or belief, sex, or sexual orientation.

Reasonable Adjustments: If you need any adjustments or support during the application or interview process, please let us know β€” we're happy to accommodate.

Data Protection: By applying, you consent to Reactive Markets processing your personal data for recruitment purposes.

Lead ClickHouse Engineer employer: Reactive Markets

Reactive Markets is an exceptional employer, offering a dynamic remote work environment in the UK that fosters innovation and collaboration. With a strong emphasis on employee growth, you will have the opportunity to mentor fellow engineers while working with cutting-edge technologies in a supportive culture that values your contributions to high-performance trading solutions.

R

Contact Details:

Reactive Markets Recruitment Team

StudySmarter Expert Advice🀫

We think this is how you could land Lead ClickHouse Engineer

✨Join Local Tech Meetups

Get out there and mingle with fellow developers by joining local tech meetups. It’s a fantastic way to meet people who might be working at Reactive Markets or know someone who does. Plus, you can pick up some trendy tech skills and trends while you're at it!

✨Contribute to Open Source Projects

Show off your coding chops by jumping into open-source projects. Not only does this give you practical experience, but it also gets you noticed in the dev community. You'll create a killer portfolio that speaks volumes about your skills to Reactive Markets.

✨Tap into Online Developer Communities

Don’t underestimate the power of online developer communities like GitHub, Stack Overflow, and even Reddit. Participate in discussions, share your projects, and build your visibility. We can often find opportunities through these channels that can lead to a full-time gig at companies like Reactive Markets.

✨Explore Job Boards Specifically for Tech Roles

Keep your eyes peeled on job boards that focus on tech roles. Sites like TechCareers or Stack Overflow Jobs can often have listings for companies like Reactive Markets that might not show up on broader job sites. Make it a habit to check these regularly, and don’t hesitate to apply directly through our website!

We think you need these skills to ace Lead ClickHouse Engineer

ClickHouse
Columnar/OLAP database engineering
SQL depth
Query optimisation
Schema design
Operational/SRE experience
Linux

Some tips for your application 🫑

Show off your coding skills:When applying for a software engineering role, it's super important to showcase your coding skills. Make sure your CV includes your tech stack, any relevant programming languages you’re comfortable with, and examples of projects you've worked on. If you have a GitHub profile, link it up! We love to see code in action.

Tailor your portfolio:For a full-time role, we’d expect to see some solid examples of your work in your portfolio. Make sure to include at least two or three projects that highlight your problem-solving skills and your ability to work with different technologies. Focus on the projects that are most relevant to the position at Reactive Markets.

Craft a killer cover letter:Your cover letter is your chance to stand outβ€”make it personal! Explain why you want to work at Reactive Markets and how your skills align with the role. Show us your passion for software development. We dig enthusiastic candidates who understand the value of collaboration and continuous learning!

Be clear and concise:When it comes to writing your CV and cover letter, clarity is key. Avoid jargon that could confuse us and stick to simple, direct language. Highlight your achievements with quantifiable results where possible, and keep everything easy to read. A well-organised application goes a long way!

How to prepare for a job interview at Reactive Markets

✨Brush Up on Your Coding Skills

For a full-time software engineering role, it's crucial that we stay sharp with our coding abilities. Expect technical questions that might involve solving problems on the spot or discussing algorithms. Practise on platforms like LeetCode or HackerRank to get comfortable with the types of questions that often come up.

✨Know Your Tools and Frameworks

Make sure we’re well-acquainted with the tools and technologies listed in the job description. Familiarise ourselves with any specific frameworks or programming languages mentioned. If Reactive Markets uses React or Node.js, for instance, be ready to discuss how we’ve used them in previous projects or coursework.

✨Showcase Your Projects

Bring along a portfolio that highlights our best work. This could be code samples, GitHub repositories, or any side projects we’ve built. Make sure we can talk through our thought process for each project, especially the challenges we faced and how we solved themβ€”this shows our problem-solving skills in action.

✨Prepare for Behavioural Questions

While technical skills are key, full-time positions also require cultural fit. Be ready to discuss our previous experiences and how we handle teamwork, conflict, and deadlines. Brush up on the STAR methodβ€”Situation, Task, Action, Resultβ€”to clearly articulate our past experiences when discussing how we've contributed to a team.