Data Engineer

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. 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