Snowflake Developer

Job Description
Snowflake Developer

Should have strong hands-on experience in building and supporting data pipelines, transformations, and reporting solutions on Snowflake. The ideal candidate should have excellent SQL skills, a strong understanding of Snowflake features, and the ability to develop reliable, efficient, and secure data solutions. This role will work closely with data engineering, analytics, and architecture teams to support business data needs. Day-to-day responsibilities include designing scalable data models, building and maintaining pipelines, improving data governance, and collaborating with cross-functional teams to ensure efficient data workflows. Additional responsibilities will include troubleshooting, addressing performance issues, and implementing best practices for data security and compliance.

Key Responsibilities

• Develop and maintain data pipelines and transformation workflows in Snowflake.
• Write efficient SQL queries, views, stored procedures, and reusable components.
• Load, transform, and manage structured and semi-structured data in Snowflake.
• Support data ingestion and processing using Snowpipe, Streams, and Tasks.
• Optimize query performance, warehouse usage, and job execution.
• Support data modeling activities for analytics and reporting requirements.
• Implement secure data access using roles, grants, masking policies, and secure views.
• Troubleshoot pipeline failures, data quality issues, and production support incidents.
• Participate in code reviews, testing, and deployment activities.
• Collaborate with business and technical teams to translate requirements into implementation.

Mandatory Skills

• Strong hands-on experience in Snowflake development.
• Strong SQL development and debugging skills in Snowflake.
• Experience with Snowflake objects such as databases, schemas, tables, views, virtual warehouse.
• Hands-on experience with Snowpipe, Snowspark, Streams, Tasks, Dynamic Tables or Materialized Views.
• Experience in writing and maintaining stored procedures, UDFs, and views.
• Experience with Snowflake data sharing and replication.
• Experience with CI/CD pipelines for Snowflake deployments, Git, DevOps practices, and Infrastructure as Code.
• Experience with ETL/ELT processes, data integration, and building data pipelines.
• Good understanding of query optimization and performance tuning in Snowflake.
• Experience handling semi-structured data such as JSON, Avro, Parquet, or ORC in Snowflake.
• Experience with Snowflake security and access control concepts, including roles, grants, masking policies, and secure views.
• Experience with Time Travel and Zero-Copy Cloning.
• Strong understanding of data loading, transformation, and operational support in Snowflake.
• Ability to troubleshoot and resolve Snowflake-related development issues independently.
• Good communication and collaboration skills.
• Experience working in agile teams.