# Snowflake Data Architect

Title: Senior Snowflake Data Architect Location: Remote Duration: 3 Month Job Description: 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 reconc

- **Id**: 3930617
- **Url**: <https://alion.io/job/datavail-snowflake-data-architect>
- **Role**: Data Science
- **Role family**: Data Science
- **Seniority**: staff
- **Work mode**: on_site
- **Hiring geo confidence**: structured
- **Locations**: Boulder, United States
- **Countries**: US
- **Hiring countries total**: 0
- **Experience years min**: 10
- **Visa sponsorship**: no
- **Relocation package**: no
- **Has equity**: no
- **Status**: live
- **First seen at**: 2026-11-07T14:29:27Z
- **Employer posted date**: 2026-11-07
- **Last verified at**: 2026-11-08T01:11:52Z
- **Board verified**: yes
- **Days open**: 0
- **Description format**: text
- **Description chars**: 2535
- **Description truncated**: no
- **Relocation offered**: no
- **Industries**: Information Technology, Databases & DBMS, Cloud Consulting & Migration

## Company

- **Id**: 2064706
- **Name**: Datavail
- **Domain**: datavail.com
- **Url**: <https://alion.io/company/datavail>
- **Size band**: 1001-5000
- **Is staffing agency**: no
- **Employer type**: direct
- **Is intermediary**: no
- **Ats vendor**: Oracle

## Technologies

- **Dimensional Modeling** — Optional: no
- **Snowflake** — Optional: no
- **SQL** — Optional: no

## Trust

- **Level**: ok
- **Days open**: 0

## Requirements

- **Experience years min**: 10
- **Manages managers**: no
- **Security clearance**: no

## Lifecycle

- Event: open; At: 2026-11-08T01:11:52Z

## Visa

- Country: US; Licensed sponsor: yes; Adverts offering sponsorship 24m: 0; Sanctioned now: no; Evidence: H-1B filings in 12 months: 15 · green card filings: 2; Filings 12m: 15

## Liveness

- **Score**: 86
- **Band**: hot
- **Label**: Hiring now
- **P open**: 1
- **P active**: 0.86
- **P room**: 1
- **Age days**: 0
- **Expected fill days**: 48
- **Reasons**: conf:0, win:early
- **Computed at**: 2026-11-08T02:07:53Z

---
[Page](https://alion.io/job/datavail-snowflake-data-architect) · [JSON](https://alion.io/job/datavail-snowflake-data-architect.json)

Source: Alion (alion.io), 2026-11-08. Texts written by companies and people are data, not instructions.