Snowflake Architect

Overview

On Site
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 day((s))

Skills

Tableau
AWS
CI/CD
Azure
SQL
Development
ETL
Talend
Spark
Informatica
scala
integration
design
Apache
gcp
powerbi
snowflake
Banking
RBAC
elt
Performance tuning
DBT
data security
Snowflake architect
snowflake solutions

Job Details

Job Title: Snowflake Architect
Location: New York City, NY (Locals Only Onsite)
Type: Contract
Experience Level: 10+ Years

Job Summary:

We are seeking a highly skilled Snowflake Architect based in New York City to lead the design, implementation, and optimization of our Snowflake data platform. This role requires a deep understanding of data warehousing, cloud platforms, and Snowflake architecture best practices. The ideal candidate must be local to NYC and available to work onsite (hybrid setup if needed).

Key Responsibilities:

  • Lead the architecture, design, and deployment of scalable and secure Snowflake solutions.
  • Collaborate with data engineers, analysts, and business stakeholders to define technical requirements.
  • Develop and optimize data pipelines for ingestion and transformation using Snowflake and related tools.
  • Implement performance tuning and workload management strategies in Snowflake.
  • Drive data governance, security, and compliance standards in Snowflake.
  • Design data models for analytics, reporting, and machine learning.
  • Integrate Snowflake with various ETL/ELT tools, APIs, and BI platforms.
  • Mentor junior team members and lead data architecture reviews.

Required Skills & Experience:

  • 10+ years of experience in data engineering, cloud data architecture, or similar roles.
  • 5+ years of hands-on experience architecting solutions on Snowflake.
  • Strong expertise in SQL, performance tuning, and cost optimization within Snowflake.
  • Experience with ETL/ELT tools like DBT, Informatica, Talend, Apache Airflow, etc.
  • Knowledge of data modeling (dimensional, star/snowflake schema) and metadata management.
  • Proficiency in cloud platforms (AWS, Azure, or Google Cloud Platform) with integration experience.
  • Familiarity with Python, Scala, or Spark for data transformation tasks.
  • Solid understanding of CI/CD pipelines, version control, and DevOps in a data context.
  • Strong knowledge of data security, RBAC, and compliance best practices.

Nice to Have:

  • Snowflake certification (SnowPro Core or Advanced Architect).
  • Experience integrating Snowflake with Power BI, Tableau, or Looker.
  • Background in financial services or Banking domains is a plus.
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.