Snowflake Architect

Role - Snowflake Architect

Years of Experience - 5 to 10 years

Location - Pan India

• 10+ years of overall experience in architecting and building data and analytics solutions including data modeling, ETL/ELT pipelines and performance optimization.
• Deep knowledge of Snowflake features such as virtual warehouses, micro-partitions, data sharing and security best practices.
• Strong SQL skills for complex queries, stored procedures, and optimization; familiarity with Python or other scripting languages for automation.
• Hands-on experience with Azure and/or AWS services (e.g., S3, Azure Data Lake, IAM, networking) for hybrid or multi-cloud architectures.
• Expertise in implementing role-based access control, encryption, compliance standards and auditing within Snowflake and cloud environments.
• Ability to optimize compute/storage costs, manage workloads, and tune queries for high performance.
• SnowPro Core or Advanced Architect certification is a strong plus.
• Ability to lead architecture discussions, mentor teams and collaborate with business and technical stakeholders
• Excellent communication, presentation, and interpersonal skills
• Experienced in working in a customer facing role
• Responsibility
• Conduct workshops with business and IT stakeholders to capture, document and summarize data, integration and analytics requirements for the Snowflake.
• Design optimized data models and schemas
• Integrate Snowflake with multiple data sources and platforms (on‑prem DBs, files, APIs, Azure/AWS services, Kafka/ETL tools) ensuring secure, reliable data ingestion and curation.
• Establish governance and security standards—RBAC, network policies, SSO/MFA, data classification, masking and secure data sharing across accounts/partners.
• Optimize performance and cost by tuning virtual warehouses, managing micro‑partitions/clustering, caching, query profiling and workload isolation for concurrency and throughput.
• Guide the technical team on architecture patterns and migration approaches (zero‑copy cloning, Time Travel, Fail‑safe) and oversee implementation to production readiness.
• Conduct proofs of concept and create reusable accelerators and reference architectures.
• Guide technical team of deliverables and get the solution implemented
• Conduct proof of concepts and create differentiating assets
• Conduct training and workshops on new technologies and trends