> Markdown version of [/jobs/ext/4555978-snowflake-technical-architect](https://www.wearedevelopers.com/jobs/ext/4555978-snowflake-technical-architect). 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 Technical Architect

- **Company:** Prospance inc
- **Location:** Philadelphia, PA, United States
- **Experience:** Experienced
- **Contract:** Contract
- **Skills:** Airflow, Amazon Web Services, Microsoft Azure, Cluster Analysis, Databases, Continuous Integration, Data Architecture, Data Cleansing, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Mart, Data Migration, Data Security, Data Sharing, Data Vault Modeling, Data Warehousing, DevOps, Python (Programming Language), Microsoft SQL Server, Oracle (Applications), Performance Tuning, Query Optimization, Role-Based Access Control, Power BI, Runbook, Tableau (Software), Teradata SQL, Scripting, Google Cloud, Cloud Platform System, Azure Data Factory, Sql Optimization, Snowflake, Caching, Git, Information Technology, Integration Frameworks, Apache Kafka, Video Streaming, Terraform, Software Version Control, Data Pipelines, Control M
- **Published:** November 4, 2026
- **Apply:** https://www.dice.com/job-detail/c637d43d-b93f-4016-b332-ae7a29eccb25

## About the Role

* 6+ years of experience in data warehousing/data engineering, with 2+ years of hands-on Snowflake architecture and implementation
 * Strong expertise in Snowflake features: virtual warehouses, Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, Secure Data Sharing, and Snowpark
 * Advanced SQL and strong performance tuning skills; working knowledge of Python or another scripting language
 * Experience with ETL/ELT tools (Informatica, Matillion, Fivetran, Azure Data Factory, dbt, or similar)
 * Solid understanding of data modeling, data warehousing concepts, and data governance
 * Experience with at least one cloud platform (AWS, Azure, or Google Cloud Platform) and its storage and security services
 * Experience with security, RBAC design, and compliance requirements
 * Strong documentation, communication, and stakeholder management skills
 * Bachelor's degree in Computer Science, Information Technology, or equivalent experience, * SnowPro Core or SnowPro Advanced: Architect certification
 * Experience with data migration from on-prem to Snowflake
 * Experience with orchestration tools (Airflow, Control-M) and CI/CD pipelines
 * Exposure to data catalog, lineage, and data quality tools
 * Experience with real-time/streaming technologies (Kafka, Kinesis)
 * Experience in [industry: confirm, e.g., pharma, finance, healthcare]

## Description

We are seeking an experienced Snowflake Technical Architect to design, build, and govern our cloud data platform. The architect will define the data architecture, lead the technical design of ingestion, transformation, and consumption layers on Snowflake, and guide engineering teams to deliver secure, scalable, and cost-efficient solutions., * Design and own the end-to-end Snowflake architecture, including account structure, databases, schemas, warehouses, and environments (Dev/QA/Prod)

 * Define data modeling standards (dimensional, data vault, or medallion layers) for the enterprise data warehouse and data marts
 * Architect data ingestion pipelines using Snowpipe, Streams and Tasks, and batch/real-time integration tools
 * Lead migration of legacy data warehouses (Oracle, SQL Server, Teradata, etc.) to Snowflake
 * Establish security and governance: RBAC, row/column-level security, masking policies, encryption, and data sharing
 * Optimize performance and cost through warehouse sizing, clustering, query tuning, caching, and resource monitors
 * Define CI/CD, DevOps, and code management practices for Snowflake objects (Git, dbt, Terraform, or similar)
 * Integrate Snowflake with BI and analytics tools (Tableau, Power BI, etc.) and upstream source systems
 * Review designs and code, mentor data engineers, and enforce best practices
 * Create architecture diagrams, technical design documents, and runbooks
 * Collaborate with business stakeholders, data engineers, analysts, and security teams to translate requirements into technical solutions
 * Support production issues, monitoring, and platform enhancements