System Software Programmer - Project Lead (Senior Rhapsody Developer)

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

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

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

REQUIRED EDUCATION: Bachelor's or Master's Degree in a relevant field of work or equivalent work experience.

PREFERRED CERTIFICATIONS:

RHAPSODY CERTIFICATION LIST CERTIFICATION ON RESUME