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. , 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 designPerformance tuning & optimizationSecurity, access control, and RBACZero-copy cloning, time travel, data sharing featuresExperience 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 mandatoryref : hirist.tech)