Data Engineer
Summary
Remote Data Engineer role building data pipelines and ETL/ELT workflows with Dagster, dbt, ClickHouse, and lakehouse architectures (Iceberg, Delta Lake). Responsibilities include OLTP→OLAP warehouse migration, data modeling, CDC pipelines, and data quality engineering using Great Expectations.
Ambush is a people first company where talented, thoughtful individuals come together to build meaningful products and lasting partnerships. We believe the best work happens when people feel supported, trusted and empowered to bring their full abilities to the table.
Since 2015, because of our people first and long term mindset, we have grown into a partner relied on by some of the best companies in the world. We combine strong engineering, design and strategy with a growing strength in AI to help our clients see what is next and achieve bigger outcomes.
At the heart of everything we do is our team. We collaborate, take risks, lift each other up and take pride in doing work the right way, not settling for a quick makeshift solution. If you join Ambush, you join a group of people who want you to succeed and who show up for each other every day.
We believe in and expect real teamwork, a constant drive to be better, and delivering meaningful long term outcomes that we can be proud of together.
Since 2015, because of our people first and long term mindset, we have grown into a partner relied on by some of the best companies in the world. We combine strong engineering, design and strategy with a growing strength in AI to help our clients see what is next and achieve bigger outcomes.
At the heart of everything we do is our team. We collaborate, take risks, lift each other up and take pride in doing work the right way, not settling for a quick makeshift solution. If you join Ambush, you join a group of people who want you to succeed and who show up for each other every day.
We believe in and expect real teamwork, a constant drive to be better, and delivering meaningful long term outcomes that we can be proud of together.
What we'd like to see in a candidate:
Skill set/experience:
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
Tools & technologies:
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