Data Warehouse QA Tester

Title: Data Warehouse QA TesterDuration: 12 monthsLocation: 1 ENTERPRISE DRIVE, Quincy, MAWork Hours: 37.5 hrs/weekPosition: HybridJob Overview The Massachusetts Executive O ce of Health and Human Services (EOHHS) is seeking to hire a motivated IT Senior Quality Assurance Analyst to join its Medicaid Systems Development (MSD) team supporting MassHealth Applications. MassHealth (MH) is the EOHHS o ce that administers the Medicaid program and the Children’s Health Insurance Program (CHIP) in Massachusetts. MassHealth applications provide critical support for access to health care for some of Massachusetts’most vulnerable individuals. The Sr. Quality Assurance Analyst’s primary role is to support MH & Medicaid in developing systems. You will assist in managing the testing activities for systems;in addition, you will also support other MSD applications. You will conduct requirement analysis, design, and develop test cases and execute them using both manual and automated methods. You will capture defects in the tracking system and develop day-to-day test metric reporting. You will also provide backup support for the test manager. This position is anticipated to be a long-term engagement and is currently a hybrid remote position with the candidate able to come into the Quincy, MA office when requested.Job Duties: (Detailed list of Responsibilities):

• As directed, provide oversight of day-over-day testing activity and support.
• Participate in weekly meetings with the team as required.
• Participate in the defect triage meetings, providing information about defects and root cause analysis.
• Participate in defect remediation meetings to work on extended pending and warranty defects.
• Participate in Joint Application Design (JAD) sessions involving cross-functional teams.
• Develop and execute test cases and test scripts for end-to-end system testing.
• Create and deliver test plans and test cases - create effective and reusable test scripts based on functional requirements and use cases.
• Provide oversight, coordinate, and prepare test plans and scenarios within and outside the scope.
• Performing requirements verification testing, functional testing, security testing, regression testing, positive and negative testing, and ADA testing.
• Analyze test results and make confident decisions and recommendations.
• Efficiently execute system and user acceptance testing, document all testing results, and ensure that defects are recorded and tracked.
• Document all testing results and ensure defects are recorded and tracked.
• Work with the QA technical team during data setup for performance testing.
• Perform a critical test results analysis, make confident decisions and recommendations, and adhere to escalation processes to ensure accountability and issue resolution.
• Participate in scope review sessions with the business analyst (BA) and subject-matter expert (SME) teams.
• Work with SQA Manager and across project teams to ensure testing completion meets project deadlines.
• Work closely with the testing team and resolve testing-related issues/concerns.
• Do the Gap analysis create new possible test scenarios and add them to the testbed
• Develop test automation scripts and provide technical support.
• Develop and maintain testing issue documentation and adhere to escalation processes to ensure accountability and issue resolution.
• Technical skills in Oracle or SQL Server Development suites
• IBM Test Manager, HP Load Runner, HP QTP, Jira, MS Office software.
• Develop and distribute Test Summary Reports after each cycle.

REQUIRED SKILLS (Special Skill Set, Abilities, Knowledge:

• Broad knowledge of testing approaches and techniques for certifying software acceptance.
• Demonstrated ability to work independently and in project teams, providing relevant quality assurance services to a broad audience.
• Highly analytical and able to independently analyze test results and confidently make decisions and recommendations.
• Develop and Execute Automated Tests: Design, write, and maintain automated test scripts using various testing tools and frameworks. 
• CI/CD Integration: Integrated automated tests into CI/CD pipelines (e.G., GitActions, Jenkins).
• Expertise in backend testing and writing SQL queries, including complex subqueries and joins.
• Experience working with Oracle database.
• Experience in Jira or similar products.
• Experience working with HP Quality Center, IBM Clear Quest, IBM Test Manager, and MS Office software.
• Experience in reviewing the work of business analysts and subject matter experts, ensuring well-defined requirements contribute to defined functional use cases.
• Experienced in reviewing the work of business analysts to ensure well-defined requirements that contribute to defined functional use cases.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong verbal, written, and presentation skills.
• Preferred to have Salesforce testing experience.

QUALIFICATIONS (Education, Years’Experience, Certificates):

• Bachelor’s degree or higher in Computer Science or University degree or equivalent experience.
• Five years of experience in black-box, white-box, functional, smoke, and regression testing.

Prior experience in healthcare or government setting desired.