Snowflake Architect

Role Overview: You are an experienced Snowflake Architect with over 12 years of experience in data warehousing, cloud architecture, and Snowflake implementations. Your expertise lies in designing, optimizing, and managing large-scale Snowflake data platforms to ensure scalability, performance, and security. You are expected to possess deep technical knowledge of Snowflake, cloud ecosystems, and data engineering best practices. Key Responsibilities: - Lead the design and implementation of Snowflake data warehouses, data lakes, and data marts. - Define best practices for Snowflake schema design, clustering, partitioning, and optimization. - Architect multi-cloud Snowflake deployments with seamless integration and design data sharing, replication, and failover strategies for high availability. - Optimize query performance using Snowflake features, implement automated scaling strategies for dynamic workloads, and troubleshoot performance bottlenecks in large-scale Snowflake environments. - Architect ETL/ELT pipelines using Snowflake, Coalesce, and other tools, integrate Snowflake with BI tools, ML platforms, and APIs, and implement CDC, streaming, and batch processing solutions. - Define RBAC, data masking, row-level security, and encryption policies in Snowflake. - Ensure compliance with GDPR, CCPA, HIPAA, and SOC2 regulations and establish data lineage, cataloging, and auditing using Snowflake's governance features. - Mentor data engineers, analysts, and developers on Snowflake best practices. - Collaborate with C-level executives to align Snowflake strategy with business goals. - Evaluate emerging trends for innovation. Qualifications Required: - Over 12 years of experience in data warehousing, cloud architecture, and database technologies. - 8+ years of hands-on Snowflake architecture and administration experience. - Expertise in SQL and Python for data processing. - Deep knowledge of Snowflake features, experience with cloud platforms, and strong understanding of data modeling. - Certification as a Snowflake Advanced Architect is a must. Preferred Skills: - Knowledge of DataOps, MLOps, and CI/CD pipelines. - Familiarity with DBT, Airflow, SSIS, and IICS.,