Snowflake SME

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.