Snowflake Data Architect – Healthcare Claims Migration

Project description

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.

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.

SKILLS

Must have

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

Nice to have

Exceptional communication skills. Ability to deliver exceptional customer service with a positive attitude.