Quality Assurance Analyst - Project Lead

Date Posted: 07/17/2025

Hiring Organization: Rose International

Position Number: 485639

Industry: Government/Staffing

Job Title: Quality Assurance Analyst - Project Lead

Job Location: Columbia, SC, USA, 29201

Work Model: Hybrid

Work Model Details: Hybrid (3 days onsite, 2 days remote)

Shift: Regular

Employment Type: Temporary

FT/PT: Full-Time

Estimated Duration (In months): 13

Min Hourly Rate : 62.00

Max Hourly Rate : 65.00

Must Have Skills/Attributes: Oracle, SQL Server, Validation

Experience Desired: Integrate test automation into CI/CD pipelines (2 yrs); Large enterprise or e-business systems experience (5 yrs); Background in healthcare operations (preferably Medicaid) and business pr (2 yrs); Proficient in Atlassian tool suite including JIRA and Confluence (2 yrs); Prior experience working in a standard SDLC (waterfall methodology) & in (2 yrs)

Required Minimum Education: Bachelor's Degree

Job Description

REQUIRED EDUCATION:

• Bachelor's Degree

REQUIRED EXPERIENCE/ SKILLS:

• 3+ years translating business requirements or policy documentation into test cases and scenarios

• 3+ years building test cases and scenarios into test systems

• 5+ years Automating ETL validation processes using Python and Pytest frameworks

• 5+ years Creating automated test scripts using Python for ETL processes

• 3+ years Writing advanced SQL queries for data profiling, validation, and debugging across various platforms (e.g., SQL Server, Oracle)

• 1+ year Conducting Web UI automation using Selenium for front-end validation of data-driven applications

PREFERRED EXPERIENCE/SKILLS:

• Integrate test automation into CI/CD pipelines

• 5+ years large enterprise or e-business systems experience

• Background in healthcare operations (preferably Medicaid) and business processes

• Proficient in Atlassian tool suite including JIRA and Confluence

• Prior experience working in a standard SDLC (waterfall methodology) & in an Agile delivery

SCOPE OF THE PROJECT:

The Quality Assurance Analyst - Project Lead will be assigned to projects for the Medicaid Agency for Candidates who enjoy working on complex, change-oriented projects will find this position attractive.

DAILY DUTIES / ESSENTIAL RESPONSIBILITIES:

• Responsible for performing tests on technical solutions to isolate and solve issues. Initiates test, analyzes results, and finds solutions to technical problems

• Develop test strategies and detailed test cases to validate data pipelines and transformations

• Create automated test scripts using Python for ETL processes

• Write advanced SQL queries for data profiling, validation, and debugging across various platforms (e.g., SQL Server, Oracle)

• Automate ETL validation processes using Python and Pytest frameworks

• Conduct Web UI automation using Selenium for front-end validation of data-driven applications

• Implement REST API test automation to validate microservices and data ingestion endpoints

• Work closely with data engineers, analysts, and business users to clarify requirements and understand data flows

• Perform regression testing of ETL jobs during enhancements or maintenance cycles

• Build reusable Python-based test frameworks to automate ETL testing

• Integrate test automation into CI/CD pipelines

• Validate performance benchmarks and ensure ETL jobs scale with data volume

• Document test results, defects, and communicate findings effectively

• Work with tools such as Apache Airflow, Prefect, or similar orchestration platforms (a plus)

• Use Git for source control and tools like JIRA or Azure DevOps for test case and defect Management

Only those lawfully authorized to work in the designated country associated with the position will be considered.

Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.

Benefits:

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Permanent