Snowflake Data Warehouse Engineer
Remote
Snowflake Data Warehouse Engineer (Contract)
Location: 100% Remote
Contract Duration: 6 Months + (Possible Extensions)
Overview
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
- Risk metrics
- Data Engineering & Pipelines
- Build scalable ELT pipelines using dbt and Snowflake-native capabilities such as:
- Streams
- Tasks
- Snowpipe
- Implement efficient change data capture (CDC) and incremental data processing for:
- Position data
- Pricing
- Risk datasets
- Reference data
- Performance Optimization
- Develop high-performance:
- Tables
- Views
- Materialized views
- Lead query optimization initiatives including:
- Clustering strategies
- Micro-partition awareness
- Warehouse sizing
- Query caching
- 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
- Operational runbooks
- DevOps & Deployment
- Automate Snowflake deployments and SQL transformations using:
- GitLab CI/CD pipelines
- Version control best practices
- Production Support
- Troubleshoot production failures
- Conduct root cause analysis
- 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
- Role-based access control (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, including:
- Window functions
- CTEs
- Analytical queries
- Query performance tuning
- Set-based transformations
Strong knowledge of analytical data modeling, including:
- 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
- Market data feeds
Understanding of financial risk concepts such as:
- Value at Risk (VaR)
- Factor exposure
- Stress testing
- Performance attribution