Data Engineer

Purple Drive

Data Engineer Share Contractual San Francisco, CA PDT - 8151 8-10 09/04/2025

Overview:

The ideal candidate would be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.

• 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.

• 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

• 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

• Data warehousing concepts, data modeling, metadata management

• Create, test, and implement enterprise-level apps with Snowflake

Desirable Skills:

• Experience in integrating Snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.

• 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 Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is plus