Key skills

Data pipeline engineeringETLELTData orchestrationWorkflow managementMedallion architectureLakehouse architectureDatabase migrationWarehouse migrationOLTPOLAPData modelingData qualityData validationData contractsData integrityIdempotencyDeterministic IDsExactly-once semanticsChange Data CaptureEvent-driven pipelinesMonitoringAlertingDagsterAirflowPrefectClickHousePostgreSQLAmazon AuroradbtPythonPandasPyArrowPydanticSQLAlchemyApache IcebergDelta LakeDuckDBApache ParquetGreat ExpectationsSodadbt tests

About this role

Ambush is a people first company where talented, thoughtful individuals come together to build meaningful products and lasting partnerships. They are seeking a Senior Data Engineer to work on data pipeline engineering, orchestration, and maintaining data quality and integrity.

Responsibilities:

Data pipeline / ETL & ELT engineering
Data orchestration & workflow management
Medallion / lakehouse architecture (Bronze → Silver → Gold)
Database & warehouse migration (OLTP → OLAP)
Data modeling
Data quality, validation & data contracts
Data integrity & idempotency (deterministic IDs, exactly-once semantics)
Change Data Capture (CDC) & event-driven pipelines
Observability, monitoring & alerting

Requirements:

Data pipeline / ETL & ELT engineering
Data orchestration & workflow management
Medallion / lakehouse architecture (Bronze → Silver → Gold)
Database & warehouse migration (OLTP → OLAP)
Data modeling
Data quality, validation & data contracts
Data integrity & idempotency (deterministic IDs, exactly-once semantics)
Change Data Capture (CDC) & event-driven pipelines
Observability, monitoring & alerting
Orchestration: Dagster (also Airflow, Prefect)
Data warehouse / OLAP: ClickHouse, PostgreSQL / Amazon Aurora
Transformation: dbt, Python (pandas, PyArrow, Pydantic, SQLAlchemy)
Open table formats / lakehouse: Apache Iceberg, Delta Lake, DuckDB, Apache Parquet
Data quality: Great Expectations, Soda, dbt tests
Senior-level