Quality Assurance Analyst II

Description Summary:  The QA Analyst is responsible for crafting and executing test plans, test cases, and test scripts, focusing on functionality, performance, SQL proficiency, REST API testing, and test case creation. The BI Team is tasked with critical internal business operations projects to improve internal efficiencies as well as development of business intelligence products for M3.

Essential Duties:

The duties listed below are the essential functions of this position, and they may change as the needs of the company demand. All associates are expected to do what is necessary to get the work done and to cooperate fully with their supervisor’s requests for additional or altered duties. 

• Test Planning: Develop and implement test plans, test cases, and test scripts to thoroughly evaluate the functionality and performance of our business intelligence and process automation solutions.
• SQL Proficiency: Utilize SQL to create and execute database queries for data validation and integration testing.
• REST API Testing: Conduct testing of RESTful APIs to ensure data retrieval, integration, and communication processes meet defined standards.
• Defect Identification: Identify, document, and track software defects and anomalies, working closely with the development team to resolve issues.
• Test Automation: Collaborate with the development team to automate test cases, enhancing efficiency and test coverage.
• Regression Testing: Perform regression testing to confirm that software updates and enhancements do not adversely affect existing functionality.
• Quality Assurance: Maintain and enforce quality assurance standards and best practices, ensuring that all deliverables meet or exceed quality requirements.
• Other duties as assigned. 

Basic Qualifications:

• Completion of a Bachelors Degree is required. Strong preference for the completion of a major in IT, MIS, or Computer Science , or an equivalent combination of education and experience.
• 1 - 3 years of and related experience.
• 1+ years working in an agile development using Scrum or Kanban.
• Must have experience and be proficient writing SQL to query databases on Microsoft SQL Server.
• Must have experience and be proficient at using tools such as Postman to test REST APIs.
• Must have knowledge of a variety of computer software applications in word processing, spreadsheets, database, and presentation software (MSWord, Excel, PowerPoint).
• Knowledge of software development lifecycles (SDLCs) and agile development methodologies.
• Proven data analysis, data verification, and problem-solving abilities.
• Strong interpersonal skills and extremely resourceful.
• Must have strong written and verbal skills in English and ability to communicate effectively.

Preferred Qualifications:

• Certified Scrum Master (CSM) certification.
• Experience using Azure DevOps Services, SSMS, SSIS, and VS Code.
• Proficient in Python and PowerShell.
• Experience Using Business Intelligence tools such as Sisense, Tableau, or Power BI.

 Physical Requirements:

• Ability to sit and/or stand for extended periods.
• Ability to perform work on a computer for extended periods.
• Ability to attend work per assigned schedule and attend meetings with excellent attendance and punctuality.
• Ability to bend and lift up to 25 lbs.