Data Modeler / Data Architect – Healthcare (Snowflake, Cloud, AI/ML) - 26-01713
Data Modeler / Data Architect – Healthcare (Snowflake, Cloud, AI/ML)
Location: Remote, NY
Duration: 3 Months (Possible Extension)
Position Overview
We are seeking an experienced Data Modeler / Data Architect with deep expertise in the healthcare domain to design, implement, and govern enterprise data models and cloud-native data architectures. This role will support data warehouses, data marts, analytics, reporting, and AI/ML initiatives across Provider, Payer, and Clinical domains.
The ideal candidate will have strong hands-on Snowflake expertise, healthcare interoperability knowledge (FHIR, HL7, X12, DICOM), and experience designing scalable data platforms that support structured, unstructured, and vector data workloads.
Key Responsibilities
Enterprise Data Modeling & Architecture
• Design and maintain conceptual, logical, and physical data models using Erwin
• Define enterprise modeling standards, naming conventions, and governance practices
• Perform reverse engineering of physical models from databases and SQL scripts
• Develop strategies to reduce technical debt and redundant data pipelines
• Establish data contracts and governance frameworks
Dimensional Modeling & Data Warehousing
• Design and implement dimensional models (Star Schema, Snowflake Schema)
• Build scalable data warehouses and data marts for analytics and reporting
• Optimize structures for performance, scalability, and minimal redundancy
• Support enterprise analytics and AI/ML feature engineering
Cloud-Native Data Platform & Snowflake Engineering
• Architect cloud-based platforms on AWS/Azure
• Leverage Snowflake-native features:
• Dynamic Tables
• Streams
• Tasks
• Iceberg Tables
• Develop and optimize:
• Advanced SQL
• Stored procedures
• Data ingestion and transformation pipelines
• Implement cost optimization strategies (credit usage & warehouse right-sizing)
• Ensure high-performance Snowflake architectural patterns
Healthcare Data & Interoperability
• Lead source data mapping into:
• FHIR (exchange)
• OMOP (research/analytics)
• Ensure compliance with:
• LOINC
• SNOMED
• ICD-10
• Work across healthcare data types including:
• Clinical records
• Claims data (X12)
• HL7 interfaces
• Medical imaging (DICOM & non-DICOM)
• ECG/EEG waveforms
• Audio & video clinical transcripts
• Experience with i2b2 is a plus
AI/ML Data Architecture
• Design cloud-native AI/ML data platforms
• Enable scalable feature engineering, model training, and inference
• Collaborate with Data Scientists and ML Engineers
• Support vector and multi-model database architectures
Data Governance & Quality
• Implement data profiling and advanced data analysis techniques
• Ensure data quality, integrity, security, and compliance
• Develop performance and cost governance frameworks
• Maintain enterprise metadata standards
Cross-Functional Collaboration
• Analyze how data flows across systems and business domains
• Identify system errors, deficiencies, and improvement opportunities
• Coordinate testing, system patches, and upgrades
• Create user documentation and training materials
• Evaluate emerging technologies and provide implementation strategies
Required Experience
• 7+ years in Data Architecture, Data Modeling, or Data Warehousing
• 3+ years in Healthcare Domain
• FHIR
• HL7
• X12
• DICOM
• OMOP
• 2+ years deep Snowflake hands-on experience
• Strong SQL and data profiling expertise
• Experience designing multi-model data architectures
• Experience in AWS and/or Azure environments
Preferred Experience
• Experience with Data Mesh or Lakehouse architectures
• Experience with i2b2 data models
• Experience with vector databases and AI/ML workloads
• Experience managing Total Cost of Ownership (TCO) in cloud environments
Educational Requirements
• Bachelor’s Degree in:
• Computer Science
• Systems Engineering
• Applied Mathematics
• Business Administration
• Economics/Statistics
• Telecommunications
• Data Communications
• Or related field
OR
• Equivalent combination of education, training, and progressive experience
Minimum five (5) years of progressive experience in data processing, computer systems, and applications required.
Core Competencies
• Enterprise Data Architecture
• Healthcare Data Standards & Interoperability
• Snowflake Engineering & Optimization
• Dimensional Modeling
• Cloud Data Platforms (AWS/Azure)
• AI/ML Data Enablement
• Data Governance & Quality Management
• Cross-Functional Collaboration
Apply Now
Apply Now
Location: Remote, NY
Duration: 3 Months (Possible Extension)
Position Overview
We are seeking an experienced Data Modeler / Data Architect with deep expertise in the healthcare domain to design, implement, and govern enterprise data models and cloud-native data architectures. This role will support data warehouses, data marts, analytics, reporting, and AI/ML initiatives across Provider, Payer, and Clinical domains.
The ideal candidate will have strong hands-on Snowflake expertise, healthcare interoperability knowledge (FHIR, HL7, X12, DICOM), and experience designing scalable data platforms that support structured, unstructured, and vector data workloads.
Key Responsibilities
Enterprise Data Modeling & Architecture
• Design and maintain conceptual, logical, and physical data models using Erwin
• Define enterprise modeling standards, naming conventions, and governance practices
• Perform reverse engineering of physical models from databases and SQL scripts
• Develop strategies to reduce technical debt and redundant data pipelines
• Establish data contracts and governance frameworks
Dimensional Modeling & Data Warehousing
• Design and implement dimensional models (Star Schema, Snowflake Schema)
• Build scalable data warehouses and data marts for analytics and reporting
• Optimize structures for performance, scalability, and minimal redundancy
• Support enterprise analytics and AI/ML feature engineering
Cloud-Native Data Platform & Snowflake Engineering
• Architect cloud-based platforms on AWS/Azure
• Leverage Snowflake-native features:
• Dynamic Tables
• Streams
• Tasks
• Iceberg Tables
• Develop and optimize:
• Advanced SQL
• Stored procedures
• Data ingestion and transformation pipelines
• Implement cost optimization strategies (credit usage & warehouse right-sizing)
• Ensure high-performance Snowflake architectural patterns
Healthcare Data & Interoperability
• Lead source data mapping into:
• FHIR (exchange)
• OMOP (research/analytics)
• Ensure compliance with:
• LOINC
• SNOMED
• ICD-10
• Work across healthcare data types including:
• Clinical records
• Claims data (X12)
• HL7 interfaces
• Medical imaging (DICOM & non-DICOM)
• ECG/EEG waveforms
• Audio & video clinical transcripts
• Experience with i2b2 is a plus
AI/ML Data Architecture
• Design cloud-native AI/ML data platforms
• Enable scalable feature engineering, model training, and inference
• Collaborate with Data Scientists and ML Engineers
• Support vector and multi-model database architectures
Data Governance & Quality
• Implement data profiling and advanced data analysis techniques
• Ensure data quality, integrity, security, and compliance
• Develop performance and cost governance frameworks
• Maintain enterprise metadata standards
Cross-Functional Collaboration
• Analyze how data flows across systems and business domains
• Identify system errors, deficiencies, and improvement opportunities
• Coordinate testing, system patches, and upgrades
• Create user documentation and training materials
• Evaluate emerging technologies and provide implementation strategies
Required Experience
• 7+ years in Data Architecture, Data Modeling, or Data Warehousing
• 3+ years in Healthcare Domain
• FHIR
• HL7
• X12
• DICOM
• OMOP
• 2+ years deep Snowflake hands-on experience
• Strong SQL and data profiling expertise
• Experience designing multi-model data architectures
• Experience in AWS and/or Azure environments
Preferred Experience
• Experience with Data Mesh or Lakehouse architectures
• Experience with i2b2 data models
• Experience with vector databases and AI/ML workloads
• Experience managing Total Cost of Ownership (TCO) in cloud environments
Educational Requirements
• Bachelor’s Degree in:
• Computer Science
• Systems Engineering
• Applied Mathematics
• Business Administration
• Economics/Statistics
• Telecommunications
• Data Communications
• Or related field
OR
• Equivalent combination of education, training, and progressive experience
Minimum five (5) years of progressive experience in data processing, computer systems, and applications required.
Core Competencies
• Enterprise Data Architecture
• Healthcare Data Standards & Interoperability
• Snowflake Engineering & Optimization
• Dimensional Modeling
• Cloud Data Platforms (AWS/Azure)
• AI/ML Data Enablement
• Data Governance & Quality Management
• Cross-Functional Collaboration
Apply Now
Apply Now