IT & Software

Staff PostgreSQL and ClickHouse Architect

Nue

Toronto · Ontario · Canada

Architect Nue's PostgreSQL and ClickHouse systems while guiding migrations, analytics, and multi-tenant scaling from a remote or hybrid Canadian setting. Own the data layer's future.

This Staff Engineer, Datastores role combines deep database engineering with company-wide architectural leadership. You will determine workload placement across transactional, analytical, caching, and streaming systems. Your scope includes AWS managed PostgreSQL, ClickHouse architecture, schema design, replication, capacity planning, and standards that product teams follow.

Key Responsibilities:

  • Guide datastore choices for OLTP, OLAP, cache, and queue workloads
  • Lead ClickHouse tables, ingestion pipelines, and analytical performance
  • Design partitioning, read scaling, sharding, and tenant isolation
  • Define migration testing and zero-downtime rollout strategies
  • Review schemas, queries, design documents, and team standards

Requirements:

  • Staff-level impact across teams and multi-quarter technical initiatives
  • Expert PostgreSQL internals, indexing, partitioning, and EXPLAIN analysis
  • Columnar datastore experience with schema, ingestion, and tuning
  • Production experience operating horizontally scaled database architectures
  • Strong Terraform, scripting, pooling, migration tooling, and observability foundations

Apply database architecture, ClickHouse analytics, PostgreSQL depth, and cross-team technical leadership to Nue's company-wide data systems.

#J-18808-Ljbffr

Reference: WJ-4483_1626302 · Posted 14 Nov 2026, 03:30 AM

Find more on GigBlow

This role is listed on GigBlow for discovery and search. Hiring decisions and applications are handled by the employer or their chosen application system.

Browse jobs