Software Technology Inc. is seeking a Senior Population Health Data Engineer to design, develop, and maintain scalable data pipelines for population health and claims analytics. The role involves integrating clinical and claims data, developing data models, and ensuring data quality while collaborating with various teams to translate business needs into technical solutions.
Responsibilities:
- Design, develop, and maintain scalable data pipelines supporting population health, claims analytics, and reporting
- Work extensively with Epic data sources including Registries, Rosters, Chronicles, Clarity, and Caboodle
- Integrate clinical and claims data to support longitudinal patient views and advanced analytics
- Develop data models for population health use cases including quality measures, risk stratification, utilization, and care management analysis
- Support development and operationalization of risk scoring data models and analytics (e.g., MARA, HCC, RAF)
- Process and transform healthcare claims data (medical and pharmacy) for analytics and reporting
- Work with Milliman MedInsight data structures to support payer-provider analytics and efficiency benchmarking
- Build and optimize ELT pipelines using modern cloud platforms
- Collaborate with healthy planet, efficiency, quality, clinical, and analytics teams to translate business needs into technical solutions
- Ensure data quality, governance, and compliance with healthcare regulations (e.g., HIPAA)
- Optimize performance of large-scale datasets and queries
Requirements:
- Strong hands-on experience with Epic systems, including: Epic Registries, Chronicles data structures, Hyperspace or Hyperdrive environments, Clarity and Caboodle data models
- Experience with modern data engineering tools and platforms: Snowflake (data warehousing), DBT (data transformation and modeling), Dynamic Tables in Snowflake
- Solid understanding of healthcare domain concepts, including population health and value-based care
- Experience with healthcare claims processing (medical and pharmacy claims)
- Hands-on experience with Milliman MedInsight data models and analytics workflows
- Strong SQL and data modeling expertise
- Experience building and maintaining data pipelines