Snowflake Architect

CloudHive; United States; On-site; USD 100,000 - 120,000; Full time

Job summary

A leading staffing partner in data cloud solutions is seeking a Snowflake Architect for a 6-month contract in the New York City area. The ideal candidate will have over 5 years of experience in data migrations, advanced knowledge of Snowflake SQL, and a strong background in optimizing data pipelines. Responsibilities include leading architectural designs and ensuring compliance with security standards during migrations. A competitive salary ranging from $100,000 to $120,000 is offered.

Qualifications

• 5+ years of experience as a Snowflake Architect or in a similar role.
• Advanced proficiency in Snowflake SQL, Snowpark, and integration with AWS.
• Hands-on experience with data modeling and warehousing.

Responsibilities

• Architect and lead Snowflake migration including schema design.
• Optimize performance and data loading using Snowflake features.
• Collaborate with cross-functional teams to define migration strategies.

Skills

Snowflake SQL

Data migration

ETL processes

Data modeling

Collaboration

Education

Snowflake certification (SnowPro Core/Advanced Architect)

Tools

dbt

AWS

Fivetran

Matillion

Job description

Direct message the job poster from CloudHive

President | Snowflake Squad Member | Sales & Technical Sales Pro ❄

CloudHive is your North America and LATAM Snowflake-focused staffing partner. We help accelerate Snowflake adoption and maximize the value of the Snowflake AI Data Cloud by delivering experienced, on-demand Snowflake contractors and specialized talent acquisition services.

We are seeking an experienced Snowflake Architect for a 6-month contract supporting a key client's data migration project. You'll design and implement scalable architectures to migrate legacy systems to Snowflake, ensuring seamless data pipelines, optimization, and security.

Key Responsibilities:

• Architect and lead Snowflake migration, including schema design, ETL processes, and integration with tools like dbt, Fivetran, or Matillion.
• Optimize performance, data loading, and query efficiency using Snowflake features (e.g., clustering, materialized views, and resource monitors).
• Collaborate with cross-functional teams to define migration strategies, handle data quality checks, and implement governance best practices.
• Ensure compliance with security standards (e.g., role-based access, encryption) during the migration.

Requirements:

• 5+ years of experience as a Snowflake Architect or similar role, with proven expertise in large-scale data migrations.
• Advanced proficiency in Snowflake SQL, Snowpark, and integration with cloud platforms (AWS).
• Hands-on experience with data modeling, warehousing, and tools like dbt
• Snowflake certification (e.g., SnowPro Core/Advanced Architect) preferred.

Please get in touch for more information. Strictly no third parties.

New York, NY $100,000.00-$120,000.00 3 weeks ago

New York City Metropolitan Area $169,000.00-$269,000.00 5 days ago

Referrals increase your chances of interviewing at CloudHive by 2x

Get notified about new Architect jobs in New York City Metropolitan Area.