07 Nov
|
Nue AI
|
Toronto
We're looking for a Staff Engineer, Datastores to be the technical lead for every system at Nue that stores, moves, and serves data. You'll set the long-term direction for our datastore platform, own its reliability, performance, and cost, and get it ready for 10x growth, while staying hands‑on with the hardest problems. Our data layer is polyglot: PostgreSQL on AWS (RDS, NeonDB) runs our multi‑tenant transactional workloads, ClickHouse runs analytics and reporting, and caching and streaming systems connect them. As a dedicated datastore lead, you'll decide how these systems fit together, which workloads belong where, and the standards every product team follows. If you want company‑wide scope, deep technical ownership, and the chance to build the datastore function from the ground up at a fast‑growing SaaS company, this is the role for you. Set the datastore strategy — Own the multi‑year technical vision and roadmap for Nue's data layer across PostgreSQL, ClickHouse, caching, and streaming, and align engineering leadership behind it. Own the fleet end to end — Be accountable for the reliability, availability, performance, and cost of every production datastore, and define the SLOs, error budgets, and operational standards they're held to. Lead the scale‑out architecture — Assess how our multi‑tenant data layer needs to grow, choose the right approach (partitioning, read scaling, tenant isolation, sharding, or a different datastore), and deliver it, including tenant placement and online rebalancing where needed, to support 10x growth. Lead the migration to fully managed, highly available PostgreSQL — Define the strategy, testing plan, and rollout for moving off self‑managed RDS instances (Aurora/NeonDB), with zero data loss and minimal downtime.
Own the analytics data layer — Lead ClickHouse architecture, including table engines, partitioning and ordering keys, materialized views, and the CDC and ingestion pipelines (e.g., Decide what belongs where — Guide product teams on the right datastore and data model for each workload (OLTP, OLAP, cache, queue), and prevent sprawl with clear patterns and paved paths. Make performance proactive — Build the monitoring, alerting, load testing, and capacity models that catch slow queries, replication lag, connection saturation, merge pressure, and storage growth before customers do, and answer "How many more customers can we support?" with data. Architect for resilience — Own replication topologies, read/write separation, failover, backup and restore, and disaster recovery, with RPO/RTO targets that are defined, tested, and met through regular drills. Enable secure, continuous delivery — Establish zero‑downtime schema migration practices (backward‑ and forward‑compatible changes, online DDL, migration tooling in CI/CD) that every team uses. Raise the bar across engineering — Review schema and query designs, write the standards and design docs others build on, mentor engineers, and act as a force multiplier for Billing, Lifecycle, Data & Integrations, and DevEx. Secure the data layer — Own encryption in transit and at rest, access controls, secrets rotation, tenant isolation, and audit logging in line with SOC 2 Type II and GDPR.
Lead with AI‑powered tooling — Use AI throughout the role, from migration planning and query optimization to runbook automation and incident response, and set the example for how the team uses it. You take your turn on on‑call, help ship releases, fix broken CI/CD pipelines, and pick up general infrastructure work when the team needs it, and you lead the response to major datastore incidents. Grow the function — Shape how datastore engineering grows at Nue, including hiring, onboarding, and the operating model as the team scales. 10+ years in backend, infrastructure, or data platform engineering, including 5+ years owning production databases at scale in SaaS environments. ~ A track record of Staff‑level impact — you've set technical direction across multiple teams, led multi‑quarter initiatives to completion, and aligned senior engineers and leadership around hard trade‑offs. ~ Expert‑level PostgreSQL — internals (MVCC, vacuum, WAL, the planner), query optimization and EXPLAIN analysis, indexing, partitioning, and replication. ~ Hands‑on experience with a columnar/OLAP datastore , ideally ClickHouse (or Druid, Pinot, Snowflake, BigQuery): schema design, ingestion, and performance tuning for analytical workloads. ~ Designed and operated horizontally scaled, multi‑tenant database architectures (e.g., Led large‑scale database migrations with zero data loss and minimal downtime. ~ Deep experience with managed databases on AWS — RDS, Aurora, and/or serverless PostgreSQL (NeonDB, Aurora Serverless v2, Supabase, etc.). ~ Solid platform engineering foundations — Infrastructure as Code (Terraform/OpenTofu, CloudFormation), connection pooling (PgBouncer, RDS Proxy), schema migration tooling (Flyway
📌 Engineering Assistant I (Toronto)
🏢 Nue AI
📍 Toronto