Snowflake Data Architect

Job not on LinkedIn

🔥 3 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 10%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Datavail

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 2007

💼 Consulting

🏥 Healthcare

📦 Logistics

Consulting • Healthcare • Logistics

Datavail is a comprehensive IT solutions provider specializing in analytics, application development, database administration, and cloud services. Their offerings span advanced analytics consulting, cloud migration and management, and application modernization, ensuring clients can leverage their data for competitive advantage. Datavail focuses on delivering tailored solutions to enhance data management and operational efficiency across various sectors.

📋 Description

• 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

🎯 Requirements

• 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 • Ability to protect sensitive healthcare data and support client security and compliance requirements

🏖️ Benefits

• 3-month contract duration

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume