Snowflake Architect: Data Platform & AI-Driven Analytics

Volto Consulting; Santa Clara (CA); On-site; USD 140,000 - 200,000; Full time

Job summary

Volto Consulting in Santa Clara, CA, seeks a Senior Snowflake Architect to lead end-to-end data warehousing initiatives. You will define architectures, guide data modeling, ELT/ETL design, and ensure secure, scalable cloud DW implementations.

The role requires deep Snowflake expertise, hands-on migration from relational DBs, and collaboration with on-site and offshore teams. Excellent communication and governance focus are essential.

Qualifications

• Minimum two end-to-end Snowflake cloud DW implementations.
• Expertise in data modeling, Snowflake ELT, complex stored procedures, and standard data warehouse concepts.
• Experience migrating data from relational databases to a cloud data warehouse.
• Advanced Snowflake features including resource monitors, RBAC, virtual warehouse sizing, and Time Travel.
• Snowflake Cortex AI capabilities for building and integrating AI-powered data solutions.

Responsibilities

• Assess the current-state environment and lead target-state planning with customers and stakeholders.
• Define the Snowflake solution architecture and detailed design, and lead architecture and design reviews.
• Design processes supporting data transformation, data structures, metadata, dependencies, and workload management.
• Guide and support implementation of the approved Snowflake architecture.
• Resolve a broad range of data pipeline issues proactively and as they arise.
• Work closely with development and customer teams throughout the project lifecycle.
• Represent the architecture function in customer meetings, steering committees, architecture boards, and technical reviews.
• Coordinate with the offshore team during project execution.

Skills

Snowflake DW

Data modeling

ELT/ETL concepts

Stored procedures

Data migration

RBAC

Time Travel

Zero-copy cloning

JSON/XML handling

Tools

AWS S3

Azure Data Lake Storage

Apache Iceberg

Open table formats

Job description

Volto Consulting in Santa Clara, CA, seeks a Senior Snowflake Architect to lead end-to-end data warehousing initiatives. You will define architectures, guide data modeling, ELT/ETL design, and ensure secure, scalable cloud DW implementations.

The role requires deep Snowflake expertise, hands-on migration from relational DBs, and collaboration with on-site and offshore teams. Excellent communication and governance focus are essential.