Snowflake Architect

Job Title

Snowflake Architect

Total IT Experience

10 to 15 Years

Location-

PAN India

Relevant Experience Required

• Proven experience in architecting, designing, and delivering enterprise-scale Snowflake data platforms and cloud-native data ecosystems.
• Extensive experience defining enterprise data architecture, data strategy, and target-state modernization roadmaps.
• Strong expertise in designing Data Warehouse, Data Lake, and Lakehouse architectures on Snowflake.
• Hands-on experience with Snowpipe, Streams & Tasks, Dynamic Tables, Data Sharing, Secure Data Sharing, and Snowpark.
• Experience leading large-scale data migration and modernization programs from legacy/on-premises platforms to Snowflake.
• Strong understanding of data modeling, dimensional modeling, data vault, and enterprise data management frameworks.
• Experience architecting real-time and batch data integration solutions using ETL/ELT frameworks.
• Hands-on experience with DBT and modern data stack technologies for transformation and governance.
• Strong knowledge of cloud platforms (AWS, Azure, or GCP) and cloud-native architecture principles.
• Experience establishing enterprise-wide security, governance, compliance, metadata management, and data quality frameworks.
• Proven ability to engage with executive stakeholders, business leaders, enterprise architects, and data engineering teams.
• Experience defining architecture standards, best practices, reusable frameworks, and operating models.
• Strong leadership background in mentoring architects and engineering teams.

Language Requirement

English

Keywords for Resume Search

Snowflake Architect, Enterprise Data Architect, Cloud Data Architect, Snowflake Data Platform, Data Warehouse Architecture, Data Lakehouse, Snowpipe, Streams & Tasks, Snowpark, Dynamic Tables, Data Sharing, Data Governance, Data Modeling, ETL, ELT, DBT, Python, SQL, AWS, Azure, GCP, Cloud Migration, Data Modernization, Enterprise Architecture, Data Strategy, Security, RBAC, CI/CD, DevOps, Airflow, Data Vault, Performance Optimization.

Technical/Functional Skills Must Have

Snowflake Architecture Expertise

• Expert-level experience designing and implementing enterprise Snowflake architectures.
• Deep understanding of:
• Multi-layered Data Warehouse and Lakehouse architectures
• Data Mesh and Modern Data Platform principles
• Snowflake Native Features and Architecture
• Multi-region and multi-cloud deployments
• High availability, disaster recovery, and business continuity strategies
• Expertise in:
• Snowflake Security Architecture
• RBAC and Access Governance
• Query Optimization and Performance Tuning
• Cost Optimization and Workload Management
• Data Sharing and Marketplace capabilities

Enterprise Data Architecture

• Strong experience creating enterprise data architecture blueprints and reference architectures.
• Expertise in:
• Data Modeling (Dimensional, Data Vault, Hybrid Models)
• Data Governance Frameworks
• Metadata Management and Data Lineage
• Master Data Management (MDM)
• Data Quality and Data Stewardship
• Ability to align technical architecture with business objectives and enterprise strategy.

Data Engineering & Modern Data Stack

• Strong knowledge of ETL/ELT frameworks and enterprise integration patterns.
• Hands-on experience with:
• DBT
• Snowpipe
• Streams & Tasks
• Snowpark
• Airflow or equivalent orchestration platforms
• Proficiency in SQL and Python for solution design, automation, and architectural validation.
• Experience supporting AI/ML and advanced analytics workloads on Snowflake.

Cloud & DevOps

• Strong expertise across AWS, Azure, and GCP services relevant to Snowflake solutions.
• Experience defining and implementing:
• DevOps and DataOps operating models
• CI/CD frameworks
• Infrastructure as Code (Terraform preferred)
• Automated deployment strategies
• Monitoring and observability frameworks
• Knowledge of Docker, Kubernetes, and cloud-native architecture patterns.

Leadership & Consulting

• Proven experience driving architecture governance and design reviews.
• Ability to influence senior stakeholders and provide architectural recommendations.
• Experience leading architecture workshops, solution assessments, and technology roadmaps.
• Strong consulting and stakeholder management skills.

Secondary Skills

• Experience with BI platforms such as Power BI, Tableau, Looker, Qlik.
• Exposure to Databricks and modern analytics ecosystems.
• Knowledge of AI/ML platform architecture and MLOps frameworks.
• Experience with data catalog and governance tools such as Collibra, Alation, Informatica, or Purview.
• Understanding of Financial Services, Healthcare, Retail, Manufacturing, or Telecom data domains.
• Certifications in Snowflake, AWS, Azure, GCP, or Enterprise Architecture frameworks.

Key Responsibilities

• Define and own the enterprise Snowflake architecture strategy and roadmap.
• Design scalable, secure, and high-performing Data Lakehouse and Data Warehouse platforms.
• Lead architecture decisions for data modernization, migration, analytics, and AI/ML initiatives.
• Establish enterprise-wide architecture standards, governance frameworks, and best practices.
• Design secure data-sharing models, access controls, and compliance frameworks.
• Provide architectural leadership for Snowflake implementations across business units.
• Work closely with business stakeholders, enterprise architects, platform teams, and engineering teams to translate business requirements into scalable solutions.
• Lead architecture reviews, solution assessments, and technical design workshops.
• Drive performance optimization, workload management, and cost optimization initiatives.
• Guide engineering teams on Snowflake best practices, design patterns, and implementation strategies.
• Define DevOps/DataOps frameworks and deployment standards for Snowflake platforms.
• Evaluate emerging technologies and conduct Proof of Concepts (PoCs) to drive innovation.
• Ensure adherence to security, governance, regulatory, and compliance requirements.
• Mentor architects, technical leads, and engineering teams.
• Create architecture documentation, reference patterns, standards, and reusable assets for enterprise adoption.

Preferred Certifications

• SnowPro Advanced Architect
• SnowPro Core Certification
• AWS Solutions Architect / Azure Solutions Architect / Google Professional Cloud Architect
• TOGAF (Preferred)
• Databricks or DBT Certification (Good to Have