Snowflake Data Architect (LOCAL CANDIDATES - DALLAS, TX)

Sum Theory, Inc.; Dallas (TX); Hybrid; USD 152,000 - 262,000; Full time

Job summary

Sum Theory, Inc. seeks a Snowflake Data Architect (local Dallas candidates) to design, implement, and optimize a scalable Snowflake-based data warehouse. You will enable real-time analytics, data sharing, and AI-driven insights, collaborating with business and IT to align data strategies with five-year goals.

The role requires 14+ years in IT, extensive Snowflake and AWS data engineering experience, and certifications in Snowflake and AWS. This is a contract position in Dallas, TX.

Qualifications

• 14+ years in IT with 5-7 years in a formal Data Architecture role.

Responsibilities

• Architecture Design: End-to-end data architectures within Snowflake.
• Data Modeling: Star/Snowflake/Data Vault 2.0 with data lineage and governance.
• Pipeline Engineering: ETL/ELT pipelines using Snowpipe, Tasks and Streams.
• Governance & Security: RBAC, data masking, and row-level security.
• Performance Tuning: Optimize queries and credit consumption.
• Snowflake reference designs for ETL/ELT with AWS.
• Data Governance: Data lineage and stewardship across units.

Skills

Snowflake

SQL

AWS Data

Databricks

Airbyte

dbt

Fivetran

RBAC

data masking

Time Travel

Zero-copy Cloning

Education

Bachelor's or Master's in CS/MIS/Data Science

MBA or related field (or equivalent experience)

Tools

Snowpipe

Tasks

Streams

AWS

Job description

Snowflake Data Architect (LOCAL CANDIDATES - DALLAS, TX)

POSITION TYPE: Contract (5 months - Possible contract to hire)

Position Overview

14 years + Experience in Snowflake, SQL, AWS Data (Sage maker, Glue, Kinesis) and Cloud Data Engineering. As a Snowflake Data Architect (EA), you will be the strategic glue between business goals and IT execution for all Data engineering efforts. Your role is to design, implement, and optimize a high-performance data warehouse environment (Snowflake, Databricks, AWS) that serves as the "single source of truth." You won't just be moving data around; you'll be architecting a scalable foundation that enables real-time analytics, data sharing, and AI-driven insights across the enterprise. Your mission is to ensure that our technology data stack is scalable, secure, and-most importantly- aligned with where the company wants to be in five years.

Key Responsibilities

• Architecture Design: Design end-to-end data architectures within Snowflake, utilizing Virtual Warehouses, multi-cluster environments, and specialized storage optimization.
• Data Modeling: Create and maintain complex data models (Star Schema, Snowflake Schema, Data Vault 2.0) tailored for cloud-native performance. Strong Collaboration with various IT and Business stakeholders to curate, document and implement Data lineage, knowledge graphs, Data tracing and Compliance KPIs.
• Pipeline Engineering: Architect robust ETL/ELT pipelines using Snowpipe, Tasks, and Streams, integrating with tools like airbyte, dbt, Fivetran, or AWS.
• Governance & Security: Implement Role-Based Access Control (RBAC), data masking, and row-level security to ensure compliance with global standards (GDPR, HIPAA, etc.).
• Performance Tuning: Monitor and optimize query performance and credit consumption- ensuring the system is as cost-effective as it is fast. Expert-level SQL and deep knowledge of Snowflake-specific features (Time Travel, Zero-copy Cloning, Data Sharing etc.
• Snowflake Reference Designs: Implement reference designs for ETL/ELT pipeline engineering including integration efforts with AWS platforms.
• Data Governance: Setup architecture and governance standards from Data engineering and Platform perspective and enforce Data Lineage, Data Stewardship across all business units.

Required Qualifications

• 14+ years in IT, with 5-7 years in a formal progressive Data Architecture role.
• Mastery of cloud ecosystems (AWS/Azure), microservices, Data standards, IT Governance, Security Architecture, Architecture Guidance, Security and data integration patterns. 7+ years in Data Engineering, with 3+ years focused specifically on Snowflake implementations.
• High-level "influencing without authority" and the ability to explain complex data engineering tech to non-techies.
• Snowflake Core Pro and Snowflake Advanced Architect Certifications(mandatory), Databricks (optional), AWS Data Engineering Certifications (mandatory), AWS Solution Architect Pro (nice to have)
• Bachelor's or Master's in CS, MIS, Data Science, MBA or a related field (or equivalent battle-hardened experience).