Data Architect (Snowflake)

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

Job summary

SaasWorx is seeking a Data Architect – Snowflake to lead the design and delivery of cloud data platforms for enterprise customers in the United States. You will serve as a Snowflake domain expert, guide architecture decisions, and own end-to-end data modernization engagements.

Ideal candidates bring 5+ years in data engineering with 3+ years in Snowflake architecture, strong SQL/SnowSQL skills, and hands-on experience with dbt, Fivetran, MuleSoft, Python, and PySpark.

Qualifications

• 5+ years in Data Engineering with 3+ years in Data Architecture/Snowflake implementations
• Strong hands-on Snowflake administration and performance optimization
• Proven experience leading enterprise-scale data modernization & cloud transformations
• Experience managing customer-facing engagements and offshore delivery teams
• Strong consulting and stakeholder management skills for technical and business audiences
• Expertise with Snowflake features: Snowpipe, Materialized Views, Clustering, Zero Copy Cloning, Time Travel, Resource Monitors, RBAC
• Hands-on Python, PySpark, Bash, and automation for ingestion, orchestration, monitoring
• Experience with dbt, Fivetran, MuleSoft, and similar ELT/integration platforms
• Knowledge of AWS, GCP, Azure; Snowflake integrations with Salesforce/SaaS
• Strong analytical, troubleshooting, and problem-solving abilities
• Excellent communication and leadership in a consulting-driven environment

Responsibilities

• Serve as Snowflake domain expert guiding modern data architecture, governance, and performance
• Lead discovery workshops to capture business objectives and data landscapes
• Design scalable Snowflake-based data platforms for analytics, AI, and operations
• Develop enterprise data models, dictionaries, metadata frameworks, and ERDs
• Architect and optimize Snowflake data warehouses, marts, and ingestion frameworks
• Implement scalable ELT/ETL pipelines using Snowpipe, dbt, Fivetran, MuleSoft, Python, PySpark
• Enforce enterprise security, governance, scalability, reliability, and cost controls
• Lead end-to-end Snowflake/data modernization engagements for NA customers
• Coordinate activities across analysts, engineers, QA, and offshore teams
• Mentor junior engineers and architects to drive delivery excellence
• Stay current with Snowflake/cloud data trends and automation improvements
• Support pre-sales with architecture recommendations and SOWs

Skills

Snowflake

Data architecture

SQL

SnowSQL

Python

PySpark

RBAC & Security

Data governance

Cloud platforms

Open-source tooling

Education

Bachelor’s degree in CS/IS/DS/Engineering

Master’s degree preferred

Tools

Snowpipe

dbt

Fivetran

MuleSoft

Openflow

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.

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.

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).