Snowflake Data Architect Healthcare Claims Migration

Snowflake Data Architect Healthcare Claims Migration

Join Our Team: Innovating Health Care with Cutting-Edge Technology

We are looking for an experienced Senior Snowflake Data Architect to lead the migration of protected healthcare claims data (PHI) from AWS SQL Server to Azure and Snowflake. The role focuses on modernizing enterprise data architecture, implementing secure and scalable data replication and ingestion solutions, and enabling advanced analytics and reporting while ensuring compliance with healthcare security and data governance requirements.

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.

Skills

Mandatory Skills:

Snowflake

Data Architecture

Data Migration

AWS SQL Server

Microsoft Azure

Data Replication

Data Modeling

ETL / ELTClaims

Healthcare

PHI Data Security

Data Governance

SQL Performance Optimization

Technical Leadership

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.

Exceptional communication skills.

Ability to deliver exceptional customer service with a positive attitude.