Senior Data Engineer building Dandy’s data infrastructure for its technology - powered dental operating system. Developing pipelines, governed data products, and AI - ready platform capabilities.
About the role
- Senior engineer scaling petabyte-scale PostgreSQL infrastructure for TRM Labs’ AI-powered crime-fighting intelligence platforms. Automating database operations, optimizing performance, and managing CDC pipelines remotely.
Responsibilities
- Develop, operate, and scale relational database systems serving data at petabyte scale
- Own the database serving layer end to end, including query performance, cost, and availability
- Tune queries, design indexes, and optimize schemas for petabyte-scale Postgres/Citus
- Use AI-assisted analysis to identify compression and data-model opportunities and ship validated production changes
- Build agentic automation for database operations such as pgbouncer provisioning, disk scaling, and blue-green deployments
- Drive validation of database changes before production deployment
- Manage CDC pipelines using PeerDB, Fivetran, and Debezium and debug replication failures
- Migrate workloads from first-generation infrastructure and prototype new data stores
- Create AI-native runbooks and internal tooling
- Coordinate schema changes across product-engineering teams
- Participate in an on-call rotation approximately once every 15 days, with each shift a 24-hour window across two days
Requirements
- 5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres)
- Deep SQL optimization skills, including Explain Plans, CTEs, window functions, partitioning, index design, and query-planner behavior in distributed environments
- Hands-on experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte
- Fluency with database profiling using pganalyze or equivalent
- Production automation experience in Python or Go
- Daily use of AI coding tools such as Claude and Copilot
- Track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems
- Ability to work across US and Canada working hours
- Willingness and ability to participate in an on-call rotation approximately once every 15 days, subject to regional compliance review
Benefits
- Equity plan eligibility
- Remote/distributed work arrangement
- Async-first work culture
- Minimal, purposeful meetings
- Competitive benefits, wellness programs, and time away from work, varying by country and local employment requirements
Job title
Job type
Experience level
Salary
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior Data Engineer supporting the Government of Alberta’s Data Management Platform. Building, monitoring, and modernizing Talend integrations, ETL/ELT pipelines, APIs, and data services.
Data Engineer building cloud data pipelines, models, and analytics infrastructure for Boeing’s aviation programs. Supporting machine learning applications and data governance from Richmond/Vancouver.
Data Engineer building cloud - based data pipelines and analytics infrastructure for Boeing’s aviation programs. Supporting machine learning, data governance, and high - performance systems from Richmond/Vancouver.
Data Engineer building trusted data pipelines for Crux’s clean - energy capital platform. Automating surveys, reporting datasets, and research queries for Market Intelligence.
ETL Data Engineer designing Informatica ETL pipelines and Hadoop workflows. Supporting SQL - driven reconciliation, data quality, BI reporting, and analytics solutions.
Data Engineer building Spark pipelines and analytics data models for Dropbox’s file collaboration platform. Supporting datamarts, KPIs, data quality, and production reliability.
Staff Software Engineer owning ingestion and integration architecture for Northbeam’s marketing intelligence platform. Setting data - processing standards across ad, commerce, and real - time event systems.
Data systems engineer building Python pipelines and APIs for Northbeam’s marketing intelligence platform. Improving integrations, transformations, monitoring, and real - time data flows.
Data Engineer designing scalable data pipelines and cloud solutions. Delivering analytics and business intelligence consulting projects for Electric Mind clients.