We are seeking an experienced Senior Snowflake Data Architect for a contract role (6+ months) to lead the migration of protected healthcare claims data from AWS SQL Server to Azure and Snowflake. This remote position 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.
Qualifications
Required
7+ years of experience in data architecture design, including 4+ years of hands-on Snowflake experience designing and implementing enterprise-scale data solutions.
Show the full description
5+ years of experience successfully leading technical projects or initiatives.
Strong expertise in data migration from AWS SQL Server to Azure/Snowflake.
Strong expertise in data replication, ingestion, and transformation.
Strong expertise in data modeling and query optimization.
Proven healthcare claims domain experience.
Strong understanding of PHI security, compliance, and data governance requirements.
Excellent communication skills.
Excellent offshore collaboration and technical leadership skills.
Excellent mentoring skills.
Preferred
Experience with large-scale healthcare data platform modernization.
Advanced Snowflake performance and cost optimization expertise.
Cloud-native data integration patterns.
Enterprise analytics and reporting architectures.
Familiarity with healthcare regulatory frameworks such as HIPAA.
Experience with automated data pipelines.
Production deployment best practices.
Ability to deliver exceptional customer service with a positive attitude.
