We are seeking a Senior Snowflake Developer. The ideal candidate will be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.
Location: Hybrid
- San Francisco, CA (3 days in office)
Visa Status:
- USC/GC/GC-EAD/H4-EAD accepted
- H1B (Need I-140 approved for the sponsorship)
- No 3rd party or C2C candidates
Responsibilities:
- Design and implement features for identity and access management.
- Implement novel query optimization, major security competencies with encryption.
- Solve performance issues and scalability issues in the system.
- Create, test, and implement enterprise-level apps with Snowflake.
- Data warehousing concepts, data modeling, metadata management
Mandatory Qualifications:
- 10 years of experience in database development
- 4 years of experience in Snowflake development and administration
- Bachelors degree or 7 yrs hands-on experience
Preferred Qualifications:
- Knowledge of SQL language and cloud-based technologies
- Profound knowledge and hands-on experience in Snowflake Platform Architecture.
- Proficient in SQL for data validation and querying, with experience in Snow SQL scripts.
- Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake.
- Extensive experience in T-SQL stored procedures and complex query development.
- Experience in SQL query performance tuning, including proficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans.
- Experience with productionized data ingestion and processing pipelines using Snow SQL
- Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns.
- Strong ability in documenting design solutions effectively.
- Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway.
- Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.
- Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is a plus.
