Snowflake Data Engineer

Job Summary

Working remotely on a contract basis, a senior-level Snowflake Data Engineer will implement Snowflake schemas, develop scalable data models, and build robust ELT pipelines to support investment risk and portfolio analytics for an initial six-month engagement.

Key responsibilities

• Implement Snowflake schemas and object lifecycle strategies optimized for risk and portfolio analytics workloads
• Develop scalable, dimensional, and time-series data models supporting portfolio hierarchies and risk metrics
• Build robust ELT pipelines using dbt and native Snowflake capabilities for daily and intraday data processing

Required qualifications

• 7+ years of experience in data engineering or data warehousing roles
• 5+ years of hands-on Snowflake experience in production environments
• Expert-level SQL skills with experience in complex queries and performance tuning
• 4+ years of experience with ELT frameworks, preferably dbt
• Experience integrating Snowflake with Azure cloud storage and upstream financial systems