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

Lead Software Engineer with ClickHouse, Terraform

Lorven Technologies Inc. • langley, bc, ca
3 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

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

Delta System & Software, Inc.coquitlam, 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 - 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

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

Data Engineer - Minimum 12+ years experience

NLB Servicescoquitlam, 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

Senior Analytics (AWS DBT) Engineer

Mastech Digitallangley, bc, ca
Full-time

We are seeking a Senior AWS DBT Engineer to play a critical role in transforming an existing analytics ecosystem into a modern, scalable Databricks + dbt architecture (Bronze → Silver → Gold).This ... Show more

 • Promoted

Lead Principal Software Engineer

Auxo | Growth Partnerlangley, 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

DevOps Engineer (AI)

Affinitylangley, 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

 • 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

Lead Software Engineer with ClickHouse, Terraform

Lorven Technologies Inc.coquitlam, bc, ca
Full-time

Working hours - PST time zone from 9 till 5 pm.Skills: ClickHouse,Kubernetes, Terraform, Helm charts.Lead the migration of large-scale logs and distributed traces from existing Analytics Database t... Show more

 • Promoted

Software Engineer – Advanced Systems - Draganfly Inc.

Draganfly Inc.langley, 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

Staff Software Engineer

FactoryFixcoquitlam, bc, ca
Full-time

FactoryFix helps manufacturers and staffing firms recruit skilled trades workers.We operate a large network of skilled trades candidates, and we use that data to help industrial companies find, eng... Show more

 • Promoted • New!

Workday Integration Engineer / Lead

VDartlangley, bc, ca
Full-time

Job Title: Workday Integration Engineer / Lead (Orchestration, Extend, APIs, Event-Driven).We are seeking a Workday Integration Engineer/Lead with strong hands-on experience designing and deliverin... Show more

 • Promoted • New!

Lead Software Engineer with ClickHouse, Terraform - Lorven Technologies Inc.

Lorven Technologies Inc.coquitlam, bc, ca
Full-time

Working hours - PST time zone from 9 till 5 pm.Skills: ClickHouse,Kubernetes, Terraform, Helm charts.Lead the migration of large-scale logs and distributed traces from existing Analytics Database t... 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

Sr AWS DBT Engineer

Mastech Digitallangley, 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

Site Reliability Engineer

E-ITlangley, bc, ca
Full-time

Mandatory: Dynatrace / Splunk / Cloud / Exp in creating SLA / Kubernetes / Managing Kubernetes !!.We are seeking a Site Reliability Engineer (SRE) to join our dynamic team, focusing on the reliabil... Show more

 • Promoted • New!

Shopify QA Engineer - Sultans

Sultanscoquitlam, bc, ca
Full-time

Job Title: Shopify QA Engineer.Location: Remote (North America).Industry: E-Commerce / Technology.MUST HAVE: QA & Shopify Experience.Sultans is a Shopify Platinum Plus Partner delivering premium Sh... Show more

 • Promoted • New!

Staff Software Engineer - FactoryFix

FactoryFixlangley, bc, ca
Full-time

FactoryFix helps manufacturers and staffing firms recruit skilled trades workers.We operate a large network of skilled trades candidates, and we use that data to help industrial companies find, eng... Show more

 • Promoted • New!

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) - Affinity

Affinitylangley, 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