Description

You will own the design, development, and optimization of Snowflake data models and complex SQL transformations for enterprise analytics. You implement ELT frameworks using Snowflake-native features like virtual warehouses, clustering, time travel, and zero-copy cloning. You lead migration initiatives from legacy platforms including Ab Initio, Hadoop/Spark, SAS, and relational databases. You perform performance tuning and cost optimization through warehouse sizing, query optimization, and workload isolation. You integrate Snowflake with Spark pipelines, Python processing, and BI tools. You provide production support, incident resolution, and maintain operational runbooks.

Responsibilities

• Design and optimize Snowflake data models, schemas, and SQL transformations.
• Implement ELT frameworks leveraging Snowflake-native capabilities.
• Lead phased migrations from Ab Initio, Hadoop, SAS, and legacy databases.
• Tune performance and reduce costs via warehouse sizing and query optimization.
• Integrate Snowflake with Spark, Python, and downstream analytics tools.

Required Skills

• 8+ years of data engineering experience.
• Expertise in Snowflake data modeling and SQL optimization.
• Strong proficiency in Spark, Python, and ELT processes.
• Experience migrating from Ab Initio, Hadoop, and SAS.
• Knowledge of Agile methodologies.
• Bachelor's degree in a relevant field.
• Ability to maintain 3+ year tenure stability in previous roles.

Preferred Skills

• Experience with workload isolation and monitoring in managed-capacity models.

Key Skills

Education

Bachelor's degree