Description

DAILY DUTIES / RESPONSIBILITIES:
The candidate will work closely with members of the Public Health Data Visualizations, Systems Integration, and Database Administration teams as well as STD / HIV program staff and the Data Modernization Office. The candidate should be self-motivated and team-oriented, work under limited supervision, and respond to priority tasks. The candidate must be able to independently research and design processes, create specifications and data flows, develop ETL processes, make stored procedures, advanced queries, reports, and dashboards, assist with validations, actively engage with the Team and stakeholders, attend meetings, provide guidance, and respond promptly.
Participate in a team comprised of DHEC and solution implementation staff for Data Warehousing and Visualization planning, design, configuration, process development, SSIS and script coding, automation of data flows, and transition of functionality into the agency’s M. S. SQL Server (2016+) Data Warehouse and M. S. Power B. I. Platform. Will coordinate with the assigned IT Section Manager and Team Lead on daily assignments/tasks. Will coordinate and collaborate with contract and vendor staff, existing DHEC staff, and other I. T. professionals working with the Office of Information Technology. Ensure assignments are completed accurately and on time, assist with problem resolution, mitigate issues, provide solutions, communicate, and escalate as needed to management, and report progress to the manager.
Will advise staff on code conversions, database and query design, optimization, process improvements and automation, validations, reporting, and dashboard creation. Work with vendors and staff on deliverables, debugging, and converting of current processes to SSIS and PowerBI. This includes rewriting existing SAS solutions to conform to best practices and updated coding standards and improving efficiency, performance, and maintenance.
Specific duties and responsibilities will include but are not limited to the following:

• Prepare and maintain process documentation, data flows, and diagrams for assigned processes (new and existing).
• Work with end users to perform gap analysis, gather and document functional requirements, and create necessary processes
• Assist with project and time management including estimates and status reporting
• Ability to plan, organize, review, and implement associated project milestones to completion.
• Process Development, Process Automation, and ETL Solutions
• SQL stored procedure creation, advanced query design, debugging, and optimization (MS T-SQL)
• Rewriting of SAS code into SSIS Packages and Power B.I.; SSIS Debugging, Rewriting and optimization of remaining SAS code and queries as needed.
• Report and Dashboard Development
• Help format and automate data uploads into the Data Warehouse and Disease Surveillance Systems like CDC SAMS / EHARS and Conduent Maven
• Parsing of multiple data formats including HL7, XML, and CSV
• Monitor production processing to ensure proper data flow and response times
• Help to perform and automate daily maintenance processes
• Debug, troubleshoot, and optimize new and existing processes.
• Resolve processing issues.
• Support related server, database, software upgrades, and new environment configuration
• Ensure maximum system uptime for critical components to ensure business continuity.
• Assist with data and database migrations and related changes, testing, and validation
• Advise the Team on best practice and techniques. Mentor team and staff on advanced topics.
• Modification / rewrite of existing processes and creation of new processes to be compliant with agency security requirements and following industry best standards
SCDHEC will utilize this position for 40 hours per week for the project’s duration. The selected candidate may be able to work flexible hours during the week to provide weekend coverage. Total weekly hours (to include the weekend) should not exceed 40 unless approved in advance (i.e., hours worked on Saturday and Sunday would be deducted from hours worked Mon-Fri). This position may need to be available to support critical systems during business hours, off hours, and weekends.
The candidate will work closely with the Data Visualizations Section Manager and Project Manager to identify, prioritize, and schedule workload and implementation to I. T. standards and procedures. The candidate will also work closely with customers and subject matter experts on process design, migration to the platforms, and testing.

This will also include compliance with DHEC security policy/procedures and integrating systems when possible to streamline staff workflows, user security, data analytics, and reporting.

Module support of the project.

• DHEC will require that selected personnel sign the DHEC confidentiality agreement and/or Business Associate (BA) agreement if applicable. All web services must be secure.
• DHEC will not accept any offers including an “up-lift” charge. The rate paid per consultant must not exceed the maximum rate established for this position described in the State contract terms.
• Follow agency IT Standards, policies, and procedures to include documentation.
• All source code (compiled and un-compiled) will become the sole property of the South Carolina Department of Health and Environmental Control. Any source code, data, product, or functionality resulting from this SOW or previously owned/developed by DHEC will remain the sole property of DHEC and is not to be incorporated into the core product of any vendor's application. Any modifications and interfaces developed under said contract will not be used by the contractor for any independent project of the contractor or published or publicized by the contractor without written permission of DHEC.
• DHEC has the final say on all programming choices.
Payment Schedule:
All timesheets shall be entered and approved in a timely manner per State contract terms. The State will not pay any extra costs (i.e. Travel, employee benefits, insurance, room and board, etc.) for temporary employees under this contract.
DHEC Support:
DHEC will provide:
• All required information including formulas, data, and mechanisms to check output.
• Staff to assist with any application or data questions.
• Conference rooms and scheduling for any application demos.
• A virtual workstation with required software.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
1. MS T-SQL (STORED PROCEDURES, ADVANCED QUERIES, OPTIMIZATION)
2. ETL PROCESS DEVELOPMENT
3. SQL SERVER INTEGRATION SERVICES (SSIS)
4. POWER BI, REPORT, & DASHBOARD DEVELOPMENT
5. DATA WAREHOUSING & RELATIONAL DATABASES
6. HL7 (V 2.3.1 - 2.5.1; ORU MESSAGES)
7. XML
8. MS SQL SERVER 2016+
9. EXPERIENCE WITH SECURITY AND DATA CLASSIFICATION RELATED TO CDC, HIPAA, CJIS, PHI, PII
10. ABILITY TO DEAL EFFECTIVELY WITH THE NEEDS OF TECHNICAL PEERS, TECHNICAL AND USER MANAGEMENT, USERS, VENDORS, AND STAFF MEMBERS, AND TO COMMUNICATE CLEARLY AND EFFECTIVELY IN SPOKEN AND WRITTEN FORM

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
1. SOLID BACKGROUND IN DATA INTEGRATION, STAGING, QUALITY AND DISTRIBUTION
2. ABILITY TO MANAGE LARGE DATA SETS (1 TB+)
3. REQUIREMENTS GATHERING & DOCUMENTATION
4. PUBLIC HEALTH / DISEASE SURVEILLANCE SYSTEMS
5. SAS
6. LOINC / SNOMED
7. PYTHON
8. R & RSTUDIO
9. EXCELLENT WRITTEN, ORAL, AND INTERPERSONAL COMMUNICATION SKILLS

REQUIRED EDUCATION: Bachelor's or Master's Degree in a relevant field of work or equivalent work experience.
Additional Sills: REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):1. MS T-SQL (STORED PROCEDURES, ADVANCED QUERIES, OPTIMIZATION)2. ETL PROCESS DEVELOPMENT3. SQL SERVER INTEGRATION SERVICES (SSIS)4. POWER BI, REPORT, & DASHBOARD DEVELOPMENT5. DATA WAREHOUSING & RELATIONAL DATABASES6. HL7 (V 2.3.1 - 2.5.1; ORU MESSAGES)7. XML8. MS SQL SERVER 2016+9. EXPERIENCE WITH SECURITY AND DATA CLASSIFICATION RELATED TO CDC, HIPAA, CJIS, PHI, PII10. ABILITY TO DEAL EFFECTIVELY WITH THE NEEDS OF TECHNICAL PEERS, TECHNICAL AND USER MANAGEMENT, USERS, VENDORS, AND STAFF MEMBERS, AND TO COMMUNICATE CLEARLY AND EFFECTIVELY IN SPOKEN AND WRITTEN FORMPREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):1. SOLID BACKGROUND IN DATA INTEGRATION, STAGING, QUALITY AND DISTRIBUTION2. ABILITY TO MANAGE LARGE DATA SETS (1 TB+)3. REQUIREMENTS GATHERING & DOCUMENTATION4. PUBLIC HEALTH / DISEASE SURVEILLANCE SYSTEMS5. SAS6. LOINC / SNOMED7. PYTHON8. R & RSTUDIO9. EXCELLENT WRITTEN, ORAL, AND INTERPERSONAL COMMUNICATION SKILLSREQUIRED EDUCATION: Bachelor's or Master's Degree in a relevant field of work or equivalent work experience.

Skills:
CategoryNameRequiredImportanceLevelLast UsedExperience
Database PlatformsMS SQL SERVER 2019Yes7    
Database PlatformsPHI/PII dataYes8    
Database PlatformsRelational Database ExperienceYes5    
Database PlatformsReport and Dashboard developmentYes4    
Database PlatformsSQL Server Integration Services (SSIS)Yes3    
Database PlatformsSQL TuningYes1    
Development ToolsPower BIYes4    
Development ToolsT/SQL QueriesYes1    
MiscellaneousAbility to deal effectively with the needs of technical peers, technical and user management, users, vendors, and staff members, and to communicate clearly and effectively in spoken and written formYes9    
MiscellaneousDWH - Data CleansingYes4    
MiscellaneousETL Process and DevelopmentYes2    
MiscellaneousRequirements GatheringNo2    
Programming LanguagesTRANSACT-SQLYes1    
Programming LanguagesTSQL stored procedureYes1    
Programming LanguagesXMLYes6    
Programming LanguagesPythonNo4    
Programming LanguagesSASNo3    
SpecialtiesData WarehousingYes5    
SpecialtiesExperience with security and data classification related to CDC, HIPAA, and CJISYes8    
SpecialtiesBusiness Analysis experience to include data flow diagrams, requirements specifications, use case scenarios, and acceptance testing.No2    
SpecialtiesSolid background in data integration, staging, quality and distributionNo1

Education

Any Gradute