We are currently seeking a Snowflake Junior Engineer to join our team. The role involves designing and implementing Snowflake schemas, tables, views, materialized views, and stages to support migrated workloads. The successful candidate will have 2-4 years of experience in Data Engineering / DW development, with 2+ years on Snowflake.
Requirements
- Design and implement Snowflake schemas, tables, views, materialized views, and stages to support migrated workloads.
- Recreate/translate Yellowbricks tables, views, and logic into Snowflake with functional equivalence.
- Collaborate with dbt developers to ensure dbt models are aligned with Snowflake best practices (clustering, micro-partitioning, warehouses).
- Develop and optimize SQL scripts, stored procedures (Snowflake Scripting), and views used by dbt, Databricks, and BI tools.
- Implement and manage Snowflake roles, grants, and security models in line with enterprise standards.
- Support performance tuning for complex queries, including warehouse sizing, result caching, clustering, and statistics.
- Assist with data migration and validation between Yellowbricks and Snowflake (row counts, aggregates, and spot checks).
- Contribute to CI/CD implementation for Snowflake objects (using Azure DevOps or similar).
- Work closely with onshore architects and leads, attending overlap meetings in US time zones as required.