Quick overview
SeniorityMid Senior
Work modeRemote
LocationUnited States
Posted19 hours ago
SQLAWSETLSnowflakeHIPAAAzureSQL Server
Job description
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.
Similar jobs
- PC

Snowflake Data ArchitectNew
Prophecy Consulting · Los Angeles, CA · Hybrid 🇺🇸
SQLETLSnowflake+2TechnologySalary not listed19 hours ago - CU
Senior Data ArchitectNew
CTC USA, LLC · Dallas, TX · Hybrid 🇺🇸
Stakeholder ManagementMongoDBOracle+4TechnologySalary not listed19 hours ago - PC
Azure Data Architect with MedicaidNew
Pioneer Consulting Services LLC · United States · Remote 🇺🇸
SQLETLPython+3TechnologySalary not listed19 hours ago - SP

Principal Data Architect INew
SPECTRUM · Englewood, Colorado · Hybrid 🇺🇸
SQLShellETL+3Technology$110.8k - $196.4k/yr2 hours ago - CT
Data ModelerNew
Cynosure Technologies LLC · Pittsburgh, PA · On-site 🇺🇸
OracleSQLAWS+11Salary not listed19 hours ago - 4C
Database ArchitectsNew
4 Consulting Inc · United States · Hybrid 🇺🇸
Stakeholder ManagementNeo4jAWSSalary not listed19 hours ago - SI
SAP BDC Data Architect Auto Apply
SAP IT Business Systeme · Houston, Texas · Hybrid 🇺🇸
Stakeholder ManagementProject ManagementTechnology$151.9k - $340.9k/yr6 days ago - AS
Lead Informatica Data ArchitectNew
Apex Systems · Charlotte, NC · On-site 🇺🇸
Active DirectoryAzureCI/CDTechnologySalary not listed19 hours ago - TM

Databricks ArchitectNew
Thinking Minds Inc. · Raleigh, NC · Hybrid 🇺🇸
Apache SparkAirflowDatabricks+4Salary not listed19 hours ago - OR

Senior Data Migration Architect - Oracle Health
Oracle · United States · Hybrid 🇺🇸
Stakeholder ManagementOracleSQL+9Salary not listed4 months ago - OR

MySQL Architect, Community & Ecosystem
Oracle · Nashville · Hybrid 🇺🇸
MySQLOracleSpring+9Salary not listed5 months ago - OR

Manager, Data Architecture - Oracle Health
Oracle · United States · Hybrid 🇺🇸
OnboardingOracleMicrosoft Excel+5TechnologySalary not listed6 weeks ago