Snowflake Developer
Role details
Job location
Tech stack
Job description
Job Title: Snowflake Developer Location: San Jose, CA Duration: 12+ Months Experience: 5+ Years (3+ Years with Snowflake), We are seeking an experienced Snowflake Developer to design, develop, optimize, and maintain data solutions on the Snowflake Cloud Data Platform. The ideal candidate should have strong expertise in data warehousing, ETL/ELT development, SQL programming, cloud platforms, and performance optimization., Design, develop, and maintain scalable data warehouse solutions using Snowflake. Develop and optimize complex SQL queries, stored procedures, views, and data models. Build and maintain ETL/ELT pipelines using Snowflake and integration tools. Implement data ingestion processes from multiple sources into Snowflake. Optimize Snowflake performance through clustering, partitioning, caching, and query tuning. Develop data transformation logic using Snowflake SQL and Snowpark. Work with business stakeholders to understand reporting and analytics requirements. Implement security controls, RBAC, data masking, and governance policies. Monitor data quality, troubleshoot issues, and ensure data integrity. Collaborate with Data Engineers, BI Developers, Data Scientists, and Cloud teams. Support CI/CD deployment processes and DevOps practices.
Requirements
5+ years of Data Warehouse and ETL development experience. 3+ years of hands-on Snowflake development experience. Strong expertise in Snowflake architecture, virtual warehouses, stages, tasks, streams, and time travel. Advanced SQL programming skills. Experience with ETL/ELT tools such as: Informatica Matillion Talend DBT Fivetran Airflow Experience with cloud platforms: AWS Azure Google Cloud Platform Knowledge of Snowpipe, Snowpark, Dynamic Tables, and Data Sharing. Experience with Python, Java, or Scala for data processing. Understanding of dimensional modeling, star schema, and data warehousing concepts. Experience with Git, Jenkins, CI/CD pipelines. Strong troubleshooting and performance tuning skills. Preferred Skills Snowflake Certifications. Experience with DBT and Data Vault modeling. Knowledge of Power BI, Tableau, or Looker. Experience with Kafka or real-time data streaming. Familiarity with AI/ML data pipelines. Experience working in Agile/Scrum environments., Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.