Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy, and consent to receive emails from Rise
Jobs / Job page
Snowflake Architect image - Rise Careers
Job details

Snowflake Architect

Snowflake Architect
 
Location : Arlington, VA and Boston, MA

 
Job Description:
The ideal candidate should have 10+ years of experience with a strong background in Snowflake architecture, SQL optimization, data warehousing, cloud data platforms, and enterprise data strategy. Additionally, they should possess leadership experience and the ability to provide technical guidance and architectural oversight.
Key Responsibilities:
  • Design and architect enterprise-scale Snowflake data warehouse solutions, including database schemas, data models, and multi-cluster warehouses
  • Experience of implementing Data Vault on Snowflake is highly desirable
  • Develop Snowflake best practices for performance optimization, cost management, and resource allocation
  • Implement advanced Snowflake features including Time Travel, Zero Copy Cloning, data sharing, and secure data exchanges
  • Design and optimize complex SQL queries, stored procedures, and functions specifically for Snowflake's unique architecture
  • Architect data integration strategies using Snowflake's native connectors, Snowpipe, and external stages
  • Conduct Root Cause Analysis (RCA) for Snowflake performance issues and implement optimization strategies
  • Lead and mentor data engineering teams on Snowflake development, providing architectural guidance and best practices
  • Design and implement scalable ELT/ETL pipelines leveraging Snowflake's cloud-native capabilities
  • Establish data governance frameworks including role-based access control (RBAC), data classification, and compliance monitoring
  • Collaborate with stakeholders to translate business requirements into scalable Snowflake data architecture solutions
  • Implement Snowflake security best practices including network policies, encryption, and data masking
Required Technical Skills:
  • Expert-level Snowflake knowledge including SnowSQL, Snowsight, and Snowflake APIs
  • Strong understanding of Snowflake's unique architecture (virtual warehouses, storage layers, cloud services)
  • Experience with Snowflake data loading techniques (Snowpipe, bulk loading, continuous data ingestion)
  • Proficiency in advanced SQL and stored procedures optimized for Snowflake
  • Knowledge of Snowflake's ecosystem including partner tools and third-party integrations
Preferred Qualifications:
  • Snowflake certifications (SnowPro Core, Advanced Architect, or Data Engineer)
  • Experience with dbt (data build tool) for transformation workflows in Snowflake
  • Familiarity with Python, JavaScript, or Java for Snowflake UDFs and stored procedures
  • Experience with data visualization tools such as Power BI, Tableau, or Looker connected to Snowflake
  • Understanding of DataOps and CI/CD practices for Snowflake development
  • Knowledge of Snowflake's data marketplace and external data integration

QODE Glassdoor Company Review
4.3 Glassdoor star iconGlassdoor star iconGlassdoor star iconGlassdoor star icon Glassdoor star icon
QODE DE&I Review
5.0 Glassdoor star iconGlassdoor star iconGlassdoor star iconGlassdoor star iconGlassdoor star icon
CEO of QODE
QODE CEO photo
Unknown name
Approve of CEO

Average salary estimate

$185000 / YEARLY (est.)
min
max
$150000K
$220000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

Similar Jobs
Photo of the Rise User
Writer Hybrid New York City
Posted 8 hours ago
Dare to be Different
Diversity of Opinions
Inclusive & Diverse
Collaboration over Competition
Fast-Paced
Growth & Learning

WRITER is hiring a Product Analyst to define core metrics, build ELT-based data models, and deliver insights that drive the product roadmap using FullStory, BigQuery, and dbt.

Photo of the Rise User

Lead the modernization of Mambu’s data platform and architect scalable, secure data services that enable reporting, extraction, and AI-driven insights for a fast-growing fintech.

Photo of the Rise User
Posted 9 hours ago
Inclusive & Diverse
Rise from Within
Mission Driven
Diversity of Opinions
Work/Life Harmony
Customer-Centric
Social Impact Driven
Passion for Exploration
Maternity Leave
Paternity Leave
Family Coverage (Insurance)
Medical Insurance
Dental Insurance
Vision Insurance
Mental Health Resources
Life insurance
Disability Insurance
Health Savings Account (HSA)
Flexible Spending Account (FSA)
401K Matching

ServiceTitan seeks a customer-focused Data Quality Analyst to troubleshoot, clean, and transform client data using SQL and ETL practices to support successful migrations.

Posted 23 hours ago

Lead Leland’s data strategy as the first data hire, building a reliable warehouse, semantic metrics layer, ingestion pipelines, and self-serve analytics for a fast-growing education marketplace.

Photo of the Rise User

EBSCO seeks an E-Content Specialist to manage and improve the Global Knowledge Base by processing publisher metadata feeds, resolving data issues, and ensuring accurate content representation (remote, U.S.-based).

Lilly Hybrid US: Indianapolis IN Tech Center South
Posted 7 hours ago

Lilly is hiring a Customer Identity Management Data Steward in Indianapolis to lead data governance, quality, and metadata management for consumer identity initiatives.

Photo of the Rise User
Boeing Hybrid USA - Seattle, WA
Posted 7 hours ago

Lead Boeing BDS supply chain data stewardship to establish governance, enable the digital thread, and drive data-driven product adoption across the enterprise.

Photo of the Rise User
Posted 20 hours ago

Lead the design, implementation, and operation of Flex's large-scale data infrastructure to enable analytics and ML at enterprise scale.

Posted 13 hours ago

An experienced Data Engineer is needed to design, build, and maintain ETL processes and cloud-based data solutions that drive Allied’s analytics and data strategy.

Photo of the Rise User

A hybrid Analytics Engineer role focused on building modular, analytics-ready data pipelines and models to enable BI, AI and data science across the firm.

Photo of the Rise User

Work remotely as a Data Warehouse Developer for the State of Maine Office of Technology, delivering and supporting Oracle Cloud-based analytics and ETL solutions with a focus on Kimball-style data modeling.

Photo of the Rise User

Experienced Databricks Engineer needed to lead migration of legacy pipelines to a Databricks-based Medallion Model for a secure U.S. Government program.

Posted 18 hours ago

Toyota is hiring an Engineer for the Data Marketplace in Plano to build, curate, and manage data products and content that enable self-service analytics and reduce technology risk.

MATCH
Calculating your matching score...
FUNDING
DEPARTMENTS
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
EMPLOYMENT TYPE
Full-time, hybrid
DATE POSTED
September 10, 2025
Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!