Snowflake Data Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Take charge of Snowflake architecture while establishing standards and patterns for staging, curated, and conformed layers.

• Convert business and technical requirements into both logical and physical designs for engineering execution.

• Lead the modeling of dimensions and historical data for patient/member information, including Slowly Changing Dimensions (SCD) Type 2.

• Create patient/member crosswalks and enterprise identity frameworks that align with client-validated Master Patient Index (MPI) logic.

• Develop models for payer attribution, member-months, and temporal aspects across payer/plans, provider networks, Primary Care Physicians (PCPs), and clinics.

• Define controls for reconciliation, schema drift, null/data type validation, referential integrity, exceptions, and alerts.

• Set standards for naming, lineage, source-to-target mappings, testing, operational logging, and runbook documentation.

• Safeguard sensitive healthcare information while adhering to client security and compliance protocols.

• Mentor engineers, conduct design evaluations, manage technical risks, and assist with sprint planning and estimations.

⛳️ Requirements

• Over 10 years of experience in data engineering, warehousing, or analytics, including a minimum of 5 years as a data or solution architect.

• Extensive hands-on expertise in Snowflake architecture and advanced SQL capabilities.

• Proficient in dimensional modeling, including star schemas, conformed dimensions, surrogate keys, and SCD Type 2.

• Familiarity with member identity, crosswalk/entity-resolution models, and client-specific matching methodologies.

• Strong skills in data quality, reconciliation, audit/control logging, exception management, lineage, and documentation.

• Experience in client-facing leadership roles.

• Preferred background in healthcare payer/provider systems and Master Patient Index (MPI) experience.

• Capacity to safeguard sensitive healthcare data and adhere to client security and compliance standards.

🏝️ Benefits

• Contract duration of 3 months.