Senior Data Engineer

The Role: We’re looking for a senior data engineer to own our data platform from architecture through production, reliably turning high volumes of data from provider APIs, webhooks, files, and web scraping into trusted records for our products. Today, our enrichment and extraction workflows largely run serially inside a container. You’ll lead the move to a platform that supports concurrent processing, event-driven intake, and orchestrated batch workflows. Responsibilities: Multi-source intake: Build concurrent ingestion for provider APIs, webhooks, files, and scraping, with rate limits and failure handling. Batch and event-driven execution: Orchestrate scheduled workflows and historical backfills using tools such as Airflow, Dagster, or Prefect. Build event-driven intake with Pub/Sub or Cloud Tasks, including retries, dead-letter queues, and controlled replay of failed work. Raw-to-curated data: Preserve original payloads, including provider JSON, in Google Cloud Storage (GCS) before transforming them with dbt. Establish medallion layers for raw, standardized, and curated data. Correctness through recovery: Implement idempotent upserts and safe retries, replay, and historical backfills that avoid duplicate records or data corruption. Make data traceable to its source and safe to reprocess. Data quality and delivery: Define data contracts, build automated validation and pipeline tests, and monitor freshness and failures. Design and optimize PostgreSQL schemas, queries, and loa