Full Time Contract Please NO 3rd Party Agencies No C2C Title or Role: Snowflake Data Warehouse Engineer Compensation: Up to $90.00/hour Location: Remote Length of Contract: 6+months Position Description: This role will deliver scalable, high-performant data warehouse powering investment risk and portfolio analytics Responsibilities:
+ Architect Scalable Models: Design and implement dimensional and time-series data models optimized for portfolio hierarchies, security masters, and risk metrics.
+ Build Robust Pipelines: Develop ELT workflows using data build tool (dbt) and native Snowflake features like Streams, Tasks, and Snowpipe for daily and intraday processing.
+ Optimize Performance: Lead query tuning efforts, managing clustering strategies, micro-partitioning, and warehouse sizing for performance-sensitive workloads.
+ Implement CDC Frameworks: Build efficient Change Data Capture and incremental processing strategies for position, pric...