Quality Assurance Analyst - Project Lead, Columbia, SC, US Quality Assurance Analyst - Project Lead 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. - 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: - 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 #J-18808-Ljbffr