Data Architect - Pop Health

We are seeking a hands-on, certified expert Data Architect with deep specialization in population health data and value-based performance management (VBPM), particularly within the EPIC ecosystem. The ideal candidate will have a strong background in data architecture, healthcare data modeling, and reporting, with a keen understanding of patient care, engagement, care coordination, and value-based care and risk-sharing

models.

Key Responsibilities :

• Lead the architectural design and integration of population health and EPIC Caboodle data models.
• Develop, optimize, and maintain scalable data models and ETL pipelines supporting population health and value-based care initiatives.
• Translate healthcare and clinical requirements into actionable data architecture strategies.
• Collaborate with clinical, analytics, and IT teams to support initiatives in care coordination, HEDIS, SDoH, and risk management.
• Drive the reporting framework using Power BI, Power Query, DAX, and Power Pivot.
• Manage and maintain SQL Server environments and develop SSIS packages for complex data

processing tasks.

• Ensure data quality through cleansing processes and enforce data governance principles.
• Support conversion efforts and go-live activities through data validation, migration, and integration strategies.

Required Skills & Experience :

• Certification in EPIC with experience in Caboodle Received Claims data model.
• Deep understanding of healthcare delivery models including Value-Based Care, Risk Sharing, Care Coordination, Patient Engagement, and HEDIS metrics.
• Strong experience with EMR and claims data, ICD / healthcare coding, social determinants of health (SDoH), and public health databases.
• Experience or familiarity with Arcadia Analytics Platform for population health reporting.
• Experience with EPIC EMR reporting, particularly using Power BI.

Expertise in :

• Data modeling and architecture
• SQL database management and query optimization
• ETL tools such as SSIS, Matillion, etc.
• Data visualization and transformation tools including Power BI, Power Query, Power Pivot, and DAX.
• Strong understanding of data governance principles and efficient data model design.