Senior Database Developer (SQL) – Project Lead

Title: Senior Database Developer (SQL) – Project Lead (11508)Location: Cayce, SC (100% Remote – Nationwide Candidates Accepted)Duration: 12 MonthsInterview Process: One Round Virtual InterviewRequired Skills3+ years of experience with MS T-SQL (Stored Procedures, Advanced Queries, Query Optimization)3+ years of experience developing ETL processes and data pipelines1+ year of experience with SQL Server Integration Services (SSIS)3+ years of experience with report development and reporting solutions3+ years of experience with Data Warehousing and Relational Databases1+ year of experience working with HL7 v2.3.1 – v2.5.1 and ORU Messages3+ years of experience processing and parsing XML data3+ years of experience with Microsoft SQL Server 2016+1+ year of experience with CDC, HIPAA, CJIS, PHI, and PII security/data classification requirementsPreferred SkillsExperience managing large data sets (1TB+)Requirements Gathering and DocumentationPublic Health / Disease Surveillance Systems experienceStatistical Analysis System (SAS)LOINC and SNOMEDFASTQ Files and DemultiplexingR and RStudioCDC Reporting SystemsElectronic Case Reporting (eCR)ResponsibilitiesDesign, develop, and maintain ETL processes, data pipelines, and automation solutionsCreate, optimize, and troubleshoot complex T-SQL stored procedures, functions, and advanced queriesDevelop and support SSIS packages and integration solutionsParticipate in EDSS migration and data modernization initiativesDesign and maintain Data Warehouse solutionsDevelop reports, dashboards, and reporting processesParse and process healthcare data formats including XML, HL7, CSV, and SOAP messagesSupport eCR onboarding, data imports, process automation, troubleshooting, and reportingMonitor production data processing and ensure successful data flowPerform data validation, testing, deployment, and post-production supportRewrite and convert legacy SAS processes into SSIS and Power BI solutionsSupport system upgrades, database migrations, and environment configurationsCreate technical documentation, process flows, and data mapping documentsGather business requirements and perform gap analysis with stakeholdersEnsure compliance with DPH, CDC, HIPAA, CJIS, PHI, and PII security requirementsProvide technical guidance, code reviews, and best practices to team membersEnvironmentMicrosoft SQL Server 2016+T-SQLSQL Server Management Studio (SSMS)SQL Server Integration Services (SSIS)Power BIETL/Data Pipeline DevelopmentHL7 v2.x (ORU Messages)XML, CSV, SOAPData WarehousingCDC Reporting SystemsElectronic Disease Surveillance Systems (EDSS)eHARSEpiTraxSASHealthcare/Public Health Data Systems