Snowflake Data Architect - Healthcare Claims
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: 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.