Talent.com
Lorven Technologies Inc.
Lead Software Engineer with ClickHouse, TerraformLorven Technologies Inc. • langley, bc, ca
No longer accepting applications
Lead Software Engineer with ClickHouse, Terraform

Lead Software Engineer with ClickHouse, Terraform

Lorven Technologies Inc. • langley, bc, ca
5 days ago
Job type
  • Full-time
Job description

Hi

Role: Lead Software Engineer

Location: Canada- Remote

Working hours - PST time zone from 9 till 5 pm.

Skills: ClickHouse,Kubernetes, Terraform, Helm charts

Contract role


Job description:

What you’ll do

  • ● Lead the migration of large-scale logs and distributed traces from existing Analytics Database to ClickHouse
  • ● Design scalable ClickHouse schemas optimized for high-ingestion telemetry workloads
  • ● Architect ingestion pipelines for logs and trace data
  • ● Translate existing queries and data models into performant ClickHouse equivalents
  • ● Develop and execute backfill and cutover strategies to ensure seamless migration
  • ● Optimize query performance, partitioning, storage layout, and retention strategies
  • ● Benchmark and validate performance under production-scale workloads
  • ● Establish monitoring, alerting, and operational best practices for ClickHouse
  • ● Design and support alerting workflows powered by ClickHouse queries
  • ● Document architecture decisions, tuning approaches, and operational runbooks
  • ● Partner with platform and SRE teams to ensure production readiness


Responsibilities

  • ● Design and tune distributed ClickHouse clusters (sharding, replication, partitioning)
  • ● Configure and optimize MergeTree engines, TTL policies, indexing, and compression
  • ● Improve ingestion throughput and query latency at scale
  • ● Deploy and operate ClickHouse workloads in Kubernetes environments
  • ● Implement backup and restore strategies
  • ● Identify and resolve performance bottlenecks
  • ● Ensure reliability, scalability, and maintainability of the platform
  • ● Support security and production-readiness reviews


Basic Qualifications

  • ● 12+ years of experience in backend, infrastructure, or data platform engineering
  • ● Hands-on production experience with ClickHouse
  • ● Strong experience with Terraform and Helm charts
  • ● Experience deploying and operating stateful systems on Kubernetes
  • ● Strong understanding of distributed systems and high-throughput ingestion architectures
  • ● Experience designing schemas for large-scale analytical or telemetry workloads
  • ● Strong SQL skills and performance tuning expertise
  • ● Experience migrating data between large-scale analytical systems
  • ● Familiarity with at least one major cloud provider: Azure, GCP, or AWS



Email:

Create a job alert for this search

Lead Software Engineer with ClickHouse, Terraform • langley, bc, ca

Similar jobs

Lead Principal Software Engineer - Auxo | Growth Partner

Auxo | Growth Partnercoquitlam, bc, ca
Full-time

SaaS products and platforms at scale.You’ll work closely with the Head of Product & Technology to shape technical direction across multiple teams.This is a high-impact IC role where you’ll influenc... Show more

 • Promoted

Applied Ai Software Engineer

Photonic Inc.Coquitlam, Canada
Full-time

Compensation The base annual salary range for this full-time role is between $156,200 to $214,800.This range reflects the minimum and maximum target range for new hire base salary across all Canadi... Show more

 • Promoted

Senior Oracle Application Developer - PwC Canada

PwC Canadalangley, bc, ca
Full-time

Please review this posting in detail and self-assess your eligibility, before applying.PwC Canada is sourcing for two (x2) Secret (Level II) security cleared, Senior Oracle Application Developer, C... Show more

 • Promoted

Software Engineer – Advanced Systems - Draganfly Inc.

Draganfly Inc.coquitlam, bc, ca
Full-time

Company”) has been a recognized technology leader within the commercial UAV space for over two decades.We helped establish the commercial market & adoption of multi-rotor helicopters for public saf... Show more

 • Promoted

Sr AWS Cloud Engineer (Banking/Capital Markets) - coquitlam

companycoquitlam, bc, ca
Full-time

Senior AWS Cloud Engineer / Sr AWS DevOps (10+ years of experience).Duration: 6mo (high change of extension).Location: Downtown Toronto or remore (within Canada only).AWS cloud infrastructure / pla... Show more

 • Promoted

Senior Software Engineer, AI Applications

Safe FleetCoquitlam, British Columbia, Canada
Full-time

At Safe Fleet our name says it all.We make fleet vehicles – and everyone in and around them – safer.Our fleet safety platform brings together best-in-class products, ground-breaking technology, and... Show more

 • Promoted

Senior Full Stack Engineer - $160,000 - $210,000 A Year - Remote

Acceler8 TalentLangley, Canada
Remote
Full-time

Develop sophisticated software using React, TypeScript, and Node.Collaborate with cross-functional teams and mentor junior developers. Show more

 • Promoted

Director of Microsoft Cloud and Cloud Solution Provider (CSP )Operations - langley

Buchanan Technologieslangley, bc, ca
Full-time +1

Director of Microsoft Cloud & CSP Operations.Remote, anywhere in North America.The Director of Microsoft Cloud & CSP Operations is responsible for the day-to-day management and optimization of the ... Show more

 • Promoted

Director of Microsoft Cloud and Cloud Solution Provider (CSP )Operations - coquitlam

Buchanan Technologiescoquitlam, bc, ca
Full-time +1

Director of Microsoft Cloud & CSP Operations.Remote, anywhere in North America.The Director of Microsoft Cloud & CSP Operations is responsible for the day-to-day management and optimization of the ... Show more

 • Promoted

Data Engineer - Minimum 12+ years experience

NLB Serviceslangley, bc, ca
Full-time

Lead the migration from Glue/Redshift to Databricks.Deep, hands-on experience with Apache Spark (PySpark and Spark SQL), including performance tuning (partitioning, shuffles, skew, caching, file si... Show more

 • Promoted

Sr AWS Cloud Engineer (Banking/Capital Markets)

companycoquitlam, bc, ca
Full-time

Senior AWS Cloud Engineer / Sr AWS DevOps (10+ years of experience).Duration: 6mo (high change of extension).Location: Downtown Toronto or remore (within Canada only).AWS cloud infrastructure / pla... Show more

 • Promoted

Manufacturing Software Engineer

Epoch BiodesignCoquitlam, British Columbia, Canada
Full-time

Free from aging grids, fragile supply chains, and unnecessary extraction.At Moment Energy, we’re building a world where clean power is abundant, affordable, and uninterrupted for everyone.The world... Show more

 • Promoted

Full Stack Developer (Azure Platform) - C$64 - C$70 An Hour - Remote

Pyramid Consulting, Inc.Langley, Canada
Remote
Temporary

Develops full-stack applications using React/Angular,.Js, and Azure services, including Azure SQL and Cosmos DB, for a 12+ month contract. Show more

 • Promoted

Sr AWS DBT Engineer

Mastech Digitalcoquitlam, bc, ca
Full-time

Design and implement robust dimensional and relational data models.Own transformation and modeling of curated (Silver/Gold) datasets.Collaborate with analysts, product analytics, data scientists, a... Show more

 • Promoted

Lead Principal Software Engineer

Auxo | Growth Partnercoquitlam, bc, ca
Full-time

SaaS products and platforms at scale.You’ll work closely with the Head of Product & Technology to shape technical direction across multiple teams.This is a high-impact IC role where you’ll influenc... Show more

 • Promoted

Senior Software Engineer, Ai Applications

Safe FleetCoquitlam, Canada
Full-time

About The PositionMeet the Smart Safety Company.At Safe Fleet our name says it all.We make fleet vehicles – and everyone in and around them – safer.Our fleet safety platform brings together best-in... Show more

 • Promoted

Senior Full-Stack Engineer — Build Secure Systems

Booz Allen HamiltonCity of Langley, Metro Vancouver Regional District, CA
Full-time

An advanced technology company is looking for a Senior Full Stack Software Engineer to resolve problems with end-to-end solutions in a fast-paced environment.The ideal candidate has 4+ years of exp... Show more

 • Promoted

Guidewire Developer/Tech Lead - Delta System & Software, Inc.

Delta System & Software, Inc.langley, bc, ca
Full-time

Job Title: Guidewire Tech Lead.Must have: Guidewire ACE Certification.Strong hands-on experience in PolicyCenter, BillingCenter, or ClaimCenter (v10.Lead and mentor a team of developers, driving de... Show more

 • Promoted

Senior Oracle Application Developer - coquitlam

PwC Canadacoquitlam, bc, ca
Full-time

Please review this posting in detail and self-assess your eligibility, before applying.PwC Canada is sourcing for two (x2) Secret (Level II) security cleared, Senior Oracle Application Developer, C... Show more

 • Promoted

DevOps Engineer (AI)

Affinitycoquitlam, bc, ca
Full-time

Client: Enterprise class EMR provider.On behalf of our client, Affinity is seeking a DevOps Engineer to build and evolve the infrastructure behind its flagship EMR platform.You’ll own Kubernetes-ba... Show more