Quality Assurance Analyst - Project Lead - SOSC

Job Title: Quality Assurance Analyst - Project Lead Location: Columbia, SC Duration: 12 Months Pay Rate: $55 - $60/hourCandidate 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.