Data Architect (Snowflake)

SaasWorx; Austin (TX); Remote; USD 150,000 - 210,000; Full time

Job summary

SaasWorx is seeking a Data Architect – Snowflake to design and deliver modern cloud data platforms for enterprise clients. You will lead discovery workshops, mentor engineers, and coordinate across onshore/offshore teams to ensure successful project execution.

The role requires strong consulting and architecture skills, with deep Snowflake expertise and experience in data modernization initiatives across North American clients.

Qualifications

• 5+ years in Data Engineering with 3+ years in Data Architecture and Snowflake.
• Hands-on Snowflake architecture, administration, performance tuning.
• Experience leading enterprise-scale data modernization and cloud transformations.
• Experience managing client-facing engagements and offshore teams.
• Strong consulting and stakeholder communication skills.

Responsibilities

• Serve as Snowflake domain expert; advise on architecture, governance, performance.
• Lead discovery workshops and assessments; capture business objectives.
• Design scalable Snowflake platforms for analytics, reporting, AI, operations.
• Develop data models, metadata frameworks, ERDs and data dictionaries.
• Architect and optimize Snowflake warehouses, marts, ingestion frameworks.
• Design ELT/ETL pipelines using Snowpipe, dbt, Fivetran, MuleSoft, Python, Spark.
• Implement and optimize Snowflake features including clustering, time travel, RBAC.
• Ensure security, governance, scalability, reliability, and performance.

Skills

Snowflake Architecture

Data Modeling

Data Modernization

Stakeholder Management

Consulting

ETL/ELT Pipelines

Snowflake Features

RBAC & Security

Cloud Platforms (AWS/GCP/Azure)

Python / PySpark

SQL / SnowSQL

Leadership & Delivery

Offshore Coordination

Education

Bachelor's in CS/IT/Data Science/Engineering

Master's degree preferred

Tools

Snowpipe

Materialized Views

dbt

Fivetran

MuleSoft

Openflow

SnowSQL

Job description

Role Overview

SaasWorx is seeking a highly skilled and customer-focused Data Architect – Snowflake to lead the design, architecture, and delivery of modern cloud data platforms for enterprise customers.

This role combines deep Snowflake architecture expertise with engagement leadership responsibilities, requiring the individual to collaborate closely with client stakeholders, lead discovery and solution design workshops, and coordinate effectively with offshore delivery teams to ensure successful project execution.

The ideal candidate will bring strong consulting, architecture, and delivery management experience, with the ability to bridge business objectives and technical execution across complex data modernization initiatives.

Key Responsibilities

Data Architecture & Solution Leadership

• Serve as a Snowflake domain expert, advising customers on modern data architecture best practices, governance, scalability, and performance optimization.
• Lead discovery workshops and customer assessments to understand business objectives, reporting needs, integration requirements, and current-state data landscapes.
• Design scalable and secure Snowflake-based data platforms supporting analytics, reporting, AI, and operational use cases.
• Develop enterprise data models, data dictionaries, metadata frameworks, and entity relationship diagrams (ERDs).
• Architect and optimize Snowflake data warehouses, marts, and ingestion frameworks for structured and semi-structured data.
• Design and implement scalable ELT/ETL pipelines leveraging technologies such as Snowpipe, dbt, Fivetran, MuleSoft, Python, and PySpark.
• Implement and optimize Snowflake platform capabilities including clustering, materialized views, RBAC, resource monitors, workload optimization, zero-copy cloning, and time travel.
• Ensure solutions adhere to enterprise standards for security, governance, scalability, reliability, and performance.

Engagement & Delivery Leadership

• Lead end-to-end delivery of Snowflake and data modernization engagements for North America customers.
• Coordinate daily execution activities across Business Analysts, Data Engineers, Architects, QA resources, and offshore technical teams.
• Lead recurring customer meetings, architecture reviews, working sessions, and project status calls.
• Support pre-sales and solutioning activities by contributing to discovery sessions, architecture recommendations, implementation estimates, and Statements of Work (SOWs).
• Ensure successful knowledge transfer and collaboration between onshore customer-facing teams and offshore engineering teams.
• Mentor and guide junior engineers and architects while fostering delivery excellence and continuous learning.

Innovation & Continuous Improvement

• Stay current with evolving Snowflake capabilities, cloud-native technologies, AI/data trends, and modern architecture patterns.
• Drive automation, monitoring, observability, and operational excellence initiatives across customer data platforms.
• Recommend continuous improvements to optimize platform performance, scalability, and cost efficiency.

Required Skills & Experience

• 5+ years of experience in Data Engineering with at least 3+ years focused on Data Architecture and Snowflake implementations.
• Strong hands-on expertise with Snowflake architecture, administration, and performance optimization.
• Proven experience leading enterprise-scale data modernization and cloud transformation initiatives.
• Experience managing customer-facing engagements and coordinating distributed offshore delivery teams.
• Strong consulting and stakeholder management skills with the ability to communicate effectively with both technical and business audiences.
• Expertise with Snowflake features including:
• Snowpipe
• Materialized Views
• Clustering
• Zero Copy Cloning
• Time Travel
• Resource Monitors
• RBAC and Security Frameworks
• Semi-Structured Data Processing
• Strong SQL and SnowSQL development experience including stored procedures, transformations, and advanced query optimization.
• Hands-on experience with Python, PySpark, Bash, and automation frameworks for ingestion, orchestration, and monitoring.
• Experience with modern ELT/integration technologies including dbt, Fivetran, MuleSoft, Openflow, or similar platforms.
• Strong understanding of cloud ecosystems including AWS, GCP and Azure.
• Experience integrating Snowflake with enterprise applications including Salesforce and other SaaS platforms.
• Strong analytical, troubleshooting, and problem‑solving capabilities.
• Excellent communication, leadership, and collaboration skills in a consulting‑driven environment.

Preferred Qualifications & Certifications

• Snowflake certifications such as SnowPro Core and/or SnowPro Advanced strongly preferred
• Experience working within consulting or professional services organizations.
• Exposure to AI/ML, advanced analytics, and enterprise data modernization programs.
• Experience supporting industries such as Financial Services, Healthcare, Manufacturing, Real Estate, or Retail is a plus.

Educational Qualifications

• Bachelor’s degree in Computer Science/information Technology/Data Science, Engineering, or related field required.
• Master’s degree (MBA, MS, or equivalent) preferred.

Work Location

This role will support customers across the United States and may require travel based on customer and business needs.

Work Authorization Requirement

Candidates must be authorized to work in the United States on a permanent basis. This role is open only to U.S. Citizens and U.S. Permanent Residents (Green Card holders).