Senior Snowflake Data Warehouse Engineer

RCM Technologies, Inc. is a business and technology solutions provider operating at the intersection of resources and modernization of industries. They are seeking a Senior Snowflake Data Warehouse Engineer to deliver scalable data warehouse solutions that power 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, pricing, and reference data
• Ensure Data Governance: Establish rigorous data quality frameworks, including reconciliation controls and alerting for financial datasets
• Automate Deployments: Streamline Snowflake object deployments and SQL transformations using GitLab CI/CD pipelines and version control
• Collaborate & Consult: Work closely with Business Intelligence engineers and Data Architects to deliver governed, high-performant data solutions
• Maintain Operations: Troubleshoot production failures, perform root cause analysis, and document architectural decisions and operational runbooks

Requirements:

• 7+ years in data engineering or warehousing with 5+ years of hands-on Snowflake experience in production environments
• Proven success in managing databases, schemas, roles, and grants, alongside implementing Streams and Tasks for CDC
• Advanced proficiency in complex window functions, CTEs, analytic queries, and set-based transformations
• 4+ years of experience with ELT frameworks, specifically dbt, for enterprise-grade analytical platforms
• Hands-on experience integrating Snowflake with Azure cloud storage and various upstream financial systems
• Demonstrated experience implementing GitLab CI/CD for SQL transformations and Snowflake object deployments
• Deep understanding of star schemas, Slowly Changing Dimensions (SCD), and large-scale time-series structures
• Familiarity with financial concepts like VaR, factor exposure, performance attribution, and security master data
• Bachelor's or Master's degree in Computer Science, Information Systems, Finance, or a related technical field
• Snowflake SnowPro Core or Advanced Architect certification
• DBT Analytics Engineering certification