Quality Assurance Analyst – Project Lead - SOSC

Job Title: Quality Assurance Analyst – Project Lead
Location: Columbia, SC
Duration: 12 Months
Pay Rate: $55 – $60/hour

Candidate must be a CURRENT South Carolina resident. No relocation allowed.

Job Description:

Seeking an experienced Quality Assurance Analyst – Project Lead to perform testing and validation of technical solutions within a data-driven environment. This role focuses on developing automated test scripts, validating data pipelines, and working closely with engineering teams to ensure data accuracy, scalability, and performance.

Daily Responsibilities:

• Develop comprehensive test strategies and detailed test cases for data pipeline and transformation validation.
• Create automated ETL test scripts using Python and Pytest frameworks.
• Write advanced SQL queries to support data profiling, validation, and debugging across platforms like SQL Server and Oracle.
• Automate ETL validation processes, streamlining testing workflows.
• Conduct Web UI automation using Selenium for front-end validation.
• Implement REST API test automation for validating microservices and ingestion endpoints.
• Collaborate with data engineers, analysts, and business teams to understand requirements and data flows.
• Perform regression testing for ETL jobs during maintenance and enhancement cycles.
• Build reusable, scalable Python-based test frameworks for ETL testing.
• Integrate test automation within CI/CD pipelines.
• Validate performance benchmarks to ensure ETL processes handle growing data volumes.
• Document test results, log defects, and effectively communicate findings.
• Work with orchestration platforms like Apache Airflow or Prefect (preferred).
• Utilize Git for version control and JIRA or Azure DevOps for test and defect management.

Required Skills:

• 3+ years of experience translating business requirements into test cases and scenarios.
• 3+ years of hands-on experience building test cases and incorporating them into test systems.
• 5+ years automating ETL validation processes using Python and Pytest.
• 5+ years developing automated test scripts for ETL processes using Python.
• 3+ years advanced SQL experience across SQL Server, Oracle, or similar platforms.
• 1+ year conducting Web UI automation using Selenium.

Preferred Skills:

• Experience integrating automated testing within CI/CD pipelines.
• 5+ years working with large enterprise or e-business systems.
• Background in healthcare operations, ideally Medicaid.
• Proficiency with Atlassian tools, including JIRA and Confluence.
• Familiarity with both waterfall and agile SDLC methodologies.