Senior Database Developer (SQL) - Project Lead

Job Title: Senior Database Developer (SQL) - Project Lead
Job ID: 11508
Client: South Carolina Department of Public Health (DPH)
Duration: 12 Months (Project-based)
Work Location: 100% Remote (Nationwide candidates accepted; must work EST hours)
Interview Process: 1 Round Virtual
Work Hours: 40 hours/week. Standard weekday EST hours. (Must be available to work flexible hours, including weekends/off-hours, to support critical systems when necessary and pre-approved).

I. About the South Carolina Department of Public Health (DPH)
At the South Carolina Department of Public Health (DPH), we are committed to fostering healthy lives and communities. Our team of over 2,900 professionals operates across 70 offices statewide, united by a shared dedication to impactful work. As stewards of public health, we seek self-driven individuals who thrive in collaborative settings, capable of working autonomously while being responsive to priority tasks and building effective relationships.

II. Scope of Project & Daily Responsibilities
DPH is seeking a Senior Database Developer to support the technical needs of our STD / HIV staff, the Public Health Lab, and Disease Surveillance systems. Key projects include transitioning to a replacement Electronic Disease Surveillance System (EDSS), ongoing Data Warehousing, Data Pipeline improvement, and supporting new solutions for eCR (Electronic Case Reporting) onboarding and utilization.

Responsibilities include, but are not limited to:
* ETL & Process Automation: Research, design, develop, and test ETL processes, data flows, and automated data uploads into the Data Warehouse and Disease Surveillance Systems (e.g., CDC SAMS / eHARS, EpiTrax).
* Database Development: Create MS T-SQL stored procedures, design advanced queries, perform code reviews, and optimize database performance.
* Legacy Conversion: Rewrite existing SAS code into SSIS Packages and Power BI. Debug, optimize, and maintain remaining SAS code as needed.
* Data Parsing: Parse and format multiple data formats including XML, CSV, SOAP, and HL7.
* System Support & Monitoring: Monitor production processing to ensure proper data flow, resolve processing issues, and ensure maximum system uptime for critical components. Support related server, database, software upgrades, and new environment configurations.
* Requirements Gathering & Project Management: Work closely with end users, Systems Integration, Health Data Visualizations, and DBA teams to perform gap analysis, document functional requirements, provide time estimates, and prepare process documentation.
* Security & Compliance: Ensure all modifications and new processes comply with agency security requirements, industry best standards, HIPAA, CDC standards, PHI, and PII regulations.
* Advisement & Mentorship: Advise staff on code conversions, database design, and optimization. Mentor team members on advanced topics.

III. Required Skills
* 3+ Years: MS T-SQL (Stored Procedures, Advanced Queries, Optimization)
* 3+ Years: ETL Process Development
* 3+ Years: Data Warehousing & Relational Databases
* 3+ Years: MS SQL Server 2016+
* 3+ Years: Report Development
* 3+ Years: XML
* 1+ Year: SQL Server Integration Services (SSIS)
* 1+ Year: HL7 v 2.3.1 - 2.5.1 and ORU Messages
* 1+ Year: Security and data classification related to CDC, HIPAA, CJIS, PHI, PII

IV. Preferred Skills
* Ability to manage large data sets (1 TB+)
* Requirements Gathering & Documentation
* Public Health / Disease Surveillance Systems Experience
* Statistical Analysis System (SAS)
* LOINC / SNOMED
* FASTQ FILES AND DEMULTIPLEXING
* R & RStudio