Snowflake Data Engineer

Job Summary

Seeking a Senior Snowflake Data Warehouse Engineer for a contract position, the remote role will design and deliver a high-performance data warehouse platform, focusing on investment risk and portfolio analytics while collaborating with BI engineers and data scientists.

Key Responsibilities

• Implement Snowflake schemas and object lifecycle strategies optimized for portfolio analytics and risk workloads
• Build scalable ELT pipelines using dbt and Snowflake-native capabilities, including Streams and Tasks
• Develop high-performance tables, views, and materialized views while leading query optimization initiatives

Required Qualifications

• 7+ years of experience in data engineering or data warehousing
• 5+ years of hands-on Snowflake experience in production environments
• Strong expertise in Snowflake database architecture and role-based access control (RBAC)
• 4+ years of ELT experience, preferably with dbt, and experience implementing GitLab CI/CD pipelines
• Experience integrating Snowflake with Azure cloud storage and working with upstream financial systems