We are seeking a skilled Snowflake Developer with 8+ years of experience in designing, developing, and optimizing Snowflake data solutions. The ideal candidate will have strong expertise in Snowflake SQL, ETL / ELT pipelines, and cloud data integration. This role involves building scalable data warehouses, implementing efficient data models, and ensuring high-performance data processing in Snowflake.
Key Responsibilities :
Snowflake Development & Optimization :
- Design and develop Snowflake databases, schemas, tables, and views following best practices.
- Write complex SQL queries, stored procedures, and UDFs for data transformation.
- Optimize query performance using clustering, partitioning, and materialized views.
- Implement Snowflake features (Time Travel, Zero-Copy Cloning, Streams & Tasks).
Data Pipeline Development :
Build and maintain ETL / ELT pipelines using Snowflake, Snowpark, Python, or Spark.Integrate Snowflake with cloud storage (S3, Blob) and data ingestion tools (Snowpipe).Develop CDC (Change Data Capture) and real-time data processing solutions.Data Modeling & Warehousing :
Design star schema, snowflake schema, and data vault models in Snowflake.Implement data sharing, secure views, and dynamic data masking.Ensure data quality, consistency, and governance across Snowflake environments.Performance Tuning & Troubleshooting :
Monitor and optimize Snowflake warehouse performance (scaling, caching, resource usage).Troubleshoot data pipeline failures, latency issues, and query bottlenecks.Work with DevOps teams to automate deployments and CI / CD pipelines.Collaboration & Documentation :
Work closely with data analysts, BI teams, and business stakeholders to deliver data solutions.Document data flows, architecture, and technical specifications.Mentor junior developers on Snowflake best practices.Required Skills & Qualifications :
8+ years in database development, data warehousing, or ETL.4+ years of hands-on Snowflake development experience.Strong SQL or Python skills for data processing.Experience with Snowflake utilities (SnowSQL, Snowsight, Snowpark).Knowledge of cloud platforms (AWS / Azure) and data integration tools (Coalesce, Airflow, DBT).Certifications : SnowPro Core Certification (preferred).Preferred Skills :
Familiarity with data governance and metadata management.Familiarity with DBT, Airflow, SSIS & IICSKnowledge of CI / CD pipelines (Azure DevOps).(ref : hirist.tech)