About this role

Role: Snowflake Data Architect - Healthcare Claims Migration

Location: Remote (USA)

Responsibilities

Design and implement enterprise-scale Snowflake architecture and data models for healthcare PHI claims data.
Lead data migration from AWS SQL Server to Azure and Snowflake, including replication, ingestion, and transformation strategies.
Provide architecture leadership for scalability, security, performance, and cost optimization.
Ensure secure PHI handling and compliance with healthcare security and data governance policies.
Collaborate with business stakeholders to define analytics, reporting, and data consumption requirements.
Guide data engineering teams, review code implementations, and lead performance tuning and query optimization.
Manage technical risks, testing, deployment planning, production readiness, and operational handoff.
Mentor engineering teams and coordinate delivery with offshore resources.

Mandatory Skills:

Mandatory Skills Description

7+ years of experience in data architecture design, including 4+ years of hands-on Snowflake experience designing and implementing enterprise-scale data solutions.
5+ years of experience successfully leading technical projects or initiatives.
Strong expertise in data migration from AWS SQL Server to Azure/Snowflake, data replication, ingestion, transformation, data modeling, and query optimization.
Proven healthcare claims domain experience with a strong understanding of PHI security, compliance, and data governance requirements.
Excellent communication, offshore collaboration, technical leadership, and mentoring skills.
Experience with large-scale healthcare data platform modernization, advanced Snowflake performance and cost optimization, cloud-native data integration patterns, and enterprise analytics/reporting architectures.
Familiarity with healthcare regulatory frameworks such as HIPAA, automated data pipelines, and production deployment best practices is preferred.

Snowflake Data Architect - Healthcare Claims

Key skills