Trajectory Recruiting is seeking a Senior Snowflake Data Warehouse Engineer to lead the development of a scalable data warehouse for investment risk and portfolio analytics. The role involves architecting solutions for critical financial workloads and optimizing an analytical platform for exposure reporting and stress testing.
Responsibilities:
- Architect & Implement: Design Snowflake schemas and object strategies optimized for risk and portfolio analytics
- Data Modeling: Build dimensional and time-series models supporting security master integration and portfolio hierarchies
- ELT Engineering: Develop robust pipelines using dbt , Snowflake Streams, Tasks, and Snowpipe for intraday processing
- Optimization: Lead query performance efforts, including clustering strategies, micro-partition awareness, and warehouse sizing
- Automation: Drive deployments using GitLab CI/CD and version control best practices
Requirements:
- 7+ years in Data Engineering/Warehousing
- 5+ years of hands-on Snowflake production experience (managing roles/grants, CDC, and materialized views)
- Expert SQL: Deep experience with complex window functions, CTEs, and set-based transformations
- ELT Mastery: 4+ years with frameworks like dbt
- Cloud & CI/CD: Proven experience with Azure cloud storage and GitLab CI/CD pipelines
- Familiarity with financial datasets (Security Master, Market Data) or risk concepts (VaR, Factor Exposure) is highly preferred