Snowflake · jobs.ashbyhq.com · checked today
Analytics Engineer - Finance
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
Use SQL, Python, Snowflake, dbt, Airflow, and other systems while working within an agile development model to build and maintain data infrastructure for use in reporting, analysis, and automation
must have - Data modelling
Translate reporting, analysis, and automation requirements into data model requirements and specifications
must have - Data quality
Perform data QA and develop automated testing procedures for use with Snowflake data models
must have - Python
Experience using Python to parse, structure, and transform data
must have - SQL
Advanced SQL skills with experience standardizing queries and building data infrastructure involving large-scale relational datasets
must have - Warehousing
Experience with MPP databases such as Snowflake, Redshift, BigQuery, or other relevant technologies
must have - dbt
Use SQL, Python, Snowflake, dbt, Airflow, and other systems while working within an agile development model to build and maintain data infrastructure for use in reporting, analysis, and automation
must have - Governance & security
Provide input into data governance strategies and frameworks including permissions and security models, data lineage systems, and data definitions
must have · not practised here - Cost & performance
Snowflake developed an innovative new product with a built-for-the-cloud architecture that combines the power of data warehousing, the flexibility of big data platforms, and the elasticity of the cloud at a fraction of the cost of traditional solutions.
- GCP
- Experience with MPP databases such as Snowflake, Redshift, BigQuery, or other relevant technologies
not practised here - AWS
- Demonstrated experience in cloud computing platforms (e.g., AWS, Azure, Google Cloud)
not practised here - Azure
- Demonstrated experience in cloud computing platforms (e.g., AWS, Azure, Google Cloud)
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
- Render a byte count for humansFoundations
- Data modelling: the round most people fail≈ 2 h
Data modelling · Warehousing · dbt
- 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
- After the first one finishesFoundations
- Run it for last TuesdayFoundations
- The history nobody keptFoundations
- The spreadsheet is a dependencyFoundations
- Too slow by morningFoundations
- 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: Governance & security, GCP, AWS, Azure.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves tomorrowremoved the moment Snowflake closes it