Overview
On Site
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required
Skills
snowflake
Snow Flake Schema
Transact-SQL
Scalability
SQL
snowsql
Job Details
Snowflake Architect
Location - San Francisco/San Roman ,CA
12 Months Contract Duration
We are looking for a Senior Snowflake Architect with a minimum of 15+ years of experience in database development and 5-6 years of experience in Snowflake development and administration. The ideal candidate will be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.
The following technical skills are required for this role:
- Proficiency in SQL language and cloud-based technologies.
- Extensive experience in T-SQL stored procedures and complex query development.
- Deep knowledge and hands-on experience with Snowflake Platform Architecture
- Proficient in SQL for data validation and querying, with experience in Snow SQL scripts.
- Excellent understanding of Snowflake internals, stages, integrations, and network policies
- Experience in Snow SQL, Snow Pipes, Streams, Dynamic tables and Views.
- Ability to design and implement features for identity and access management
- Expertise in query optimization, data masking and major security competencies, including encryption
- Ability to solve performance and scalability issues within the system
- Proficient in SQL query performance tuning, including use of Query Profiler, micro-partition pruning, data spilling, and understanding optimizer and execution plans
- Experience with productionized data ingestion and processing pipelines using Snow SQL.
- Proficient in designing and implementing CI/CD release pipelines using tools like Redgate Flyway for deploying database scripts and objects to Snowflake.
- Data warehousing concepts, data modeling, metadata management
- Create, test, and implement enterprise-level apps with Snowflake
- Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports.
- Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns.
- Strong ability in documenting solutions and architectures effectively.
- Experience in Azure cloud services including Azure SQL MI, ADLS and ADF, particularly in database and data management contexts.
- Familiarity with tools such as Jira, ServiceNow, Confluence, Azure Devops.
- Excellent communication skills and the ability to work effectively with various technical and business teams.
Regards,
Vipin Goswami
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.