Population Health Data Engineer
Applied Epic
Claims Data Pipelines
Clinical Data
Cloud Platform
Cloud Platforms
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Management
Data Modeling
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
EHR
Electronic Medical Records
Epic Systems
ETL
Milliman Medinsight
Population Health
SQL
Job Description
Software Technology Inc is seeking two Population Health Data Engineers with deep Epic data ecosystem expertise for a hybrid role based in Charlestown, MA, with remote options, focusing on scalable data pipelines, clinical and claims data integration, and population health analytics initiatives.
Responsibilities
- Architect and maintain scalable data pipelines for population health programs and claims analytics.
- Leverage Epic data platforms such as Clarity, Caboodle, Chronicles, Registries and Rosters in daily work.
- Integrate clinical and claims data to enable longitudinal, patient-level analytics.
- Design and optimize data models supporting quality measures.
- Design and optimize data models for risk stratification.
- Design and optimize data models for utilization and cost analytics.
- Support care management initiatives through data solutions.
- Develop and maintain risk adjustment models including HCC, RAF, and MARA.
- Ingest, transform, and validate medical and pharmacy claims data.
- Work with Milliman MedInsight data models for payer-provider analytics and benchmarking.
- Build and optimize ELT processes on modern cloud platforms.
- Collaborate with Healthy Planet, clinical, quality, and analytics teams to deliver data-driven solutions.
- Ensure data quality, governance, and HIPAA compliance across pipelines and models.
- Tune performance for large datasets and complex SQL queries.
Requirements
- Strong hands-on experience with Epic Clarity and Caboodle
- Experience with Chronicles data structures
- Experience with Epic Registries / Healthy Planet
- Background in Population Health and Value-Based Care
- Proficiency in Risk Adjustment (HCC, RAF, MARA)
- Snowflake data warehousing and related features
- DBT (Data Build Tool) expertise
- Dynamic Tables (Snowflake) experience
- Advanced SQL and data modeling capabilities
- Experience building and maintaining data pipelines
- Experience with medical and pharmacy claims data
- Experience with payer-provider analytics
- Milliman MedInsight experience (preferred)
- Bachelor's or Master's degree in Computer Science, Health Informatics, Data Engineering or related field
- 6+ years of data engineering experience
- Healthcare domain experience, specifically Population Health analytics and payer environments (preferred)
Technologies
- Epic Clarity
- Epic Caboodle
- Chronicles
- Epic Registries / Healthy Planet
- Snowflake
- DBT (Data Build Tool)
- Dynamic Tables (Snowflake)
- Milliman MedInsight
- SQL