Sign upLog in

Senior Snowflake Data Warehouse Engineer

RCM Technologies, Inc. | Life Sciences / Data & Solutions

Madison, WI(remote)

Apply
JOB DETAILS
SALARY
SKILLS
Aerospace Engineering, Aerospace and Defense, Analysis Skills, Architectural Services, Biology, Business Intelligence, Centers for Disease Control and Prevention (CDC), Cloud Computing, Cloud Storage, Computer Science, Consulting, Continuous Deployment/Delivery, Continuous Integration, Data Collection, Data Modeling, Data Quality, Data Sets, Data Warehousing, Database Administration, Database Technology, DevOps, Finance, Financial Systems, Health Information Technology, Identify Issues, Information Technology & Information Systems, Manufacturing/Industrial Processes, Market Segmentation, Metrics, Microsoft Windows Azure, Performance Tuning/Optimization, Pricing, Production Systems, Query Analysis, Reconciliation, Risk, Root Cause Analysis, SQL (Structured Query Language), Snowflake Schema, Source Code/Configuration Management (SCM), Star Schema, Value At Risk (VaR), Warehousing
LOCATION
Madison, WI(remote)
POSTED
3 days 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.

About the Company

R

RCM Technologies, Inc. | Life Sciences / Data & Solutions