[Hiring] Snowflake Data Architect @Datavail

Role 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.

Qualifications

• 10+ years in data engineering, warehousing or analytics.
• 5+ years as a data or solution architect.
• Deep hands-on Snowflake architecture and advanced SQL experience.
• Expert in dimensional modeling.
• Experience with member identity and crosswalk/entity-resolution models.
• Strong data quality and documentation skills.
• Client-facing leadership experience.

Requirements

• Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards.
• Translate business and technical requirements into logical and physical designs.
• Lead dimensional and historical modeling for patient/member data.
• Design patient/member crosswalks and enterprise identity structures.
• Design payer attribution and temporal models.
• Define reconciliation and alerting controls.
• Establish naming and operational logging standards.
• Protect sensitive healthcare data.
• Guide engineers and manage technical risks.

Company Description

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.

• Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services.
• Services include consulting, development, designing and building complete data systems, and ongoing support.
• Team comprises experienced, knowledgeable, and certified BI & analytics consultants.
• Proven methodology to help projects succeed, regardless of stage.
• Flexible and client-focused services that add value to organizations.