Data Engineer – Snowflake

Job Description

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 Transfer available (Need I-140 approved candidates only)
* No 3rd party or C2C candidates

Responsibilities:

* Design and implement features for identity and access management.
* Implement novel query optimization and 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.