Senior Snowflake Architect - Cloud Data Platform Lead

Northern Base; Santa Clara (CA); On-site; USD 180,000 - 260,000; Full time

Job summary

Northern Base in Santa Clara, CA is seeking a Senior Snowflake Architect to design and implement scalable cloud data warehouse solutions for complex enterprise data.

You will define Snowflake architecture, lead design reviews, optimize data models, implement ELT processes, and coordinate with onsite and offshore teams.

Strong communication and a proven track record of end-to-end Snowflake deployments are required.

Qualifications

• 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.

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.

Skills

Snowflake architecture

Data modeling

ELT/ETL concepts

Stored procedures

Data migration

RBAC and security

Time Travel / cloning

Snowflake Cortex AI

Agile methodologies

Communication skills

Tools

AWS S3

Azure Data Lake Storage

Apache Iceberg

Job description

Northern Base in Santa Clara, CA is seeking a Senior Snowflake Architect to design and implement scalable cloud data warehouse solutions for complex enterprise data.

You will define Snowflake architecture, lead design reviews, optimize data models, implement ELT processes, and coordinate with onsite and offshore teams.

Strong communication and a proven track record of end-to-end Snowflake deployments are required.