Staff Software Engineer, PostgreSQL

This is a fully remote position, open to applicants in United States.

📋 Description

• Lead the design and architecture of intricate projects and systems within the Datastore.

• Convert requirements from product, scientific, clinical, and engineering stakeholders into integrations, services, and scalable data-platform solutions.

• Diagnose and analyze ambiguous issues that span system boundaries, enhancing structure, test coverage, and tooling.

• Implement features while maintaining high standards for data integrity, design quality, and maintainability.

• Create RFCs and oversee complex feature exploration and technical design stages.

• Organize both individual and team tasks, balancing speed, adaptability, technical debt, and stakeholder requirements.

• Educate and mentor engineers, offering actionable feedback, and potentially serve as a technical leader.

• Enhance the operational robustness and usability of the Datastore through documentation, tools, and dashboards.

• Take ownership of event pipelines, GraphQL APIs, core data models, third-party integrations, and/or PostgreSQL performance, operations, and access controls.

• Collaborate with platform, application, scientific, clinical, product, and support teams.

⛳️ Requirements

• Over 7 years of backend development experience, with at least 3 years dedicated to data platforms and backend infrastructure for data-centric applications.

• Highly skilled in at least one of the following: data modeling, distributed systems, API design, or database engineering.

• Strong command of SQL and practical experience with PostgreSQL as an application database.

• Experience in crafting and optimizing complex SQL queries and understanding schema design, indexes, and query plans.

• Practical experience with data streaming and event processing using Kafka or an equivalent such as RabbitMQ, Pulsar, Amazon Kinesis, or another cloud-based counterpart.

• Proficient in Julia or Python; experience in Julia is a significant advantage but not mandatory.

• Experience in deploying and managing services within containerized environments.

• Familiar with Kubernetes and Infrastructure as Code tools like Terraform and/or Helm.

• Proven record of mentoring engineers and enhancing team practices, tooling, test coverage, or documentation.

• Exceptional written and verbal communication abilities.

• Self-motivated and experienced in thriving in hybrid or fully remote teams.

• Experience with, or interest in, LLM-assisted or agentic coding tools in production.

• For the Datastore Systems role: Proficiency in GraphQL and TypeScript/JavaScript (Node.js); knowledge of end-to-end event-driven pipeline design; expertise in complex systems design.

• For the PostgreSQL & Data Modeling role: Extensive PostgreSQL knowledge including query planner, index selection, EXPLAIN (ANALYZE), data modeling, schema evolution under load, zero-downtime migrations, lock avoidance, backfill and verification, and production PostgreSQL operations.

🏝️ Benefits

• Equity.

• Paid time off (PTO).

• Strong asynchronous work practices.

• Remote work experience.

• Access to in-person office hubs located in Boston, New York City, and Paris.