Associate Quality Analyst - Backend

Overview The Associate Quality Analyst supports production system quality and integrity through backend database testing, automated test development, and production incident triage. Working within Agile/Scrum environments, this role focuses on healthcare claims processing (headers, state variations, custom logic), ETL validation, and Oracle/SQL Server database testing. The Associate Quality Analyst collaborates with development and operations teams to identify defects, execute test scenarios, and validate data integrity in backend systems. Responsibilities Create and execute SQL queries to validate backend system processing, data integrity, and business rule implementation. Support ETL testing activities by executing predefined test scenarios and comparing source and target data using established procedures. Perform database functionality testing activities to verify data accuracy following documented INSERT, UPDATE, and DELETE test procedures. Review assigned business and system requirements to understand testing objectives and expected results under guidance from experienced team members. Create, adapt, and execute test cases for backend system functionality following established QA standards and documented procedures. Develop and maintain automated test scripts using approved testing frameworks, reusable components, and established coding standards. Assist in maintaining and updating test documentation, test cases, and test execution records. Analyze application behavior, test results, and database output to identify software defects and processing inconsistencies. Compile quality metrics and assist with identifying trends and issues requiring additional review. Communicate testing progress, defects, and results to team members and immediate supervisors. Use documented SQL queries, system logs, and troubleshooting procedures to analyze and investigate assigned defects. Support production incident analysis by gathering information from system logs, database records, and applications under supervision. Execute and maintain backend validation tests for application enhancements, system modifications, and production releases. Provide feedback on testing processes and assist in identifying opportunities for process improvement. Primary Duty Statement: The primary duty of this position is technical systems analysis, backend application testing, database analysis, ETL validation, and automated test development for computer applications and information systems. The position applies specialized technical knowledge to analyze system functionality, evaluate data processing results, investigate software defects, develop and maintain automated testing solutions, and validate application performance and data integrity. Administrative, reporting, and documentation activities are performed solely in support of these technical responsibilities and are not the principal purpose of the position. Complete all responsibilities as outlined in the annual performance review and/or goal setting. Complete all special projects and other duties as assigned. Must be able to perform duties with or without reasonable accommodation. This job description is intended to describe the general nature and level of work being performed and is not to be construed as an exhaustive list of responsibilities, duties and skills required. This job description does not constitute an employment agreement and is subject to change as the needs of Cotiviti and requirements of the job change. Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field. 1-2 years of QA experience in software quality assurance and automated testing, along with functional, integration, and regression testing, in an Agile/Scrum development environment, preferably SAFe (internships, CPT (Curricular Practical Training) programs, contract roles, or equivalent hands‑on experience acceptable). Hands‑on experience with at least one automated testing framework (Selenium, TestComplete, or similar). Working knowledge of SQL for database querying and data validation (SELECT statements, WHERE clauses, JOINs, basic subqueries). Experience with Oracle or SQL Server database environments. Experience with ETL applications and backend data validation testing. Working knowledge of version control software such as GIT. Experience creating and executing test cases based on business requirements. Ability to identify, document, and report software defects with clear descriptions and reproduction steps. Good written and verbal communication skills. Familiarity with at least one issue tracking tool (Jira, Azure DevOps, or similar). Hands‑on experience with at least one AI tool (such as ChatGPT, GitHub Copilot, or similar generative AI platforms) for code generation, documentation, or technical learning. Ability to leverage AI‑assisted capabilities for test case optimization and automation improvements. Understanding of AI output validation and the importance of human review before implementation in production environments. Experience with DML operations (INSERT, UPDATE, DELETE validation) and data consistency verification. Working knowledge of software testing methodologies and backend application testing principles. Preferred: Experience with Agile/Scrum development methodologies and SAFe practices. Knowledge of Agile SDLC principles and terminology. ISTQB Foundation Level certification or equivalent formal QA training. US healthcare domain knowledge, particularly in claims processing, state variations, or prior authorization workflows. Experience with healthcare data privacy regulations (HIPAA) and compliance requirements. Experience with production support environments and incident response processes. Familiarity with healthcare data. Working knowledge of JavaScript, Java, or .NET fundamentals for understanding test automation code; ability to read and interpret basic automation scripts. Cognitive / Mental Requirements Communicating with others to exchange information. Assessing the accuracy, neatness and thoroughness of the work assigned. Physical Requirements and Working Conditions Remaining in a stationary position, often standing or sitting for prolonged periods. Repeating motions that may include the wrists, hands and/or fingers. No adverse environmental conditions expected. Must be able to provide a dedicated, secure work area. Must be able to provide high-speed internet access / connectivity and office setup and maintenance. Base compensation ranges from $55,000 to $75,000 per year. Specific offers are determined by various factors, such as experience, education, skills, certifications, and other business needs. medical dental vision disability life insurance coverage 401(k) savings plans paid family leave 9 paid holidays per year 17-27 days of Paid Time Off (PTO) per year, depending on specific level and length of service with Cotiviti For information about our benefits package, please refer to our Careers page. Since this job will be based remotely, all interviews will be conducted virtually. #J-18808-Ljbffr