Snowflake Solutions Architect

Overview

Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - Long Term

Skills

Data Engineering
Access Control
ELT
Workflow
Collaboration
Query Optimization
Leadership
Mentorship
Auditing
Meta-data Management
Data Architecture
RBAC
Data Masking
Real-time
SQL
Snow Flake Schema
Scripting
Performance Tuning
Data Modeling
Cloud Computing
Amazon Web Services
Microsoft Azure
Google Cloud Platform
Google Cloud
Privacy
HIPAA
Communication
Stakeholder Management
Documentation
Informatica
Data Governance
Financial Services
Health Care
Oracle UCM
OM
WebKit
SANS
IMG

Job Details

Snowflake Solution Architect

Location: Remote

No H1B
Job Description:
We are seeking a highly skilled and hands-on Snowflake Solution Architect to lead enterprise-scale architecture initiatives across multiple domains including Data Clean Room, Data Governance, RBAC, Data Ingestion, Data Engineering, and FiveTran integrations. The ideal candidate will bring deep technical expertise, a strategic mindset, and a proven ability to implement secure, scalable Snowflake solutions aligned with modern data architecture principles.
Key Responsibilities:
Architect and implement Data Clean Room solutions using Snowflake's privacy-preserving features for secure multi-party collaboration.
Design and enforce robust Data Governance and RBAC (Role-Based Access Control) frameworks to ensure secure and compliant data access.
Lead the design of data ingestion pipelines using tools like FiveTran, and ensure integration from multiple structured and semi-structured sources.
Optimize ELT workflows and performance across the Snowflake ecosystem.
Collaborate with data engineers, analysts, governance, and security teams to deliver unified, scalable data solutions.
Define and implement best practices around data modeling, query optimization, role design, and cost efficiency.
Provide architectural leadership, documentation, and mentoring to internal technical teams.
Support audit, lineage, and metadata tracking aligned with enterprise governance standards.
Required Qualifications:
10+ years of experience in data architecture or engineering with 6+ years on Snowflake.
Proven hands-on experience with Snowflake Data Clean Room design and implementation.
Strong understanding of RBAC policies, role hierarchy, row-level security, and dynamic data masking in Snowflake.
Deep experience in data ingestion architecture, including FiveTran, and real-time/batch pipelines.
Proficient in SQL, Snowflake scripting, and data performance optimization.
Experience with data modeling, data transformation, and cloud-native integrations (AWS, Azure, or Google Cloud Platform).
Strong knowledge of data privacy regulations (e.g., GDPR, HIPAA, CCPA).
Excellent communication, stakeholder management, and documentation skills.
Preferred Qualifications:
SnowPro Advanced Architect Certification strongly preferred.
Experience with DBT, Airflow, Informatica, or similar tools.
Exposure to data governance platforms (e.g., Collibra, Alation).
Experience in regulated environments (e.g., Financial Services, Healthcare AdTech).

Navnish kumar

Sr. IT Technical Recruiter

Stellent IT Phone:

Email: navnish
Gtalk: navnishom

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.