Job ID: SC-9656
Remote Certified RHAPSODY with SML, HL7, ORU/ORM, XSD/XPATH, JAVASCRIPT, PUBLIC HEALTH/DISEASE, EXCEL/VBA MACROS/AUTOMATE, JIRA and LOINC/SNOMED Experience
Location: Columbia, SC (DPH)
Duration: 12 Months
Possibility for Extension: Yes
Work Location: 100% Remote
Candidate location: No SC residency required. Open to nationwide candidates. Candidates MUST be comfortable working EST hours.
REQUIRED SKILLS (RANK IN ORDER OF
IMPORTANCE):
1. 5+ YEARS V6+ RHAPSODY
INTEGRATION ENGINE
2. 5+ YEARS SYMPHONIA MAPPING
LANGUAGE (SML)
3. 5+ YEARS HL7 (SUCH AS V 2.3.1
2.5.1; ORU & ORM MESSAGE TYPES)
4. 2+ YEARS XML / XSD / XPATH
5. 3+ YEARS SQL ADVANCED JOIN
STATEMENTS
6. 5+ YEARS JAVASCRIPT
7. 2+ YEARS SOAP WEB SERVICES
REQUIRED EDUCATION: Bachelor s or
Master s Degree in a relevant field of work or
equivalent work experience.
PREFERRED SKILLS (RANK IN ORDER OF
IMPORTANCE):
1. WINDOWS OS SERVER ADMINISTRATION
2. PUBLIC HEALTH/DISEASE
SURVEILLANCE SYSTEMS/LIMS
EXPERIENCE
3. EXCEL/VBA MACROS/AUTOMATE & FLOW
4. LOINC/SNOMED
5. DEVOPS/JIRA
6. REDCAP
7. FASTQ FILES AND DEMULTIPLEXING
PREFERRED CERTIFICATIONS:
RHAPSODY CERTIFICATION LIST
CERTIFICATION ON RESUME
DAILY DUTIES / RESPONSIBILITIES:
The candidate will work closely with other members of the Systems Integration applications
team and various programs within the Public Health Deputy Area. The candidate should be
self-motivated, team-oriented, work under limited supervision, and respond to priority tasks.
The candidate must be able to independently research and design processes, create
specifications, develop, lead testing, perform code reviews, actively engage with the team and
stakeholders, attend meetings, provide guidance, and respond promptly.
Participate in a team comprised of DPH and solution implementation staff for Systems
Integration related planning, design, configuration, and conversion / rewrite of existing
processes, code, and functionality in/into the Rhapsody Environment. Will coordinate with
assigned IT Section Manager and Team Lead on daily assignments / tasks. Will coordinate and
collaborate with contract and vendor staff as well as existing DPH staff and other IT
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
manager.
Will advise Staff on code conversions, route and configuration changes and enhancements,
process improvements, software updates and maintenance. Work with vendors and staff on
deliverables, troubleshooting and conversion of current processes to Rhapsody. Includes
rewriting existing solutions to conform to best practices and updated coding standards and to
improve efficiency, performance, and maintenance.
Ideally this position would serve as the IT lead for this project managing the project work,
communications, and customer expectations.
Specific duties and responsibilities will include but are not limited to the following:
Prepare and maintain system documentation and architecture diagrams for processes
assigned (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, implement associated project milestones to
completion.
Process Development, Process Automation, and ETL Solutions
SQL query creation and validation to include advanced joins
Perform complex programming functions, assistance, and technical advice including
design architecture, configuration, writing, testing, and documentation to complex
programming of agency computer systems as assigned.
Create new and update existing Rhapsody routes to handle new data elements and
formats creating the necessary output for upload into testing, lab, and surveillance
systems as well as report to the CDC
Transformation of multiple formats (xml, csv, SOAP, HL7, etc.) in Rhapsody with
Symphonia and Javascript (ECMA/E4X)
Formatting data into Conduent Maven Integration Format (MIF) for import into the
Disease Surveillance System
Utilize webservice calls to and from Rhapsody parsing request/response data
Monitor routes and production processing to ensure proper data flow and response
times using Rhapsody Web Management Console and other tools
Help to perform and automate daily maintenance processes
Debug, troubleshoot, and optimize new and existing processes.
Resolve processing issues.
Correct and reprocess errors
Advise on monitoring practices, thresholds, and notifications
Support Rhapsody upgrades and new environment configuration
Ensure maximum system uptime for critical components to ensure business continuity.
Assist with data migrations and database migration related code changes, testing, and
validation
Review existing code for rewrite into Rhapsody routes.
Perform / participate in code reviews for authored, team written, and vendor suggested
changes and implement reviewed changes into Production
Advise the team on best practice and techniques. Mentor technical team on advanced
topics.
Assist the team, DPH staff, and vendors to onboard providers and partners to utilize
Rhapsody supported services like HL7 electronic lab reporting (ELR), electronic test
orders and resulting (ETOR), electronic case reporting (eCR), and Interpartner data
sharing.
Modification / rewrite of existing processes and creation of new processes to be
compliant with agency security requirements and following industry best standards
The position will be utilized for 40 hours per week for the duration of this project. In general,
standard weekday work hours are expected. The selected candidate may be able to work
flexible hours during the week for the purpose of providing coverage on weekends when
necessary and preapproved. Total week hours (to include the weekend) should not exceed 40
unless approved in advance (i.e., hours worked on Saturday and/or Sunday would be deducted
from hours worked Mon-Fri). This position would need to be available to support critical
systems during business hours, on off-hours, and weekends.
The candidate will work closely with the Systems Integration Section Manager to identify,
prioritize, and schedule workload and implementation to IT standards and procedures. The
candidate will work closely with customers and subject matter experts for the system design,
migration to the new framework, and testing.
This will also include compliance with SC DPH security policy/procedures as well as
integrating systems, when possible, to streamline staff workflows, user security, and data
correction.
Module support of the project.
DPH will require that selected personnel sign the DPH confidentially agreement and/or
Business Associate (BA) agreement if applicable. All web services must be secure.
DPH 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 Public Health. Any source code, data, product, or
functionality resulting from this SOW or previously owned/developed by DPH will
remain the sole property of DPH 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
DPH.
DPH has the final say on all programming choices.
Payment Schedule:
All timesheets shall be entered and approved in a timely manneer 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.