Snowflake Solutions Architect (Azure)

NucleusTeq; Phoenix (AZ); Hybrid; USD 120,000 - 150,000; Full time

Job summary

A leading tech company is looking for a Snowflake Solutions Architect to design and implement an enterprise Snowflake Data Platform on Azure. The role involves architecting multi-zone data layers and migrating data assets from legacy systems. Candidates should have 8–12 years of experience in data architecture and deep knowledge of Azure components, along with strong SQL and ELT skills. This hybrid role allows for 2-3 onsite days per week.

Qualifications

• 8–12 years of experience in data architecture, with 3–5 years specifically in Snowflake on Azure.
• Strong SQL, ELT, and multi-zone Snowflake architectures.
• Deep knowledge of Azure components such as ADLS and Data Factory.

Responsibilities

• Lead the design and implementation of an enterprise-grade Snowflake Data Platform on Azure.
• Architect multi-zone data layers and define governance frameworks.
• Migrate legacy ETL pipelines into a modern Snowflake environment.

Skills

Data architecture

Snowflake on Azure

SQL

ELT

Data modeling

Azure components (ADLS, Data Factory, Synapse)

Data governance

Leadership

Communication skills

Job description

Role : Snowflake Solutions Architect (Azure Environment)

Location : Phoenix, AZ / Rockville, MD

Working Mode: Day 1 onsite (2-3 days in a week – hybrid model)

Role Overview

Nucleusteq is seeking a Snowflake Solutions Architect to lead the design and implementation of an enterprise-grade Snowflake Data Platform hosted on Microsoft Azure. The candidate will architect multi-zone (Bronze, Silver, Gold) data layers, define governance frameworks, and lead the migration of legacy ETL pipelines and data assets into the modern Snowflake environment.

Key Responsibilities

• Architect and implement Snowflake on Azure, integrating with ADLS, Synapse, and other enterprise systems.
• Design and establish Bronze (Raw), Silver (Curated), and Gold (Presentation) data layers following best practices.
• Define and implement data ingestion, transformation, and orchestration frameworks using dbt, Airflow, or equivalent tools.
• Migrate existing ETL pipelines and data workloads from on-premise or legacy systems (e.g., Fiserv, CardWorks, PCFS).
• Implement security, compliance, and monitoring (RBAC, masking, lineage, cost tracking).
• Collaborate with teams to ensure PCI DSS, SOX, and GLBA compliance.
• Set up data quality validation rules, audit controls, and performance tuning.
• Mentor engineers and analysts on Snowflake optimization and best practices.

Required Skills & Experience

• 8–12 years of experience in data architecture; 3–5 years with Snowflake on Azure.
• Expertise designing multi-zone Snowflake architectures (Bronze/Silver/Gold).
• Strong SQL, ELT, and data modeling (3NF, Dimensional, Data Vault).
• Deep knowledge of Azure components – ADLS, Data Factory, Synapse, Key Vault.
• Experience in data governance, metadata management, and cost optimization.
• Strong leadership and communication skills.