C
Staff Data Engineer – Data Modeling
·Israel
Not specifiedFull-timeData EngineeringLogisticsSupply ChainTransportation
Lead data modeling and pipeline development, from business requirements to scalable datasets. Own data correctness, optimize queries, and collaborate with cross-functional teams to deliver high-quality data.
Responsibilities
- Translate business and product requirements into scalable data models, transformations, and pipelines.
- Design and own datasets across bronze, silver, and gold layers, including defining grain, aggregations, and data contracts.
- Develop and maintain SQL-heavy data pipelines and Airflow DAGs.
- Ensure data correctness for key business metrics and perform root cause analysis.
- Define and drive best practices for SQL, data modeling, and pipeline design.
- Optimize queries and data models for performance, scalability, and cost efficiency.
- Collaborate with product managers, analysts, and BI developers to refine requirements.
- Develop AI agents to accelerate data analysis.
- Work with complex data inputs and incorporate them into robust data pipelines.
Requirements
- 7+ years of experience as a Data Engineer or Architect with ownership of end-to-end data solutions.
- Strong expertise in writing and optimizing complex SQL queries.
- Proven experience building and maintaining Airflow DAGs or similar orchestration tools.
- Deep understanding of data modeling principles and medallion architecture.
- Ability to understand business needs and translate them into scalable data solutions.
- Demonstrated experience debugging data issues and tracing discrepancies in critical metrics.
- Proficient in Python for orchestration and data workflows.
- Comfortable reading and reasoning about existing code, SQL, DAGs, schemas, and input data formats.
- Experience with cloud data warehouses such as Snowflake, BigQuery, or Databricks.
Nice to have
- Experience with Snowflake and its extended SQL and nuances.
- Experience with Iceberg.
- Experience with Spark.
- Experience with AWS.