Snowflake Architect

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

Pre-Screening Questionnaire

• In what capacity have you worked with Snowflake, and for how long?

• How many end-to-end Snowflake projects have you executed?

• Why would you use Snowflake for a cloud data warehouse solution?

• Are you Snowflake certified?

• Please explain Snowflake architecture.

• What is Snowflake Time Travel, and how have you used it?

• How is data security managed in Snowflake?

• Have you worked as an architect with any other technology, and do you hold architecture certifications?

Salary Range: $180,000 - $220,000 a year