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 We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship / immigration status, veteran status, or any other status protected under federal, state, or local law.
Qa Analyst • Raleigh, NC, United States of America