Job Title: Snowflake Data Warehouse Engineer

Location: 100% Remote

Contract Duration: 6 Months + (Possible Extensions)

Overview Our client is seeking a Senior Snowflake Data Warehouse Engineer with 7+ years of data engineering experience and 5+ years of hands-on Snowflake experience in production environments. This role will design and deliver a scalable, high-performance data warehouse platform supporting investment risk and portfolio analytics. The ideal candidate has experience building enterprise-grade analytical platforms, implementing change data capture frameworks, and supporting performance-sensitive financial reporting workloads.

You will collaborate closely with BI engineers, data architects, and data scientists to develop governed and performant data solutions that enable:

• Exposure reporting

• Factor analysis

• Time-series risk metrics

• Stress testing

• Performance attribution

Key Responsibilities

Data Warehouse Architecture

• Implement Snowflake schemas and object lifecycle strategies optimized for portfolio analytics and risk workloads.

• Design dimensional and time-series data models supporting portfolio hierarchies, positions, security master integration, exposures, and risk metrics.

Data Engineering & Pipelines

• Build scalable ELT pipelines using dbt and Snowflake-native capabilities such as Streams, Tasks, and Snowpipe.

• Implement efficient change data capture (CDC) and incremental data processing for position data, pricing, risk datasets, and reference data.

Performance Optimization

• Develop high-performance tables, views, and materialized views.

• Lead query optimization initiatives including clustering strategies, micro-partition awareness, warehouse sizing, query caching, and workload management.

Data Governance & Reliability

• Implement data quality frameworks including reconciliation controls, completeness checks, monitoring, and alerting.

• Document data models, lineage, architecture decisions, governance policies, and operational runbooks.

DevOps & Deployment

• Automate Snowflake deployments and SQL transformations using GitLab CI/CD pipelines and version control best practices.

Production Support

• Troubleshoot production failures, conduct root cause analysis, and remediate issues impacting reporting timelines.

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, RBAC, schema and object management

• Experience building Streams and Tasks for CDC and scheduling

• Experience building materialized views and performance-driven models

SQL & Data Modeling

• Expert-level SQL skills (window functions, CTEs, analytical queries, query performance tuning, set-based transformations)

• Strong knowledge of analytical data modeling (star schemas, fact and dimension tables, slowly changing dimensions, aggregates, large-scale time-series structures)

Data Transformation & DevOps

• 4+ years of ELT experience, preferably with dbt

• Experience implementing GitLab CI/CD pipelines for Snowflake or SQL deployments

Cloud & Integration

• Experience integrating Snowflake with Azure cloud storage

• Experience working with upstream financial systems

Preferred Experience

• Experience with financial, investment, or portfolio datasets

• Familiarity with portfolio accounting, security master data, and market data feeds

• Understanding of financial risk concepts such as Value at Risk (VaR), factor exposure, stress testing, and performance attribution

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively “Judge”) to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.