Snowflake Architect

Experience- 12+ years

Location- Hyderabad, Pune

JD-

Job Summary

We are seeking an experienced Snowflake Architect with 15+ 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.

Key Responsibilities

1. Snowflake Architecture & Design

• 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 (AWS) Snowflake deployments with seamless integration.
• Design data sharing, replication, and failover strategies for high availability.

2. Performance Optimization & Scalability

• Optimize query performance using Snowflake features (warehouse sizing, caching, materialized views).
• Implement automated scaling strategies for dynamic workloads.
• Troubleshoot and resolve performance bottlenecks in large-scale Snowflake environments.

3. Data Integration & Pipeline Development

• Architect ETL/ELT pipelines using Snowflake, Coalesce and other tools.
• Integrate Snowflake with BI tools (Tableau, Power BI), ML platforms, and APIs.
• Implement CDC (Change Data Capture), streaming, and batch processing solutions.

4. Security, Governance & Compliance

• Define RBAC, data masking, row-level security, and encryption policies in Snowflake.
• Ensure compliance with GDPR, CCPA, HIPAA, and SOC2 regulations.
• Establish data lineage, cataloging, and auditing using Snowflake’s governance features.

5. Team Leadership & Strategy

• 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 (AI/ML in Snowflake, Iceberg tables, Unistore) for innovation.

Required Skills & Qualifications

• 12+ years in data warehousing, cloud architecture, and database technologies.
• 8+ years of hands-on Snowflake architecture & administration experience.
• Expertise in SQL, Python for data processing.

Deep knowledge of Snowflake features (Time Travel, Zero-Copy Cloning, Snowpark, Streams & Tasks).

• Experience with cloud platforms (AWS S3, Azure Blob)
• Strong understanding of data modeling (star schema, data vault, 3NF).
• Certifications: Snowflake Advanced Architect.

Preferred Skills

· Knowledge of DataOps, MLOps, and CI/CD pipelines.

· Familiarity with DBT, Airflow, SSIS & IICS

Job Type: Full-time

Pay: From ₹2,000,000.00 per year

Schedule:

• Monday to Friday

Application Question(s):

• How many years of total experience do you currently have?
• How many years of experience do you have with Snowflake architecture?
• How many years of experience do you have with with cloud platforms (AWS S3, Azure Blob)?
• How many years of experience do you have with Python?
• What is your current CTC?
• What is your expected CTC?
• What is your notice period/ LWD?
• What is your current location?