Snowflake Developer

📋 Description

• Lead delivery of Snowflake features from design to production.
• Design Snowflake objects: tables, views, streams, tasks.
• Build and maintain ELT pipelines using Boomi, dbt, or SQL into Snowflake.
• Architect Bronze/Silver/Gold data layers per platform standards.
• Develop and optimize complex SQL for transformation and reporting.
• Coach IC1/IC2 developers and lead technical design discussions.

🎯 Requirements

• 4-7 years of Snowflake development in production data environments.
• Strong SQL skills: window functions, CTEs, recursive queries, advanced aggregations.
• Snowflake features: streams, tasks, dynamic tables, time travel, zero-copy cloning.
• Experience building ELT/ETL pipelines from Salesforce, NetSuite, or ERP platforms.
• Understanding of dimensional modelling and data warehousing concepts (star schema, SCD).
• Snowflake access controls: roles, grants, and row/column-level security; Git and CI/CD.

🎁 Benefits

• SnowPro Core or Advanced Data Engineer certification.
• Experience with dbt for transformation orchestration.
• Exposure to Boomi as an integration tool feeding Snowflake.
• Familiarity with Salesforce data structures and reporting requirements.
• Experience with NetSuite financial data extraction and modelling.
• Knowledge of data observability tooling (Monte Carlo, Great Expectations, or similar).