QA Data Analyst

• 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

• 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 / Postgre
  
  SQL - SQL (DDL, DML, joins, window functions, temp tables), Git or version control tools and Excel.
• Bachelor's degree or equal experience

• 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

AI TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. AI TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters.

Nor will AI TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract