Healthcare Data Analyst II (ICP)

Primary City/State: Innovation Care Partners - 8901 E Mountain View Rd Scottsdale, AZ 85258 Category: Quality Assurance Shift: Day Department: CAO Healthcare experience required Hybrid, must reside in Arizona Great care starts with great people. (Like you.) At HonorHealth, you'll find something special. From humble beginnings in 1927 to one of Arizona's largest nonprofit healthcare systems, our culture is built on warmth and neighborly kindness. Behind every smile is a highly skilled professional with deep expertise and an unwavering dedication to what matters most - caring for the health and well-being of people and communities across the greater Phoenix area. Responsibilities: JOB SUMMARY The IT Quality Assurance Analyst II (QAA2) role supports healthcare data initiatives focused on claims, eligibility, provider, member, and quality measure data. The analyst will partner with business users, data engineers, developers, and project teams to ensure data quality and accuracy across enterprise platforms supporting value-based care and population health programs. ESSENTIAL FUNCTIONS Perform data validation activities including source to target validation, data quality testing, reconciliation testing, file ingestion validation and production data verification. Advance excel skills required including Pivot tables, VLOOKUP/XLOOKUP, data reconciliation, filtering and data analysis. Demonstrates strong analytical and investigative skills with the ability to identify data discrepancies, challenge assumptions, perform root cause analysis, and communicate findings to technical and business stakeholders. Performs solution and software testing using scripts developed from technical and functional requirements. Develop scope-appropriate test plans. Develop and execute test scripts for all levels of functional and system/technical testing including unit, integration, system, sanity, smoke, interface, regression, performance, load, security, etc. Verify fulfillment of technical and workflow requirements. Identify defects and analyze failure/success of scripts. Identify opportunities for increased quality and efficiency in software solutions. Performs other duties as assigned EDUCATION Associates in Computer Science, Information Systems, or related field Required Bachelors in Computer Science, Information Systems, or related field Preferred EXPERIENCE 4 years, Quality Assurance, Data Validation, Data Quality, or Healthcare Data Analysis experience involving claims, eligibility, provider, member, reimbursement, or quality reporting data including the use of SQL for data validation, analysis, reconciliation, and testing. Required 2 years, Experience supporting ACO's, value-based care programs, managed care, Experience with Databricks, Snowflake, SQL Servier or similar data platforms Preferred 2 years, Experience using Power Query within Excel to transform, profile, cleanse, reconcile, and analyze datasets. Also experience in developing or utilizing Excel macros and VBA solutions. Preferred 6 years, Quality Assurance, Data Validation, Data Quality, or Healthcare Data Analysis experience Preferred LICENSE AND CERTIFICATIONS Certification(s) in relevant Information Technology processes such as: ITIL, ISO 9000, SQA, SQL Testing, Security, Six Sigma, and healthcare applications. Upon Hire Preferred We're all in for your career. #J-18808-Ljbffr 10 John C. Lincoln Medical Center