Staff Software Engineer, PostgreSQL

Home > Python programming jobs

Staff Software Engineer, PostgreSQL in USA new

Beacon Biosignals
Full time
Email

USA
10/15/2026
Report

Remote

Responsibilities

Lead architecture and design for complex Datastore systems and projects.
Design and scale PostgreSQL data models, schemas, indexes, query behavior, and access controls.
Build and operate Kafka-driven event pipelines, including producers, consumers, replay, idempotency, and lag handling.
Develop and evolve GraphQL APIs and services supporting clinical and scientific data workflows.
Own dataset snapshot pipelines into the data warehouse and support third-party integrations.
Design schema migrations, including zero-downtime migrations, dual writes, backfills, lock avoidance, and verification.
Operate PostgreSQL in production, including upgrades, replication, backup and restore, connection pooling, bloat, vacuum behavior, and extensions.
Debug and profile complex problems across system boundaries and improve structure, testing, tooling, documentation, and dashboards.
Write RFCs, guide technical decisions, plan work, and make trade-offs across stakeholder needs.
Mentor engineers, provide actionable feedback, and improve engineering practices.

Requirements

7+ years of backend development experience, including at least 3 years focused on data platforms and backend infrastructure for data-centric applications.
Deep proficiency in at least one of data modeling, distributed systems, API design, or database engineering.
Strong production SQL and PostgreSQL experience, including schema design, indexes, query plans, and query tuning.
Hands-on experience with Kafka or an equivalent event-processing technology such as RabbitMQ, Pulsar, or Amazon Kinesis.
Proficiency in Julia or Python; Julia experience is preferred but not required.
Experience deploying and operating containerized services, with familiarity with Kubernetes and Infrastructure as Code tools such as Terraform or Helm.
Experience mentoring engineers and improving team practices, tooling, test coverage, or documentation.
Strong written and verbal communication skills and experience working effectively across disciplines and in remote or asynchronous teams.
Experience with or interest in LLM-assisted or agentic coding tools in production, including appropriate guardrails.
For the Datastore Systems focus, experience with GraphQL and TypeScript/JavaScript with Node.js and end-to-end event-driven pipeline design.
For the PostgreSQL and Data Modeling focus, deep PostgreSQL query-planner knowledge, data modeling, schema evolution under load, production operations, and the ability to teach and document database practices.

Benefits

100% remote work from anywhere in the U.S.
Access to in-person office hubs in Boston, New York City, and Paris.
Asynchronous work practices designed for a first-class remote experience.
Total compensation includes equity, PTO, and other benefits.

Salary: $170k - $190k/yr

Beacon Biosignals

Beacon Biosignals builds an AI platform and FDA-cleared at-home EEG wearables used by biopharma and clinicians to develop and deliver treatments for neurological, psychiatric, and sleep disorders. It sells clinical development services and software for brain-signal analysis to life sciences partn...

Similar positions

Lead Engineer, Machine Learning

Bjak
Full time

Remote
10/15/2026

Worldwide

Deployed Engineer, Professional Services

LangChain
Full time

Remote
10/15/2026
Salary: Competitive

Singapore, US

Senior Software Engineer

Nuro
Full time

USA
10/15/2026
Salary: $160k - $291k/yr

Mountain View, CA

Senior Software Engineer, Network Development

CoreWeave
Full time

USA
10/15/2026
Salary: $165k - $220k/yr

Bellevue, WA

Senior Software Engineer - Data Engineer

Tekion
Full time

Others
10/15/2026
Salary: Competitive

Bengaluru, India