Lead Quality Assurance Analyst

Job Description

**Need local candidates only at Columbia, SC**

**Visa – H1B, TN, GC, USC**

**Title: Quality Assurance Analyst – Project Lead (10+YEARS)**

**Duration: 1+ year**

**Work Location: Hybrid. 3 days onsite and 2 days remote. First month fully onsite**

**. 1801 Main St, Columbia, SC 29201**

**COMPANY / DEPARTMENT CULTURE**

The South Carolina Department of Health & Human Services (SCDHHS) is the State Medicaid Agency for South Carolina.

The Quality Assurance Analyst – Project Lead will be assigned to projects for the South Carolina Department of Health and Human Services (SCDHHS), the Medicaid Agency for SC.

Candidates who enjoy working on complex, change-oriented projects will find this position attractive.

**Daily Duties / Responsibilities:**

Responsible for performing tests on technical solutions to isolate and solve issues. Initiates tests, 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.

**Required 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 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