Staff Data Warehouse Platform Engineer

Athelas; Mountain View (CA); On-site; USD 210,000 - 275,000; Full time

Job summary

Commure is hiring a Staff Software Engineer to own Commure's data warehouse platform end-to-end. You will design, build, and operate every layer of the stack: CDC pipelines, data lake, query layer, transformation layer, and the analytics-facing tooling that sits on top.

The core stack includes Debezium, StarRocks, and dbt. This hands-on IC role involves architectural decisions, coding, and setting patterns for other teams to follow, with HIPAA and SOC 2 considerations baked in from day one.

Qualifications

• 6+ years of software engineering experience, with significant time building or operating data platforms at scale.
• Experience across the modern data stack: CDC (Debezium or equivalent), streaming (Kafka, Redpanda), data lake formats (Iceberg, Delta, Hudi), an MPP or lakehouse query engine (StarRocks, ClickHouse, Trino, Snowflake, Databricks), and dbt.
• Fluent in SQL, schema design, query optimization, and reasoning about cost and latency trade-offs on large datasets.

Responsibilities

• Own the data warehouse platform end-to-end: CDC pipelines, data lake, query layer, transformation layer, and the analytics-facing tooling that sits on top.
• Design and operate CDC pipelines with Debezium (and Kafka, Redpanda, or an equivalent streaming backbone) that move data from operational databases into the warehouse with low latency and high fidelity.
• Architect the data lake on object storage using an open table format (Iceberg, Delta Lake, or Hudi) with Parquet, enabling both batch and streaming workloads and clean separation of storage from compute.
• Run and scale StarRocks (or adjacent MPP/lakehouse engines) as the query and serving layer - schema design, materialized views, ingestion patterns, tuning, and cost/performance trade-offs.
• Build the transformation layer with dbt: modeling standards, tests, documentation, and a semantic layer that gives every team a single source of truth for metrics.
• Stand up orchestration (Airflow, Dagster, or similar) and the CI/CD, observability, and data-quality tooling that make the platform trustworthy day-to-day.
• Partner with Security and Compliance on PHI/PII handling, access controls, lineage, and auditability so the platform meets HIPAA and SOC 2 bar by default.
• Set patterns and conventions: schema contracts, ingestion patterns, and self‑serve tooling - that let product and analytics teams build on the platform without needing you in the loop for every decision.

Skills

SQL

Data modeling

System design

Data quality

On-call

Tools

Debezium

StarRocks

dbt

Kafka

Iceberg

Delta Lake

Hudi

Airflow

Dagster

Job description

Commure is hiring a Staff Software Engineer to own Commure's data warehouse platform end-to-end. You will design, build, and operate every layer of the stack: CDC pipelines, data lake, query layer, transformation layer, and the analytics-facing tooling that sits on top.

The core stack includes Debezium, StarRocks, and dbt. This hands-on IC role involves architectural decisions, coding, and setting patterns for other teams to follow, with HIPAA and SOC 2 considerations baked in from day one.