Overview
Skills
Job Details
Job Title: Quality Assurance Analyst Project Lead
Location: Columbia, SC
Duration: 12 Months
Job Summary:
A government agency is seeking a Quality Assurance Analyst Project Lead to lead and perform hands-on QA testing activities related to data pipelines, ETL processes, APIs, and web interfaces. This role is responsible for developing automated test scripts, validating complex data transformations, and ensuring high-quality, scalable data solutions.
The ideal candidate will bring strong technical testing experience with a focus on Python automation, SQL validation, and collaborative testing practices in Agile or Waterfall environments.
Daily Duties / Responsibilities:
Design and implement test strategies for data pipelines and transformations.
Create automated test scripts for ETL validation using Python and Pytest.
Write advanced SQL queries for data profiling, validation, and debugging across SQL Server, Oracle, and other platforms.
Automate ETL validation and regression testing processes.
Perform Web UI automation using Selenium to validate data-driven applications.
Implement REST API test automation for microservices and ingestion endpoints.
Collaborate with data engineers, analysts, and business stakeholders to understand data flows and requirements.
Build reusable, Python-based automation frameworks for ETL testing.
Integrate automation frameworks with CI/CD pipelines.
Validate performance benchmarks and scalability of ETL jobs.
Document test results and defects; report and communicate findings clearly.
Utilize tools such as Apache Airflow, Prefect, or similar orchestration platforms (preferred).
Use Git for version control and JIRA or Azure DevOps for test case and defect management.
Required Skills:
3+ years experience translating business requirements into test cases/scenarios.
3+ years building test scenarios within test systems.
5+ years automating ETL validation using Python and Pytest.
5+ years experience creating automated test scripts for ETL processes.
3+ years writing advanced SQL queries for data profiling and debugging.
1+ year of Web UI automation using Selenium for front-end validation.
Preferred Skills:
Experience integrating test automation into CI/CD pipelines.
5+ years experience with large enterprise or e-business systems.
Background in healthcare operations, preferably Medicaid.
Proficient in Atlassian tools including JIRA and Confluence.
Experience working in both Agile and Waterfall SDLC environments.