Senior Snowflake Engineer

Jobgether

United States

Remote

USD 150,000 - 210,000

Full time

16 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote work within US
3-month contract

Job summary

Jobgether seeks a Senior Snowflake Engineer in the United States to build and optimize Snowflake transformations across staging, curated, and conformed data layers. You will implement data models and reconciliation logic, ensuring robust auditability and production reliability.

The role focuses on complex data engineering challenges, including identity matching, historical tracking, and payer attribution, with remote work within the US. Collaborative, client-focused delivery is essential.

Qualifications

  • 7+ years in data engineering, warehousing, or analytics with Snowflake delivery experience.
  • Advanced Snowflake SQL, including layered transformations and performance tuning.
  • Dimensional modeling with facts, dimensions, surrogate keys, and SCD Type 2.
  • Source-to-target mapping, incremental processing, and reconciliation.
  • Data-quality validation, audit logging, error handling, and production support.
  • Git-based version control, testing, and deployment practices.
  • Ability to build restartable, auditable data pipelines with monitoring.

Responsibilities

  • Build and optimize Snowflake SQL transformations across data layers.
  • Implement tables, views, and transformation logic from data models and mappings.
  • Develop restartable, testable pipelines with auditability and error handling.
  • Implement identity matching logic and data crosswalks for records.
  • Create dimensional models with facts, dimensions, and SCD Type 2 history.
  • Develop member/month outputs and current-state models.
  • Attribution reconciliation against source rosters and discrepancies.

Skills

Snowflake SQL
Data modeling
ETL pipelines
Performance tuning
Git
Data quality
Production support
Troubleshooting

Job description

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a Senior Snowflake Engineer based in the United States.

Join a data management and analytics team delivering modern data solutions for clients across a range of industries. As a Senior Snowflake Engineer, you will play a key role in building, optimizing, and maintaining robust data transformations and warehouse models using Snowflake. You will work across staging, curated, and conformed data layers, translating approved data models and business requirements into reliable, production-ready solutions. The role focuses on complex data engineering challenges, including member identity matching, historical tracking, payer attribution, and data reconciliation. You will also strengthen data quality, auditability, and operational reliability through automated checks, monitoring, and effective error handling. Working in a collaborative, client-focused environment, you will contribute technical expertise, documentation, and practical solutions that support accurate and trusted data.

Accountabilities
  • Build, develop, and optimize Snowflake SQL transformations across staging, curated, and conformed data layers.
  • Implement tables, views, and transformation logic based on approved data models and source-to-target mappings.
  • Develop restartable, testable, and maintainable data processing workflows with robust auditability and error handling.
  • Implement patient and member identity matching logic, crosswalks, and exception handling for duplicate, unmatched, or conflicting records.
  • Build and maintain dimensional models, including facts, dimensions, surrogate keys, and Slowly Changing Dimension Type 2 (SCD Type 2) history.
  • Develop member-month outputs and current-state data models.
  • Implement payer attribution across payers, plans, provider networks, primary care providers, and clinics while preserving monthly history.
  • Reconcile modeled attribution against source rosters, documenting discrepancies and unassigned members.
  • Automate data-quality checks covering row counts, null values, data types, referential integrity, and schema drift.
  • Build audit, balance, and control logging, along with metrics, alerting, and reconciliation evidence.
  • Troubleshoot production issues, investigate defects, and optimize query performance and processing reliability.
  • Maintain technical documentation and participate in code reviews, project planning, and client demonstrations.
Requirements
  • 7+ years of experience in data engineering, data warehousing, or analytics engineering, with recent hands-on Snowflake delivery experience.
  • Advanced proficiency in Snowflake SQL, including layered transformations, query optimization, performance tuning, and production troubleshooting.
  • Strong experience implementing dimensional data models, including fact and dimension tables, surrogate keys, and SCD Type 2.
  • Experience developing source-to-target mappings, translating complex business rules, and implementing incremental processing and reconciliation.
  • Hands-on knowledge of data-quality validation, audit and control logging, error handling, and production support.
  • Experience with Git-based version control, software testing, and deployment practices.
  • Ability to build reliable, restartable, and supportable data pipelines with clear monitoring and audit trails.
  • Strong analytical and troubleshooting skills, with the ability to investigate complex data discrepancies and resolve issues effectively.
  • Healthcare payer or provider data experience is preferred.
  • Familiarity with Master Patient Index (MPI), member identity resolution, or patient/member matching is an advantage.
  • Strong communication and collaboration skills, including the ability to document technical solutions, contribute to reviews and planning, and participate in client-facing demonstrations.
Benefits
  • Remote working arrangement within the United States.
  • Three-month contract duration.
  • Full-time schedule.
  • Opportunity to contribute to data management and analytics projects across diverse client environments.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Snowflake Engineer
Senior Snowflake Engineer

Datavail • United States

Remote
USD 140,000 - 190,000
Key Skills: Senior Snowflake Engineer
Key Skills: Senior Snowflake Engineer

Datavail • Boulder (CO)

Remote
USD 120,000 - 180,000
Senior Data Engineer
Senior Data Engineer

Madison-Davis • United States

Remote
USD 140,000 - 190,000
Snowflake Data Architect
Snowflake Data Architect

Datavail • United States

Remote
USD 150,000 - 180,000
Software Engineer
Software Engineer

Spectrum Staffing Services • New Jersey

On-site
USD 140,000 - 180,000
Modern cloud data technologies
Snowflake architecture focus
Full development lifecycle
+2
Senior Snowflake Engineer
Senior Snowflake Engineer

Datavail Infotech • United States

Remote
USD 130,000 - 190,000
Senior Data Engineer - Snowflake Expert
Senior Data Engineer - Snowflake Expert

The Timberline Group • St. Louis (MO)

On-site
USD 130,000 - 170,000
Medical, Dental & Vision insurance
401(k) with company match
PTO
+5
Forward Deployed Data Engineer
Forward Deployed Data Engineer

abacusinsights • United States

Remote
USD 150,000 - 200,000
Snowflake Engineer
Snowflake Engineer

Experis-US • New Providence (NJ)

Remote
USD 96,000 - 103,000
Sr Data Engineer with Snowflake
Sr Data Engineer with Snowflake

Quantum Technologies LLC • Houston (TX)

On-site
USD 84,000 - 120,000