Snowflake · jobs.ashbyhq.com · checked today
Data Engineer
At Snowflake, we are powering the era of the agentic enterprise. To usher in this new era, we seek AI-native thinkers across every function who are energized by the opportunity to reinvent how they work. you possess an innate curiosity, treating AI as a high-trust collaborator that is core to how you solve problems and accelerate your impact.
Skills, with evidence
- Airflow / orchestration
Build and support Apache Airflow DAGs that orchestrate Snowflake workloads reliably.
must have - Data quality
Apply data quality checks and help monitor Snowflake warehouse cost and performance.
must have - Python
Strong SQL and working Python skills, including basic query tuning and schema design.
must have - SQL
Strong SQL and working Python skills, including basic query tuning and schema design.
must have - Warehousing
- Apply data quality checks and help monitor Snowflake warehouse cost and performance
- dbt
- Develop dbt models with tests and documentation that follow team standards and governance practices
- Cost & performance
- Apply data quality checks and help monitor Snowflake warehouse cost and performance
- Data modelling
- 3+ years of hands-on experience building data pipelines or data models in a production environment
- Schema evolution & contracts
- Awareness of data contracts or schema registry tooling
- Streaming
- Familiarity with streaming ingestion such as Kafka or Snowpipe Streaming
- AWS
- Experience with AWS, Azure, or GCP, including infrastructure-as-code
not practised here - Azure
- Experience with AWS, Azure, or GCP, including infrastructure-as-code
not practised here - GCP
- Experience with AWS, Azure, or GCP, including infrastructure-as-code
not practised here - Governance & security
- Develop dbt models with tests and documentation that follow team standards and governance practices
not practised here
Your plan
- The SQL screen: correct, then fast≈ 1 h
Data quality · SQL
- Average order value by countryFoundations
- Line items per orderFoundations
- Revenue by buyer countryFoundations
- Customers who never orderedFoundations
- Hiring funnel by roleFoundations
- Python: the data-wrangling round≈ 2 h
Python
- Clean spreadsheet headers into column namesFoundations
- Events normalization jobFoundations
- List the distinct composite keysFoundations
- Deduplicate rows, first one winsFoundations
- Remove repeats from a sorted list of partitionsFoundations
- Data modelling: the round most people fail≈ 2 h
Warehousing · dbt · Data modelling
- Marketplace core entitiesFoundations
- Cinema seat bookingFoundations
- City parking baysFoundations
- Dating app matchesFoundations
- Food delivery ordersFoundations
- Pipeline design: safe to run twice≈ 3 h
Airflow / orchestration · Schema evolution & contracts · Streaming
- After the first one finishesFoundations
- Run it for last TuesdayFoundations
- The column that vanishedFoundations
- The history nobody keptFoundations
- The key that does not matchFoundations
- Spark: read the plan Spark actually ran≈ 2 h
Cost & performance
- HAVING vs WHERE: where does a filter after groupBy actually run?Foundations
- partitionBy("country"): what does partition pruning look like in the plan?Foundations
- Predicate pushdown: equality, ranges, and the filter that cannot be pushedFoundations
- Revenue by country: read the DAG behind one groupByFoundations
- Too many small files: where do they cost you, and how does compaction help?Foundations
- Say it out loud≈ 1 h
25 drills · Foundations + Intermediate≈ 10 hours
Not covered by the plan: AWS, Azure, GCP, Governance & security.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 3 dremoved the moment Snowflake closes it