We are looking for a highly experienced and strategic Snowflake Principal Architect to lead end-to-end solutioning, architecture, and implementation of data platforms using the Snowflake ecosystem.

This is a senior-level role that blends deep technical expertise with strong consultative and client-facing skills.

The ideal candidate will act as the Subject Matter Expert (SME) for Snowflake, helping clients design, implement, and optimize data solutions for both batch and streaming workloads.

As a Principal Architect, you will work closely with business stakeholders, data engineers, and solution architects to build scalable, high-performance, and cost-effective data warehousing solutions in cloud environments. You will also provide technical leadership and mentoring to junior architects and engineers.

KEY RESPONSIBILITIES :

- Lead the architecture and design of scalable, secure, and high-performance data platforms using Snowflake.

- Serve as a trusted advisor and SME for clients in designing end-to-end solutions involving Snowflake and related technologies such as dbt, Fivetran, Airflow, Matillion, Kafka, etc.

- Provide consulting on cloud data strategy, data integration, migration, and modernization initiatives.

- Evaluate and recommend best-fit architectural patterns (e.g., ELT/ETL, data mesh, data lakehouse).

- Architect and oversee the development of ETL/ELT pipelines using Snowflake in combination with tools like dbt, Fivetran, Talend, Informatica, or custom scripts.

- Enable real-time and batch data processing by integrating with streaming tools such as Kafka, Apache Spark, etc.

- Work with cross-functional teams to design pipelines that ensure data integrity, consistency, and security.

- Design and implement data models (star/snowflake schemas, data vaults, etc.) and data warehouses to support business analytics and operational needs.

- Define and enforce data governance, data cataloging, and metadata management practices.

- Guide and mentor engineering teams on Snowflake development best practices, query optimization, and cost management.

- Drive proof-of-concept initiatives and create reusable solution accelerators.

- Review code, pipelines, and architecture artifacts to ensure alignment with standards.

- Create detailed architecture diagrams, data flow diagrams, and technical documentation.

- Communicate complex technical concepts clearly to non-technical stakeholders, including executives and clients.

- Participate in RFPs, proposals, and technical pre-sales activities when needed.

MANDATORY SKILLS & QUALIFICATIONS :

- 10+ years of overall experience in Data Engineering, Data Architecture, or related fields.

- 5+ years of hands-on experience with Snowflake, including :

Snowflake architecture design
Performance tuning & optimization
Security, access control, and RBAC
Zero-copy cloning, time travel, data sharing features

- Experience with dbt, Fivetran, or similar tools.

- Proven expertise in Data Warehousing, Data Architecture, and Data Modeling.

- Deep understanding of cloud platforms like AWS, GCP, or Azure and how Snowflake integrates within these environments.

- Strong SQL expertise and experience with Python, Shell scripting, or other automation tools.

- Hands-on experience with streaming tools such as Kafka, Kinesis, Spark Streaming is a plus.

- Prior experience in consulting or client-facing solutioning roles is mandatory