Snowflake Developer

SRS Consulting Inc

San Jose, CA, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Java (Programming Language) Artificial Intelligence Airflow Amazon Web Services Microsoft Azure Business Intelligence Development Cloud Computing Computer Programming Continuous Integration Data Integrity Extract Transform Load (ETL) Data Masking

+30 more

Data Transformation Data Sharing Data Vault Modeling Data Warehousing DevOps Dimensional Modeling Python (Programming Language) Performance Tuning Query Optimization Role-Based Access Control Power BI SQL Stored Procedures SQL Databases Tableau (Software) Talend Data Processing Freeform SQL Google Cloud Cloud Platform System Data Ingestion Snowflake Git Information Technology Star Schema Integration Frameworks Apache Kafka Stream Processing Looker Analytics Data Pipelines Jenkins

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.