Data Warehouse / ETL Developer

Project Support Requirements

• Selected personnel must sign the DPH Confidentiality Agreement and/or Business Associate (BA) Agreement, if applicable.
• All web services must be secure.
• DPH will not accept offers that include an "up-lift " charge.
• Consultant rates must not exceed the maximum rate established under State contract terms.
• Follow Agency IT standards, policies, procedures, and documentation requirements.
• All source code (compiled and uncompiled) developed under this contract becomes the sole property of the South Carolina Department of Public Health (DPH).
• Any source code, data, product, or functionality resulting from this SOW or previously owned/developed by DPH remains the sole property of DPH.
• Contractor-developed modifications and interfaces:
  • Cannot be incorporated into any vendor core product.
  • Cannot be reused for independent projects.
  • Cannot be published or publicized without written approval from DPH.
• DPH retains final approval authority over all programming choices.

Payment Schedule

• The State will not reimburse additional contractor expenses, including:
  • Travel
  • Employee benefits
  • Insurance
  • Room and board
  • Other incidental expenses

DPH Support Provided

• Required business information, formulas, data, and validation mechanisms.
• Staff support for application and data-related questions.
• Conference rooms and scheduling assistance for application demonstrations.
• Virtual workstation with required software.

Required Skills (Ranked by Importance)

Database & SQL Development

• 3+ years of experience with:
  • MS T-SQL
  • Stored Procedures
  • Advanced Queries
  • Query Optimization
• 3+ years of experience with:
  • MS SQL Server 2016+

ETL & Data Integration

• 3+ years of experience with:
  • ETL Process Development
• 1+ year of experience with:
  • SQL Server Integration Services (SSIS)

Reporting & Data Warehousing

• 3+ years of experience with:
  • Report Development
• 3+ years of experience with:
  • Data Warehousing
  • Relational Databases

Healthcare Data & Messaging

• 1+ year of experience with:
  • HL7 versions 2.3.1 2.5.1
  • ORU Messages

Data Formats

• 3+ years of experience with:
  • XML

Security & Compliance

• 1+ year of experience with:
  • CDC data standards
  • HIPAA compliance
  • CJIS requirements
  • PHI (Protected Health Information)
  • PII (Personally Identifiable Information)
  • Data classification and security controls

Preferred Skills (Ranked by Importance)

• Ability to manage large data sets (1 TB+).
• Requirements gathering and documentation experience.
• Public Health and Disease Surveillance Systems experience.
• Statistical Analysis System (SAS).
• Knowledge of:
  • LOINC
  • SNOMED
• Experience with:
  • FASTQ files
  • Demultiplexing
• Experience with:
  • R
  • RStudio

Environment & Tools

Database Technologies

• Microsoft SQL Server (2016+)
• T-SQL
• SQL Server Management Studio (SSMS)

ETL & Data Pipelines

• SQL Server Integration Services (SSIS)
• ETL Development
• Data Pipeline Development

Reporting & Analytics

• Data Warehousing Platforms
• Reporting Tools:
  • Power BI (or similar)

Healthcare Data Standards

• HL7 v2.x (including ORU messages)
• XML
• CSV
• Other structured data formats

Public Health Systems

• Electronic Disease Surveillance Systems (EDSS)
• Electronic HIV/AIDS Reporting System (eHARS)
• CDC Reporting Systems
• Electronic Case Reporting (eCR)
• Data Exchange Integrations

Data Transformation & Analytics

• SAS (Legacy Processes)
• Data Transformation Scripting

Security & Compliance

• HIPAA Compliance
• PHI/PII Data Protection
• CDC Data Standards
• Security Compliance Requirements

Additional Skills (Ranked by Importance)

Communication & Stakeholder Management

• Ability to work effectively with:
  • Technical peers
  • Technical management
  • Business users
  • User management
  • Vendors
  • Staff members
• Ability to communicate clearly and effectively in:
  • Written form
  • Verbal form

Data Management Expertise

• Strong background in:
  • Data integration
  • Data staging
  • Data quality management
  • Data distribution

Interpersonal Skills

• Excellent:
  • Written communication skills