Key Responsibilities

Own end-to-end target-state Snowflake architecture for enterprise migration and modernization engagements, including landing zone, RBAC, data sharing, and multi-account design.
Lead current-state assessments of legacy Teradata, Oracle, Netezza, SQL Server, and Hadoop estates; build workload heat maps and migration wave plans.
Define migration patterns (lift-and-shift, re-platform, re-engineer) and decide the right approach per workload based on TCO, risk, and business value.
Architect ELT pipelines on Snowflake using dbt or comparable transformation tooling — establish project structure, model layering (staging, intermediate, marts), testing, documentation, and CI/CD.
Design ingestion and transformation frameworks using Snowpark, Streams & Tasks, Agile Tables, and Snowpipe for batch, micro-batch, and streaming sources.
Provide technical leadership to delivery pods of 6 to 20 engineers across data engineering, SQL conversion, ELT modeling, testing, and DevOps tracks.
Drive automation of SQL conversion, data validation,



and reconciliation using Snowflake-native tooling and accelerators such as SnowConvert, Bladebridge, or Datametica.
Conduct architecture and code reviews; enforce engineering standards, naming conventions, and reusable patterns across ELT projects.
Own production cutover planning, rollback strategy, and hypercare — ensuring zero data loss and minimal business disruption.
Support pre-sales — lead solution workshops, RFP responses, estimations, and SOW construction for qualified Snowflake opportunities.

Must-Have Qualifications

Experience: 8 to 12 years in data warehousing, data engineering, or analytics platform architecture, with at least 4 years hands-on Snowflake delivery.
Migration depth: Led at least 2 end-to-end migrations from a legacy MPP/EDW (Teradata, Netezza, Exadata, SQL Server, or Hadoop) to Snowflake at enterprise scale.
Snowflake mastery: Robust command of virtual warehouses, RBAC, resource monitors, micro-partit

📌 Senior Snowflake Architect Bengaluru (India)
🏢 Ascendion
📍 India