Staff PostgreSQL and ClickHouse Architect
Nue
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-LjbffrReference: WJ-4483_1626302 · Posted 14 Nov 2026, 03:30 AM