Design and govern the end-to-end Snowflake data platform, including its environments, databases, schemas, and warehouses.
Define data models and architect ingestion, transformation, and consumption layers; lead legacy warehouse migrations to Snowflake.
Establish security, governance, CI/CD, and code management practices, and optimize platform performance and cost.
Integrate Snowflake with BI tools and source systems; review designs and code, mentor engineers, and create technical documentation and runbooks.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
14+ years of experience
12+ years of experience in data warehousing/data engineering
2+ years of hands-on Snowflake architecture and implementation
Experience with ETL/ELT tools such as Informatica, Matillion, Fivetran, Azure Data Factory, or dbt
Experience with at least one cloud platform (AWS, Azure, or GCP) and its storage and security services
Experience with security, RBAC design, and compliance requirements
Education
Bachelor’s degree in Computer Science, Information Technology, or equivalent experience
Skills
Strong expertise in Snowflake features, including 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
Understanding of data modeling, data warehousing concepts, and data governance
Other requirements
100% onsite in the U.S.
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Full job description
From Bright Vision Technologies’ careers site
Snowflake Architect - Onsite
Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States. This is a fantastic opportunity to join an established and well-respected organization offering tremendous career growth potential.
Job Title: Snowflake Architect Location: 100% Onsite (U.S.) Position Type: Contract Experience Required: 14+ years
Sponsorship: U.S. Citizens, Green Card Holders, EAD Holders, H1B, H-1B transfer candidates are encouraged to apply. We are unable to sponsor new H-1B visa petitions for this position.
Show full descriptionShow less
Job Summary 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.
Key Responsibilities
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
Required Qualifications
12+ 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 GCP) 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
How to Apply Would you like to know more about this opportunity? For immediate consideration, please send your resume to venkat.r@bvteck.com or contact us at (908) 505-3899. Learn more about Bright Vision Technologies at www.bvteck.com. Bright Vision Technologies is an Equal Opportunity Employer.