Snowflake Architect

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. Your key responsibilities will include leading the design and implementation of Snowflake data warehouses, data lakes, and data marts. You will define best practices for Snowflake schema design, clustering, partitioning, and optimization. Additionally, you will architect multi-cloud Snowflake deployments with seamless integration and design data sharing, replication, and failover strategies for high availability. You will be responsible for optimizing query performance using Snowflake features, implementing automated scaling strategies for dynamic workloads, and troubleshooting performance bottlenecks in large-scale Snowflake environments. Furthermore, you will 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. In terms of security, governance, and compliance, you will define RBAC, data masking, row-level security, and encryption policies in Snowflake. You will ensure compliance with GDPR, CCPA, HIPAA, and SOC2 regulations and establish data lineage, cataloging, and auditing using Snowflake's governance features. As a leader, you will mentor data engineers, analysts, and developers on Snowflake best practices, collaborate with C-level executives to align Snowflake strategy with business goals, and evaluate emerging trends for innovation. Your required skills and qualifications include over 12 years of experience in data warehousing, cloud architecture, and database technologies, 8+ years of hands-on Snowflake architecture and administration experience, and expertise in SQL and Python for data processing. Deep knowledge of Snowflake features, experience with cloud platforms, and strong understanding of data modeling are also essential. Certification as a Snowflake Advanced Architect is a must. Preferred skills include knowledge of DataOps, MLOps, and CI/CD pipelines, as well as familiarity with DBT, Airflow, SSIS, and IICS.,