Job Description

Role Responsibilities

• Write advanced Redshift SQL queries including multi-CTE, temp-table, and window-function logic.
• Support measure logic builds and numerator/denominator analysis for quality programs.
• Develop scripts for data QA, record-level validation, and reconciliation between sources and outputs.
• Work with claims (institutional, professional, dental, pharmacy) and clinical data sources (lab, immunization, supplemental).
• Collaborate on QA, testing, and validation of outbound datasets.
• Understanding of HEDIS or payer quality measure logic

Required Skills/Experience

• Minimum of 5 years healthcare data analytics experience with understanding of claims, encounters, and quality measures
• Minimum of 5 years hands on experience with Amazon Redshift / PostgreSQL - SQL (DDL, DML, joins, window functions, temp tables), Git or version control tools and Excel.
• Bachelor's degree or equal experience

Preferences

• Strong attention to detail; disciplined approach to QA and data integrity
• Able to follow complex logic trees and trace end-to-end data flow
• Collaborative mindset and ability to work with both technical and business teams
• Excellent written documentation and communication skills
• Curious, proactive learner who can adapt existing code for new payers or measure types

Job Tags

Similar Jobs