PurpleLab · 12 hours ago
Senior Product Analyst, Methodology
PurpleLab is seeking a highly skilled and detail-oriented analyst to serve as a Senior Product Analyst on their Data Methodology team. This role involves analyzing large-scale healthcare claims datasets and collaborating with engineering, product, and clinical teams to translate complex requirements into technical specifications.
Computer Software
Responsibilities
Analyze large-scale healthcare claims datasets (primarily closed claims; experience with open claims and remittance data preferred) to support the development and validation of analytical methodologies
Design, implement, and optimize complex SQL queries to support methodology development and enhancements for new and existing products, data validation, and ad hoc analyses
Validate outputs to ensure accuracy, clinical relevance, and alignment with business and product requirements
Develop and maintain analytical rules, measures, and calculations related to utilization, cost, quality, and clinical outcomes
Partner with Product, Engineering, and Clinical teams to translate business and clinical requirements into technical specifications
Serve as a bridge between business users and technical teams by documenting methodology logic, assumptions, and data flows
Support product enhancements and new feature development by evaluating the feasibility and impact of methodology changes
Assist with troubleshooting data and methodology issues across upstream and downstream systems
Apply knowledge of healthcare claims processing, billing, and coding standards, including CPT / HCPCS, ICD-10 (CM and PCS), MS-DRG
Leverage experience with clinical groupers and advanced claims methodologies (e.g., risk adjustment, episode groupers, severity adjustment, benchmarking) to inform analytical design
Stay current on industry trends, coding changes, and regulatory updates that may impact methodologies
Qualification
Required
5–8 years of relevant professional experience in healthcare analytics, data analysis, or a related field
Advanced SQL proficiency (required), including experience with complex joins, CTEs, window functions, and performance optimization
Hands-on experience working with healthcare claims data
Strong understanding of healthcare coding and billing concepts, including CPT/HCPCS, ICD-10, and MS-DRG
Proven ability to analyze complex data, identify patterns, and translate findings into clear, actionable insights
Experience working cross-functionally with technical and non-technical stakeholders
Preferred
Experience with clinical groupers and advanced healthcare methodologies (e.g., episode-based analytics, risk adjustment models, severity stratification)
Familiarity with healthcare analytics products or platforms
Experience with data modeling, requirements documentation, and systems analysis
Exposure to modern data warehouses and analytics tools (e.g., BigQuery, DataBricks, etc.)
Background in healthcare economics, clinical analytics, or population health, or relevant field