Snowflake Data Architect
Cloud, Data, and Application Experts
Remote · Anywhere USA, United States · Posted November 7, 2026
Just laid off? Start here: a plan for the first weeks
See every open role at Cloud, Data, and Application Experts
More in Technology & Software · Data & Analytics jobs
More roles at Cloud, Data, and Application Experts
Similar jobs
- Senior Data Architect · Arrow ARC
- Principal Data Architect · Mercury General
- AVP-Lead Data Architect · ExlService Holdings
- Senior Data Engineer · ExlService.com
- Lead Data Engineer · ExlService.com
- Principal Data Architect · Supplyhouse.com
Data & Analytics jobs in the rankings
Rankings about data & analytics jobs
- Best cities for data and analytics jobs #1 New York (1,713 openings)
- Best cities for data and analytics pay after cost of living #1 Foster ($232k)
- Most requested AI skills in data and analytics jobs #1 Machine learning engineering (17.1%)
- AI tools named most often in data and analytics jobs #1 Databricks (7.6%)
- Employers with the most data and analytics jobs #1 Amazon (711 roles)
Data & Analytics jobs · Top Data & Analytics employers · All rankings
How AI is used in this kind of work
Among database architects, AI is already used for a large share of the tasks. Measured exposure for database architects: 58% (high).
Share of this job’s tasks that AI is already used for at work, from real usage. It is not a forecast of job loss, and a low number means no use seen yet. Source: Anthropic Economic Index.
Skills this job asks for
Say which you have and which you want to build. We use it to match you to jobs like this one.
About the job
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 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.
Roles and 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.
Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.