Snowflake Architect

Bright Vision Technologies

Philadelphia (Philadelphia County)

On-site

USD 131,000 - 220,000

Part time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Bright Vision Technologies is seeking an experienced Snowflake Technical Architect to design, build, and govern our cloud data platform. The architect will define the data architecture, lead ingestion, transformation, and consumption layers on Snowflake, and guide engineering teams to deliver secure, scalable solutions.

This onsite contract role requires 14+ years in data warehousing, strong SQL, Python, and cloud experience (AWS/Azure/GCP).

Qualifications

  • 14+ years in data warehousing/data engineering
  • 2+ years hands-on Snowflake architecture/implementation
  • Advanced SQL and performance tuning
  • Experience with ETL/ELT tools
  • Cloud platform experience (AWS/Azure/GCP)
  • Security, RBAC design, and governance
  • Bachelor's degree in CS/IT or equivalent

Responsibilities

  • Design end-to-end Snowflake architecture (account, databases, schemas, warehouses)
  • Define data modeling standards for enterprise DW and data marts
  • Architect data ingestion using Snowpipe, Streams, Tasks
  • Lead migration of legacy DWs to Snowflake
  • Establish security, governance, encryption, data sharing
  • Optimize performance and cost via tuning and resource monitors
  • Define CI/CD and DevOps practices for Snowflake objects
  • Integrate Snowflake with BI/analytics tools
  • Review designs, mentor engineers, enforce best practices
  • Create architecture diagrams and runbooks
  • Collaborate with stakeholders to translate requirements
  • Support production issues and platform enhancements

Skills

Snowflake
Data Warehousing
SQL
Python
Cloud Platforms

Education

Bachelor's degree in Computer Science or equivalent

Tools

Informatica
Matillion
Fivetran
dbt
Terraform

Job description

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.

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

Bright Vision Technologies is an Equal Opportunity Employer.

Equal Employment Opportunity (EEO) Statement

Bright Vision Technologies (BV Teck) is committed to equal employment opportunity (EEO) for all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, veteran status, or any other protected status as defined by applicable federal, state, or local laws. This commitment extends to all aspects of employment, including recruitment, hiring, training, compensation, promotion, transfer, leaves of absence, termination, layoffs, and recall.

BV Teck expressly prohibits any form of workplace harassment or discrimination. Any improper interference with employees' ability to perform their job duties may result in disciplinary action up to and including termination of employment.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Architect
Snowflake Architect

Bright Vision Technologies • Irving (TX)

Remote
USD 115,000 - 165,000
Snowflake Architect
Snowflake Architect

Quantum Technologies LLC • Santa Clara (CA)

On-site
USD 170,000 - 260,000
Snowflake Architect
Snowflake Architect

Ethereum Technologies LLC • Santa Clara (CA)

On-site
USD 140,000 - 210,000
Snowflake Architect
Snowflake Architect

Valiant Technologies LLC • Santa Clara (CA)

On-site
USD 180,000 - 260,000
Snowflake Architect
Snowflake Architect

Quantum Technologies LLC • New York (NY)

On-site
USD 84,000 - 120,000
Snowflake Engineer
Snowflake Engineer

MACHINE LEARNING TECHNOLOGIES LLC • Paterson (NJ)

On-site
USD 96,000 - 138,000
Snowflake Architect
Snowflake Architect

Ethereum Technologies LLC • New York (NY)

On-site
USD 87,000 - 117,000
Snowflake Architect
Snowflake Architect

Valiant Technologies LLC • New York (NY)

On-site
USD 96,000 - 107,000
Snowflake Data Engineer
Snowflake Data Engineer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 90,000 - 124,000
Snowflake Data Engineer
Snowflake Data Engineer

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 83,000 - 124,000