> Markdown version of [/jobs/ext/4772873-snowflake-data-architect-local-candidates-dallas-tx](https://www.wearedevelopers.com/jobs/ext/4772873-snowflake-data-architect-local-candidates-dallas-tx). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Snowflake Data Architect (LOCAL CANDIDATES - DALLAS, TX) - **Company:** Sum Theory Inc - **Location:** Dallas, TX, United States - **Experience:** Experienced - **Contract:** Temporary to permanent - **Skills:** Query Performance, Java (Programming Language), JavaScript (Programming Language), Artificial Intelligence, Amazon Web Services, Microsoft Azure, Cloud Computing, Cloud Database, Cyber Security, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Masking, Data Migration, Data Sharing, Data Vault Modeling, Data Warehousing, Graph Database, IT Management, Python (Programming Language), PostgreSQL, Microsoft SQL Server, Performance Tuning, Role-Based Access Control, Power BI, Scala (Programming Language), Software Engineering, SQL Databases, Systems Integration, Tableau (Software), Cloud Platform System, Snowflake, IT Architecture, Data Lineage, Data Analytics, Star Schema, AWS Data Analytics, Data Management, Stream Analytics, Data Pipelines, Databricks, Golang, Microservices - **Published:** November 18, 2026 - **Apply:** https://www.careerbuilder.com/job-details/snowflake-data-architect-local-candidates-dallas-tx--2c252dfb-a2d8-4719-8172-7b3a271d0fd3 ## About the Role Snowflake Schema, DataArchitect Data Modeling Tool, Software Engineering, Amazon Web Services (AWS), Artificial Intelligence (AI), DataArchitect Data Modeling Tool, Snowflake Schema, SQL (Structured Query Language), Data Warehousing, Cloud Computing, * 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. * Proficiency in Data Platforms - Snowflake, Microsoft SQL, Postgres, Databricks, Microsoft Power BI, Tableau Reporting, AWS Data (Sagemaker, Glue, Kinesis, RDS), Python, JavaScript, Scala, Go and Java programming. * 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). ## Description 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., * 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.