[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.ResponsibilitiesArchitect Scalable Models: Design and implement dimensional and time-series data models optimized for portfolio hierarchies, security masters, and risk metricsBuild Robust Pipelines: Develop ELT workflows using data build tool (dbt) and native Snowflake features like Streams, Tasks, and Snowpipe for daily and intraday processingOptimize Performance: Lead query tuning efforts, managing clustering strategies, micro-partitioning, and warehouse sizing for performance-sensitive workloadsImplement CDC Frameworks: Build efficient Change Data Capture and incremental processing strategies for position, pricing, and reference dataEnsure Data Governance: Establish rigorous data quality frameworks, including reconciliation controls and alerting for financial datasetsAutomate Deployments: Streamline Snowflake object deployments and SQL transformations using GitLab CI/CD pipelines and version controlCollaborate & Consult: Work closely with Business Intelligence engineers and Data Architects to deliver governed, high-performant data solutionsMaintain Operations: Troubleshoot production failures, perform root cause analysis, and document architectural decisions and operational runbooksSkills7+ years in data engineering or warehousing with 5+ years of hands-on Snowflake experience in production environmentsProven success in managing databases, schemas, roles, and grants, alongside implementing Streams and Tasks for CDCAdvanced proficiency in complex window functions, CTEs, analytic queries, and set-based transformations4+ years of experience with ELT frameworks, specifically dbt, for enterprise-grade analytical platformsHands-on experience integrating Snowflake with Azure cloud storage and various upstream financial systemsDemonstrated experience implementing GitLab CI/CD for SQL transformations and Snowflake object deploymentsDeep understanding of star schemas, Slowly Changing Dimensions (SCD), and large-scale time-series structuresFamiliarity with financial concepts like VaR, factor exposure, performance attribution, and security master dataBachelor's or Master's degree in Computer Science, Information Systems, Finance, or a related technical fieldSnowflake SnowPro Core or Advanced Architect certificationDBT Analytics Engineering certificationCompany OverviewRCM Technologies, Inc. (Nasdaq: RCMT) is a business and technology solutions provider with world-class talent in key market segments. It was founded in 1971, and is headquartered in Pennsauken, New Jersey, US, with a workforce of 1001-5000 employees. Its website is http://www.rcmt.com.Company H1B SponsorshipRCM Technologies, Inc. has a track record of offering H1B sponsorships, with 9 in 2025, 13 in 2024, 6 in 2023, 5 in 2022, 21 in 2021, 10 in 2020. Please note that this does not guarantee sponsorship for this specific role.