Snowflake Performance Engineer / Snowflake Specialist

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - Independent
Contract - 6 Month(s)

Skills

Snowflake
Teradata
Python
Advanced SQL (window functions
recursive queries)
Snowflake Architecture
Virtual Warehouses
Multi-cluster Warehouses
Micro-partitions
Table Clustering
Auto Reclustering
Materialized Views
Time Travel
Zero Copy Cloning
SnowPipe
Streams
Data Sharing
ETL
Data Integration
AWS Cloud
BI Tools
Amazon Web Services
Cloud Computing
Clustering
Cost Estimation
Data Security
Extract
Transform
Load
JavaScript
Management
Performance Tuning
Query Optimization
Reporting
SQL
Snow Flake Schema
Streaming
Workflow

Job Details

Job Title: Snowflake Performance Engineer / Snowflake Specialist
Location: Sunnyvale, CA 94085 (3 days onsite per week)
Duration: 6+ Months


Job Description:
Apple is seeking a highly skilled Snowflake Performance Engineer / Snowflake Specialist with deep expertise in Snowflake, Teradata, and Python. The ideal candidate will have 8+ years of experience designing, developing, and optimizing Snowflake environments, with strong performance tuning and ETL skills.

Must-Have Skills:

  • Snowflake (Architecture, Virtual Warehouses, Micro-partitions, Table Clustering, Auto Reclustering, Materialized Views, Time Travel, SnowPipe, Data Sharing, Streams, JavaScript Procedures & Tasks)

  • Teradata

  • Python

Experience Required: 8+ years in each of the above must-have skills

Nice-to-Have Skills:

  • Cloud experience (preferably AWS)

  • ETL processes from multiple source systems

  • BI tools knowledge

  • Advanced SQL (window functions, recursive queries, query optimization)

Key Responsibilities:

  • Design and optimize Snowflake workflows and SQL for internal reporting systems.

  • Analyze queries using Query Profile and identify performance bottlenecks.

  • Apply advanced SQL to rewrite complex queries for performance optimization.

  • Design tables, choose clustering keys, and manage micro-partitions for optimal performance.

  • Implement data protection strategies using Snowflake Time Travel and Zero Copy Cloning.

  • Manage multi-cluster warehouses, horizontal vs vertical scaling, and autoscaling strategies.

  • Work with materialized views, evaluating benefits vs cost.

  • Estimate task effort accurately and meet deadlines for both ad-hoc and long-term projects.

Certifications: Not required

Interview/Work Requirements:

  • Must be available 3 days per week onsite in Sunnyvale, CA.

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.

About ITBrainiac Inc