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.