[Remote] Senior Snowflake Data Warehouse Engineer
Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Company Overview
Company H1B Sponsorship