Senior Snowflake Data Architect

Senior Snowflake Data Architect

JD:Senior Snowflake Data Architect lient-Facing | 8–14 Years ABOUT THE ROLE We are looking for a Senior Snowflake Data Architect to lead end-to-end design and delivery of enterprise data platforms for Fortune 500 clients across Healthcare, FinTech, and Hi-Tech. You will own technical architecture, drive client engagement, and coordinate cross-functional delivery teams — ensuring every solution is production-ready, secure, and cost-optimised. KEY RESPONSIBILITIES Lead team of data engineers to ensure project delivery. Data Ingestion & Pipelines Design end-to-end pipelines using Snowpipe, Snowpipe Streaming, Dynamic Tables, Streams & Tasks. Implement Medallion Architecture (Bronze → Silver → Gold) for real-time and batch workloads. Integrate modern data stack tools — Kafka, Fivetran, dbt, Airflow, Spark — with Snowflake. Performance Tuning & Cost Optimisation Tune queries, clustering keys, materialized views, search optimisation, and warehouse configurations. Design multi-cluster warehouse strategies to meet SLAs while minimising Snowflake credit spend. Conversational BI with Cortex AI Build natural-language BI solutions using Cortex Search and Cortex Analyst. Develop semantic models and RAG-based pipelines; leverage Cortex LLM functions for AI-enriched insights. Security — RBAC & Row-Level Security Design enterprise-grade access control using RBAC, DAC, Row-Level Security, and Column Masking. Protect PII/PHI/PCI data with tag-based masking policies and least-privilege role hierarchies. Data Governance — Snowflake Horizon Implement Horizon for data classification, sensitivity tagging, lineage, and policy enforcement. Drive data quality frameworks, cataloguing, and stewardship workflows for regulatory compliance. Architecture & Data Engineering Lead architecture across Data Warehouse, Lakehouse, Data Mesh, and Data Fabric paradigms. Define data modelling standards (Kimball, Data Vault 2.0) and govern schema evolution across domains. Client Engagement & Delivery Own client-facing technical delivery — architecture reviews, workshops, and CXO/VP briefings. Coordinate between business, project management, and engineering teams across engagements. Drive project planning, effort estimation, decision-making, and risk management. Mentor engineers; uphold code quality, documentation, and CI/CD standards. REQUIRED SKILLS Snowflake 4+ years production Snowflake experience; SnowPro Advanced Architect certification preferred. Expert in Snowpipe, Snowpark, RBAC/RLS, Horizon, Cortex AI, data sharing, and Uni-store. Programming & Processing SQL, Procedures and PL/SQL skills are must. Proficient in Python and PySpark for pipeline development, transformation, and Snowpark UDFs. Experience building both real-time (Kafka, Flink) and batch (Airflow, dbt, Spark) pipelines. Architecture Strong command of Data Warehouse, Lakehouse, Data Mesh, Data Fabric concepts. Cloud-native data architecture experience on AWS, Azure, or GCP. Soft Skills Excellent stakeholder management — internal teams, business owners, and C-suite client contacts. Strong communication, decision-making, and project coordination skills in delivery environments. NICE TO HAVE Knowledge graphs, ontology design, or graph databases (Neo4j, Neptune) with Snowflake. Snowpark ML, feature stores, or LLM-powered data product experience. Prior IT services / consulting / systems integrator background.

Official Taleo metadata: primary skills Snowflake^PySpark; primary location Bengaluru SA; other locations Pune; employment Permanent; posted Aug 10, 2026, 9:30:00 AM.