Snowflake Data Warehouse Engineer

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