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: Remote • United States (Physically in USA) Visa Status • USC/GC/GC-EAD/H4-EAD accepted • W2 only (No visa sponsorship available) • 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 • 5 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.