Senior Snowflake Data Warehouse Engineer

RCM Technologies • United States, United States • 1h ago

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, 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.

Qualifications:

Experience: 7+ years in data engineering or warehousing with 5+ years of hands-on Snowflake experience in production environments.

Snowflake Mastery: Proven success in managing databases, schemas, roles, and grants, alongside implementing Streams and Tasks for CDC.

Expert-Level SQL: Advanced proficiency in complex window functions, CTEs, analytic queries, and set-based transformations.

Transformation Expertise: 4+ years of experience with ELT frameworks, specifically dbt, for enterprise-grade analytical platforms.

Cloud Integration: Hands-on experience integrating Snowflake with Azure cloud storage and various upstream financial systems.

DevOps Proficiency: Demonstrated experience implementing GitLab CI/CD for SQL transformations and Snowflake object deployments.

Analytical Modeling: Deep understanding of star schemas, Slowly Changing Dimensions (SCD), and large-scale time-series structures.

Domain Knowledge: Familiarity with financial concepts like VaR, factor exposure, performance attribution, and security master data.

Education & Certifications:

Education: Bachelor's or Master's degree in Computer Science, Information Systems, Finance, or a related technical field.

Certifications (Preferred): Snowflake SnowPro Core or Advanced Architect certification; DBT Analytics Engineering certification.

Equal Opportunity Employer: RCM is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Pay Transparency: RCM believes in transparency and fairness in compensation. We are committed to providing our employees with competitive salaries that reflect their skills, experience, and contributions to our organization. As part of our commitment to pay transparency, we want to provide you with as much information as possible about our compensation practices. About RCM: RCM is publicly traded on Nasdaq under the symbol RCMT. RCM is a business and technology solutions provider with world-class talent in key market segments. We help design, build, and enable the Industries of Tomorrow, Today. Operating at the intersection of resources, critical infrastructure, and modernization of industries, RCM is a provider of services in Life Sciences, Data & Solutions (IT), Healthcare, Engineering, Aerospace & Defense, and Process & Industrial. Disclaimer: This job posting is intended to describe the general nature and the level of the work to be performed. It is not intended to include every job duty and responsibility specific to the position. RCM reserves the right to amend and change responsibilities to meet business and organizational needs as necessary.

Similar Jobs

Supply Chain Technician

Emory Healthcare/Emory University • Decatur, GA • 22min ago

IT & Engineering

Overview Be inspired. Be valued. Belong. At Emory Healthcare we fuel your professional journey with better benefits, valuable resources, ongoing mentorship and leadership programs for all @types of jobs, and a supportive...

22min ago

Go to Apply

Supply Technician

Veterans Affairs, Veterans Health Administration • Biloxi, MS • 27min ago

IT & Engineering

Summary This position serves as Supply Technician (Medical) for the Medical Supply Distribution (MSD) areas of Logistics Service within the VA Health Care System. As a Supply Technician, you will provide wards, clinics,...

27min ago

Go to Apply

Supply Technician

Veterans Affairs, Veterans Health Administration • Miami, FL • 29min ago

IT & Engineering

Summary The Miami VA Healthcare System's Supply Chain Management Service is seeking an experienced and dynamic Supply Technician (Medical). Ideal applicants are those who want to contribute to the achievement of quality...

29min ago

Go to Apply

Warehouse Technician

Sherwin-Williams • Aurora, CO • 1h ago

IT & Engineering

This position is an essential part of Sherwin's distribution network. This role safely loads and unloads trucks, accurately picks paint and paint-related product orders, and ships product orders to our customers. This po...

1h ago

Go to Apply

Warehouse Tech

Magnetic Technologies Corporation • Greenville, OH • 1h ago

IT & Engineering

Duties and responsibilities To provide an important linkage between the production teams and our customers. Individual is responsible for materials and activities within the warehouse and for out bound shipments. The dut...

1h ago

Go to Apply

Warehouse Technician

Champion Pet Foods • Auburn, KY • 1h ago

IT & Engineering

Job Description: Do you love a team environment and pets? We may have the perfect job for you. Warehousing, innovation, and happy pets too. We are excited to announce that we are looking for a Warehouse Technician - 2nd...

1h ago

Go to Apply

Solution Operations Support - Managed Technology and Digital Solutions

Robert Half • San Ramon, CA • 1h ago

IT & Engineering

The Solution Operations Support provides critical support to the Solution Operations Manager and the Managed Technology & Digital Solutions (MTS/DS) team. This role is responsible for coordinating projects, maintaini...

1h ago

Go to Apply

Warehouse Packaging Technician

BASF • United States, United States • 1h ago

IT & Engineering

Warehouse Packaging Technician>Apply now Now hiring! Warehouse Packaging Technician Bishop, TX - Overtime eligibility. The hourly pay rate starts at $19.10, with a progression plan that rewards skill development and m...

1h ago

Go to Apply

Warehouse Technician $18.00 p/h

Personnel Plus, Inc. - Boise • Boise, ID • 1h ago

IT & Engineering

This job was posted by https://idahoworks.gov : For more information, please see: https://idahoworks.gov/jobs/2557199 Personnel Plus, Inc. is NOW HIRING a Warehouse Tech! Monday-Friday, 9 AM- 6 PM * Overtime required \$1...

1h ago

Go to Apply

Information Warehouse Technical Engineer

Walbridge Aldinger • Detroit, MI • 1h ago

IT & Engineering

Technical Engineer Category Tech Engineer / Tech Engineer Manager Work Location US- ID 2025-2238 Overview We want you to join our team. Through industry-leading innovation our company has forged a legacy of quality and s...

1h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)