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.
Rate:
Not specified
Location:
Remote
IR35 Status:
Outside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Senior