Snowflake Architect

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

Santa Clara, CA

Fulltime

Must Have Technical/Functional Skills

• Minimum two end-to-end Snowflake cloud data warehouse implementations.
• Expertise in data modeling, Snowflake ELT, complex stored procedures, and standard data warehouse and ETL concepts.
• Experience migrating data from relational databases to a cloud data warehouse.
• Advanced Snowflake expertise including resource monitors, role-based access control, virtual warehouse sizing, query performance tuning, zero-copy cloning, and Time Travel.
• Experience with Snowflake Cortex AI capabilities for building and integrating AI-powered data and analytics solutions.
• Experience in Data Product design and semantic model creation to enable governed, reusable, and business-aligned data consumption.
• Working knowledge of Apache Iceberg and open table formats, including their use with modern cloud data platforms.

Experience With Snowflake Data Masking And Security Capabilities.

• Experience handling structured and semi-structured data, including JSON and XML.
• Experience with AWS or Azure storage and data management technologies, including Amazon S3 and Azure Data Lake Storage.
• Experience working in Agile development methodologies.
• Strong written and verbal communication skills, with the ability to communicate effectively and persuasively.

Roles & Responsibilities

• Assess the current-state environment and lead target-state planning with TCS and customer 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.

Generic Managerial Skills, If Any

• Strong stakeholder coordination and customer-facing communication.
• Ability to represent the solution confidently in governance forums and technical reviews.
• Effective coordination with onsite, customer, development, and offshore delivery teams.

Key Words to search in Resume
Snowflake; Cloud Data Warehouse; Technical architect , Data Architect; Data Modeling; ELT; ETL; Stored Procedures; Data Migration; RBAC; Data Masking; Data Security; Virtual Warehouse Sizing; Query Performance Tuning; Zero-Copy Clone; Time Travel; JSON; XML; Amazon S3; Azure Data Lake Storage; Data Pipelines; Agile; TOGAF