Description

You will design, develop, and optimize Snowflake data models and complex SQL transformations for enterprise analytics.

This role is remote.

Responsibilities

• Design and optimize Snowflake data models, schemas, and SQL transformations.
• Implement ELT frameworks leveraging Snowflake-native capabilities like virtual warehouses and time travel.
• 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