What are the responsibilities and job description for the Need Snowflake Developer (California Locals) position at SRS Consulting Inc?
Job Title: Snowflake Developer Location: San Jose, CA Duration: 12 Months Experience: 5 Years (3 Years with Snowflake)
Job Summary
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.
Key Responsibilities
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.
Required Skills
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.
Education
Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.