Staff Data Engineer – Data Modeling

Requirements

-

7+ years of experience as a Data Engineer or Architect or in a similar data-focused role, with clear ownership of end-to-end data solutions.

-

Strong expertise in writing and optimizing complex SQL queries (advanced joins, aggregations, performance tuning).

-

Proven experience building and maintaining Airflow DAGs (or similar orchestration tools), focused on workflow logic, code, and SQL rather than infrastructure.

-

Deep understanding of data modeling principles, including designing datasets at the correct grain and preventing data inconsistencies. Use of the medallion model.

-

Strong ability to understand business needs and translate them into scalable, maintainable data solutions.

-

Demonstrated experience debugging data issues and tracing discrepancies in critical business metrics across pipelines.

-

Proficient in Python for orchestration and data workflows.

-

Comfortable reading and reasoning about existing code, SQL, DAGs, schemas, and input data formats (e.g., JSON).

-

Experience working with cloud data warehouses such as Snowflake, BigQuery, or Databricks.

-

Experience in Snowflake and its extended SQL and nuances is a strong advantage.