Data Architect - Pop Health

• • PLEASE NOTE - Only W2 Applicants who are U.S. Citizen or Green Card Holder can be considered for this position. No C2C. This is a contract assignment. No third party referrals will be considered • • 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.