Staff Software Engineer, PostgreSQL
Core
Lead architecture and design for complex Datastore systems, scaling PostgreSQL data models, and building Kafka-driven event pipelines for clinical and scientific data workflows.
Role type
Staff Software Engineer (Data Platform & Database Engineering)
Builds
Scalable PostgreSQL data models, Kafka event pipelines, GraphQL APIs, and dataset snapshot pipelines into the data warehouse.
Domain
Healthcare/Scientific Data, Distributed Systems, Database Engineering
Required skills
PostgreSQL (schema design, query tuning, replication, backup), Kafka (producers, consumers, idempotency), GraphQL, Python, Julia, Kubernetes, Terraform, Infrastructure as Code, Event-driven architecture, System design, Mentoring
Preferred skills
LLM-assisted coding tools, TypeScript/JavaScript, Node.js, Zero-downtime migration strategies
Technologies
PostgreSQL, Kafka, GraphQL, Python, Julia, Kubernetes, Terraform, Helm, Node.js
Responsibilities
Design and scale PostgreSQL data models, schemas, indexes, and query behavior; Build and operate Kafka-driven event pipelines; Develop and evolve GraphQL APIs; Design schema migrations including zero-downtime strategies; Operate PostgreSQL in production including upgrades and replication; Mentor engineers and improve engineering practices.
Seniority
Staff, hands-on IC with significant mentorship and architectural leadership