"Alerted.org

Data Profiling SQL Server Analyst

(Jobs in Columbia, SC)

Requirement id 154337

Job title Analyst

Job location in Columbia, SC

Skills required Test Scenarios, Python Scripting, ETL Process, Data Profiling SQL Server

Open Date 17-Jul-2025

Close Date

Job type Contract

Duration 12 Months

Compensation DOE

Status requirement ---

Job interview type ---

Email Recruiter:coolsoft

Job Description Analyst: Test Scenarios, Python Scripting, ETL Process, Data Profiling SQL Server

Start Date :8/26/2025

End Date :12 Months from projected start date

Submission Deadline :7/24 at 5:00 PM EST.

Client Info : SCDHHS

Note:

* Interview Process: 1 round - virtual

* Duration of the Contract: 12 months

* Possibility for Extension: Yes

* Work Location: Hybrid (3 days onsite, 2 days remote), First month will be fully onsite for training & Candidate must be a CURRENT SC resident. No relocation allowed.

Description :

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

Call502-379-4456 Ext 100for more details. Please provide Requirement id: 154337 while calling.

Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets