Snowflake Architect - Data Warehousing

<p><b>Job Summary :</b><br/><br/>We are seeking an experienced Snowflake Architect with 12+ years of expertise in data warehousing, cloud architecture, and Snowflake implementations.

The ideal candidate will design, optimize, and manage large-scale Snowflake data platforms, ensuring scalability, performance, and security.

This role requires deep technical knowledge of Snowflake, cloud ecosystems, and data engineering best practices.<br/><br/><b>Key Responsibilities :</b><br/><br/>1.

Snowflake Architecture & Design :<br/><br/>- Lead the design and implementation of Snowflake data warehouses, data lakes, and data marts.<br/><br/>- Define best practices for Snowflake schema design, clustering, partitioning, and optimization.<br/><br/>- Architect multi-cloud (AWS) Snowflake deployments with seamless integration.<br/><br/>- Design data sharing, replication, and failover strategies for high availability.<br/><br/>2.

Performance Optimization & Scalability :<br/><br/>- Optimize query performance using Snowflake features (warehouse sizing, caching, materialized views).<br/><br/>- Implement automated scaling strategies for dynamic workloads.<br/><br/>- Troubleshoot and resolve performance bottlenecks in large-scale Snowflake environments.<br/><br/>3.

Data Integration & Pipeline Development :<br/><br/>- Architect ETL/ELT pipelines using Snowflake, Coalesce and other tools.<br/><br/>- Integrate Snowflake with BI tools (Tableau, Power BI), ML platforms, and APIs.<br/><br/>- Implement CDC (Change Data Capture), streaming, and batch processing solutions.<br/><br/>4.

Security, Governance & Compliance :<br/><br/>- Define RBAC, data masking, row-level security, and encryption policies in Snowflake.<br/><br/>- Ensure compliance with GDPR, CCPA, HIPAA, and SOC2 regulations.<br/><br/>- Establish data lineage, cataloging, and auditing using Snowflake's governance features.<br/><br/>5.

Team Leadership & Strategy :<br/><br/>- Mentor data engineers, analysts, and developers on Snowflake best practices.<br/><br/>- Collaborate with C-level executives to align Snowflake strategy with business goals.<br/><br/>- Evaluate emerging trends (AI/ML in Snowflake, Iceberg tables, Unistore) for innovation.<br/><br/><b>Required Skills & Qualifications :</b><br/><br/>- 12+ years in data warehousing, cloud architecture, and database technologies.<br/><br/>- 8+ years of hands-on Snowflake architecture & administration experience.<br/><br/>- Expertise in SQL, Python for data processing.<br/><br/>- Deep knowledge of Snowflake features (Time Travel, Zero-Copy Cloning, Snowpark, Streams & Tasks).<br/><br/>- Experience with cloud platforms (AWS S3, Azure Blob)<br/><br/>- Strong understanding of data modeling (star schema, data vault, 3NF).<br/><br/>- Certifications: Snowflake Advanced Architect.<br/><br/><b>Preferred Skills :</b><br/><br/>- Knowledge of DataOps, MLOps, and CI/CD pipelines.<br/><br/>- Familiarity with DBT, Airflow, SSIS & IICS</p> (ref:hirist.tech)