Snowflake Architect

Bright Vision Technologies•Philadelphia, PA
•Onsite

About The Position

Bright Vision Technologies is seeking an experienced Snowflake Technical Architect to design, build, and govern its cloud data platform. The architect will define data architecture, lead the technical design of Snowflake ingestion, transformation, and consumption layers, and guide engineering teams in delivering secure, scalable, and cost-efficient solutions. The role includes owning end-to-end Snowflake architecture; setting data modeling, security, governance, CI/CD, and DevOps standards; leading migrations from legacy data warehouses; integrating Snowflake with analytics tools and source systems; and supporting production operations and platform enhancements. The architect will collaborate with business stakeholders, data engineers, analysts, and security teams to translate requirements into technical solutions, review designs and code, mentor engineers, and produce architecture diagrams, technical design documents, and runbooks. This is a contract position requiring 100% onsite work in the United States. Bright Vision Technologies is unable to sponsor new H-1B visa petitions for this position. The company states that it is an Equal Opportunity Employer.

Requirements

  • 12+ years of experience in data warehousing or data engineering, with 2+ years of hands-on Snowflake architecture and implementation experience.
  • 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.
  • Experience with ETL/ELT tools such as 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.
  • Must be eligible to work under the stated sponsorship conditions: new H-1B visa petitions cannot be sponsored for this position.

Responsibilities

  • Design and own end-to-end Snowflake architecture, including account structure, databases, schemas, warehouses, and Dev/QA/Prod environments.
  • Define enterprise data warehouse and data mart modeling standards, including dimensional, data vault, or medallion approaches.
  • Architect data ingestion pipelines using Snowpipe, Streams and Tasks, and batch or real-time integration tools.
  • Lead migration of legacy data warehouses such as Oracle, SQL Server, and Teradata to Snowflake.
  • Establish security and governance practices, including RBAC, row- and 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 using Git, dbt, Terraform, or similar tools.
  • Integrate Snowflake with BI and analytics tools such as Tableau and Power BI, as well as 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.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service