Snowflake SME

Remote, USA
Posted Jun 12, 2026
Full-time

Snowflake SME

100% Remote

Contract

Role Overview

We are seeking a Snowflake Subject Matter Expert (SME) / Architect with proven expertise in data platform architecture, migration, and optimization. The ideal candidate will hold relevant Snowflake certifications and have hands-on experience in migrating large-scale data workloads from AWS to Snowflake. This role requires strong technical leadership, solution design, and collaboration with cross-functional teams to deliver scalable, secure, and high-performance data solutions.

Key Responsibilities

  • Lead the end-to-end migration of data platforms from AWS to Snowflake.
  • Architect and design Snowflake data warehouse solutions aligned with business needs.
  • Ensure best practices in performance tuning, security, and cost optimization.
  • Collaborate with data engineers, analysts, and business stakeholders to define requirements.
  • Provide technical leadership and SME guidance on Snowflake capabilities.
  • Document architecture, workflows, and migration strategies for transparency and reusability.
  • Stay updated with Snowflake advancements and recommend improvements.

Required Qualifications

  • Snowflake certifications (SnowPro Core, Advanced Architect, or equivalent).
  • 8+ years of experience in data engineering / data architecture, with at least 5+ years focused on Snowflake.
  • Proven experience in AWS-to-Snowflake migration projects.
  • Strong knowledge of AWS services (S3, Redshift, Glue, Lambda, etc.) and integration with Snowflake.
  • Expertise in SQL, ETL/ELT pipelines, and data modeling.
  • Familiarity with security, compliance, and governance frameworks in cloud data platforms.
  • Excellent communication and stakeholder management skills.

Preferred Skills

  • Experience with Python, Spark, or DBT for data transformations.
  • Knowledge of BI/Analytics tools (Tableau, Power BI, Looker).
  • Exposure to multi-cloud environments and hybrid data strategies.

More Remote Jobs