We are seeking a skilled Snowflake Developer to design, build, and optimize high-performance cloud data warehouses. You will write complex analytical transformations in dbt, build data models inside Snowflake, and integrate ingestion pipelines orchestrated by Azure Data Factory (ADF).

Key Responsibilities

- Snowflake Development: Build, maintain, and optimize Snowflake objects (Tables, Views, Streams/Tasks, Agile Tables, Storage Integrations, and RBAC).

- Data Transformation: Write modular SQL models, macros, and tests in dbt to transform raw data into clean Star-Schema / Dimensional Data Marts.

- Pipeline Integration: Partner with data teams to integrate ADF ingestion pipelines and Snowpipe auto-ingestion with Snowflake.

- Performance Optimization: Monitor query performance, tune Virtual Warehouse usage, implement clustering keys, and optimize dbt materializations (Incremental/Table).

- Code Management: Maintain version control (Git) and support automated deployment (CI/CD) of dbt models and Snowflake scripts.

📌 Snowflake Developer (Mumbai)
🏢 Orcapod Consulting Services
📍 Mumbai