Database Developer (SQL) - Project Lead

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