Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Staff Software Engineer, PostgreSQL

Home > Python programming jobs

Staff Software Engineer, PostgreSQL in USA

  • Beacon Biosignals
  • Full time
  • Email
  • 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

Senior/Staff Software Engineer

  • Cohere
  • Full time
  • Remote
  • 11/20/2026
  • Salary: USD 185,000 - 300,000
  • Worldwide

Staff Software Engineer, Data Infrastructure

  • Cohere
  • Full time
  • Remote
  • 11/20/2026
  • Salary: USD 245,000 - 335,000
  • Worldwide

Staff Security Engineer, Detection & Response

  • Juniper Square
  • Full time
  • Others
  • 11/20/2026
  • Bengaluru, India

Staff Software Engineer, ML Platform

  • Gusto
  • Full time
  • USA
  • 11/20/2026
  • Salary: $187k - $284k/yr
  • Denver, CO

Senior Security Engineer, Vulnerability Management

  • Juniper Square
  • Full time
  • Remote
  • 11/20/2026
  • India