Healthcare Data Analyst II (ICP)

HonorHealth is seeking an IT Quality Assurance Analyst II to support healthcare data initiatives tied to claims, eligibility, provider, member, and quality measure data. In this hybrid role based in Scottsdale, Arizona, you will collaborate with business users and technical teams to help ensure data quality and accuracy across enterprise platforms used for value-based care and population health programs.

What you’ll do

• Conduct data validation activities, including source-to-target validation, data quality testing, reconciliation testing, file ingestion validation, and production data verification.
• Apply advanced Excel skills such as Pivot tables, VLOOKUP/XLOOKUP, and reconciliation techniques to support filtering and data analysis.
• Use analytical and investigative methods to identify data discrepancies, challenge assumptions, perform root cause analysis, and communicate findings to technical and business stakeholders.
• Support solution and software testing by developing and using scripts based on technical and functional requirements.
• Create scope-appropriate test plans and develop and execute test scripts across unit, integration, system, sanity, smoke, interface, regression, performance, load, security, and other relevant testing types.
• Verify technical and workflow requirement fulfillment, identify defects, analyze script success and failures, and look for opportunities to improve quality and efficiency in software solutions.
• Perform other duties as assigned.

Minimum qualifications

• Associates in Computer Science, Information Systems, or a related field (Required).
• 4 years of experience in Quality Assurance, Data Validation, Data Quality, or Healthcare Data Analysis involving claims, eligibility, provider, member, reimbursement, or quality reporting data, including use of SQL for data validation, analysis, reconciliation, and testing (Required).

Preferred experience

• 2 years supporting ACO’s and value-based care programs or managed care; familiarity with Databricks, Snowflake, SQL Server, or similar data platforms.
• 2 years using Power Query within Excel to transform, profile, cleanse, reconcile, and analyze datasets, plus experience developing or utilizing Excel macros and VBA.
• 6 years in Quality Assurance, Data Validation, Data Quality, or Healthcare Data Analysis.

Tools and technologies

• Excel, Pivot tables, VLOOKUP, XLOOKUP
• SQL, Databricks, Snowflake, SQL Server
• Power Query, Excel macros, VBA

Education

• Associates in Computer Science, Information Systems, or related field (Required).
• Bachelors in Computer Science, Information Systems, or related field (Preferred).

Licenses and certifications

• Certification(s) in relevant IT processes such as ITIL, ISO 9000, SQA, SQL Testing, Security, Six Sigma, and healthcare applications. Upon hire (Preferred).