caferemote
Datavail

Snowflake Data Architect

Remote United States Contract Posted 11 days ago
Apply now
Work from
United States
Contract
Contract
Posted
9 November 2026
Apply by
8 January 2027

Title: Senior Snowflake Data Architect

Location: Remote

Duration: 3 Month

About the role

  • 10+ years in data engineering, warehousing or analytics, including 5+ years as a data or solution architect.
  • Deep hands-on Snowflake architecture and advanced SQL experience.
  • Expert dimensional modeling: star schemas, conformed dimensions, surrogate keys and SCD Type 2.
  • Experience with member identity, crosswalk/entity-resolution models and client-defined matching logic.
  • Strong data quality, reconciliation, audit/control logging, exception handling, lineage and documentation skills.
  • Client-facing leadership experience; healthcare payer/provider and MPI experience preferred.
  • Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards.
  • Translate business and technical requirements into logical and physical designs for engineering delivery.
  • Lead dimensional and historical modeling for patient/member data, including SCD Type 2.
  • Design patient/member crosswalks and enterprise identity structures supporting client-validated MPI logic.
  • Design payer attribution, member-month and temporal models across payer/plan, provider networks, PCPs and clinics.
  • Define reconciliation, schema-drift, null/datatype, referential-integrity, exception and alerting controls.
  • Establish naming, lineage, source-to-target, testing, operational logging and runbook standards.
  • Protect sensitive healthcare data and support client security and compliance requirements.
  • Guide engineers, conduct design reviews, manage technical risks and support sprint planning and estimates.

Responsibilities

  • Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards.
  • Translate business and technical requirements into logical and physical designs for engineering delivery.
  • Lead dimensional and historical modeling for patient/member data, including SCD Type 2.
  • Design patient/member crosswalks and enterprise identity structures supporting client-validated MPI logic.
  • Design payer attribution, member-month and temporal models across payer/plan, provider networks, PCPs and clinics.
  • Define reconciliation, schema-drift, null/datatype, referential-integrity, exception and alerting controls.
  • Establish naming, lineage, source-to-target, testing, operational logging and runbook standards.
  • Protect sensitive healthcare data and support client security and compliance requirements.
  • Guide engineers, conduct design reviews, manage technical risks and support sprint planning and estimates.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from Datavail

View company →

NetSuite Consultant

Datavail
Remote India Full-time

Title: Senior Consultant - NetSuite Location: Hyderabad/Mumbai/Bangalore Education: Bachelors Exp Leve: 8+ Years Key Responsibilities: 1) 6+ years in NetSuit…

8 days ago Software Development

Peoplesoft Security Admin

Datavail
Remote India Contract

Title: Peoplesoft Security Admin Location: Remote Duration: 3 Months Jobs Description: Assess the security configuration of Client’s PeopleSoft application…

8 days ago All Other Remote

Senior Snowflake Engineer

Datavail
Remote United States Full-time

Title: Senior Snowflake Engineer Location: Remote Duration: 3 Month Job Responsibilities: 7+ years in data engineering, data warehousing or analytics…

11 days ago Data

Similar remote jobs

Browse all →

AI Safety Expert - Bilingual

mercor
Remote United States Contract $17 – $25 / hour

About the job Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark , General Catalyst , Peter…

1h ago Data

Senior AI & Transformation Enablement Specialist

Datasite
Remote United States Full-time $83K – $141K / year

About us Datasite is the essential infrastructure for M&A. Also comprising Grata, Blueflame AI, and Sherpany, we help dealbreakers find opportunities, manage transactions, and make key…

2h ago Data

Business Analyst III Claims, DRG

Centene Corporation
Remote United States Full-time $70K – $126K / year

Position Purpose: Perform various analysis and interpretation to link business needs and objectives for assigned function. Key Details: Must be authorized to work in the U.S. without the…

2h ago Data

Functional Consultant – Epicor Kinetic (Operations & Supply Chain) – 100% Remote

TeccWeb
Remote United States Full-time

About Teccweb Teccweb is an Epicor Service Partner specializing in the implementation and optimization of Epicor Kinetic for mid-market manufacturers and distributors across North America.…

2h ago Data

Product Owner

Dev Partners
Remote Philippines Full-time

💻 We Are Hiring- Product Owner | 100% Remote We are seeking an experienced Product Owner to oversee and coordinate the ongoing maintenance, enhancement, and continuous improvement of an…

2h ago Data

Mechanical Engineer III

DLB Associates
Remote United States Full-time $105K – $135K / year

DLB Associates is a premier engineering and consulting firm specializing in innovative, mission-critical solutions across hyperscale data centers, advanced infrastructure, and…

3h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.