Full Stack Engineer

Short description:Backend engineer to build and maintain a Postgres-based data pipeline and API for a legal-tech product. You’ll own the operational and client-facing databases, the one-way sync between them, third-party integrations (court-data vendor, mail, Zoom, public registries), and the API the apps talk to. Security and data isolation are core to the role. USD compensation.Core responsibilities: • Build and evolve PostgreSQL schemas (operational + isolated client DB) • Build ingestion + the data transformer (delta sync, scheduled jobs) • Integrate external APIs and webhooks (Trellis, PostGrid, Zoom, CA SOS, SEC) • Build the backend API and enforce access control (row-level security, audit logging)Must-haves: Python or Node, strong PostgreSQL, REST APIs, cloud (AWS or Azure), experience with data pipelines/ETL and third-party integrations. Reliable async communication for remote work.Required: • 2+ years building backend systems in production • Strong PostgreSQL: schema design, indexing, foreign keys, query tuning • Python or Node.js, and comfortable building and consuming REST APIs • Real experience with third-party API + webhook integrations • Data pipeline / ETL or sync work (scheduled jobs, deltas) • Cloud deployment on AWS or Azure (managed Postgres, networking basics) • Git, and writes testsNice to have: • Security/access-control experience (row-level security, secrets handling, isolated networks) • Worked with PII or other sensitive/regulated data • Some frontend (React) if you want app work too • Document parsing / OCR or LLM API experience (for the enrichment side later)Soft / remote: • Clear written English and reliable async updates • Works independently from written specs, flags blockers early • Overlaps a few hours with your timezone