Description

You will own the end-to-end target-state Snowflake architecture for enterprise migration and modernization engagements, leading technical delivery across data engineering and cloud infrastructure.

This role is on-site.

Responsibilities

• Lead current-state assessments of legacy Teradata, Oracle, Netezza, SQL Server, and Hadoop estates, building workload heat maps and migration wave plans.
• Architect ELT pipelines on Snowflake using dbt or comparable tooling, establishing model layering, testing, documentation, and CI/CD standards.
• Design ingestion and transformation frameworks using Snowpark, Streams & Tasks, Dynamic Tables, and Snowpipe for batch and streaming sources.
• Provide technical leadership to delivery pods of 6 to 20 engineers, driving automation of SQL conversion and data validation using accelerators like SnowConvert or Bladebridge.
• Own production cutover planning, rollback strategy, and hypercare, ensuring zero data loss and minimal business disruption.

Required Skills

• 8 to 12 years in data warehousing or analytics platform architecture, with at least 4 years hands-on Snowflake delivery.
• Proven track record of leading at least 2 end-to-end migrations from legacy MPP/EDW (Teradata, Netezza, Exadata, SQL Server, or Hadoop) to Snowflake.
• Deep mastery of Snowflake internals: virtual warehouses, RBAC, resource monitors, micro-partitioning, clustering, query profile analysis, time travel, zero-copy clone, secure data sharing, and replication/failover.
• Expert SQL proficiency plus working knowledge of Python, with production experience in Snowpark and Airflow.
• Hands-on architecture experience on AWS, Azure, or GCP, including IAM, networking (PrivateLink), storage, and key management interplay with Snowflake.
• Strong command of data governance constructs: masking policies, row access policies, tagging, object dependencies, and integration with Collibra, Alation, or Atlan.
• Ability to design cost-optimized Snowflake deployments, including warehouse sizing, workload isolation, and query tuning.
• SnowPro Core certification required.

Preferred Skills

• SnowPro Advanced: Architect certification.
• Hands-on experience with dbt (Core or Cloud) on Snowflake, or equivalent ELT tooling like Coalesce or Matillion.
• Experience with Snowflake Cortex (LLM functions, Search, Analyst) for GenAI use cases.

Key Skills

Education

Bachelor's degree