Rhapsody Integration Lead

Job Description

Job Description : \n\nAt the South Carolina Department of Public Health (DPH), we're committed to fostering healthy lives and communities. Our team of over 2,900 professionals operates across 90 offices statewide, boasting a rich diversity of talent united by a shared dedication to impactful work. As stewards of public health, we have a proud history of attracting and retaining top-tier individuals who seek fulfilling careers that directly impact people's well-being. We're on the lookout for self-driven individuals who thrive in collaborative settings, capable of working autonomously while also being responsive to priority tasks. Crucially, candidates must excel at cultivating effective relationships with colleagues from various backgrounds and across all levels of the organization. Join us in making a meaningful difference in South Carolina's health and environment. WHY IS THIS POSITION OPEN (new role, increased work load, new dept, resignation, promotion)? If backfill Position – What separated the candidate you initially selected from all the other resumes presented? This is a backfill position to complete outstanding work items, support Lab and Disease Surveillance integration with an eCR and ELR focus, help with CDC Data Modernization Efforts, and provide customer support and guidance. WHAT TYPES OF STAFFING CHALLENGES OR HEADACHES HAVE YOU EXPERIENCED IN THE PAST?

• SUPPLIERS MISLEADING CONTRACTORS ON REMOTE WORK
• SUPPLIERS SUBMITTING CANDIDATES OVER THE DESIRED BILL RATE
• RESUMES THAT DON’T MATCH WORK EXPERIENCE RELATED TO THE POSTING.
• STATED YEARS OF EXPERIENCE RELATED TO A TECHNOLOGY CANNOT BE IDENTIFIED ON THE RESUME.
• CONTRACTOR TRYING TO CHANGE SCHEDULE ONCE HIRED
• SUPPLIERS NOT ENSURING VISA IS VALID FOR DURATION OF PROJECT SCOPE OF THE PROJECT : Candidates should be self-motivated, team-oriented, work under limited supervision, and respond to priority tasks. Candidates 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. Additional staff are needed to assist current staff with backend processing and ELC Modernization Projects. This will include requirements gathering with customers, providing technical advice, time and effort estimates, and project documentation including status reporting. Ideal candidates will have experience with electronic Case Reporting (eCR) and Electronic Laboratory Reporting (ELR) formats, processing, and integration. Expected work includes process development / automation, webservice calls, parsing various data formats (xml, csv, SOAP, HL7, etc.), and route development. The developer will help with testing, validations, user acceptance testing, deployment, and post implementation support. The focus will be on enhancing custom data management and transformation processes in the Rhapsody software, to set up new routes and processes needed for new data provisions to the CDC, and to create proactive monitoring processes for immediate identification and resolution of data processing issues. Ensure systems are following industry best practices to ensure strategic initiatives and compliance with federal and state regulatory laws and ensure business continuity. This position will be a part of the team responsible for supporting critical systems and environments used by the Public Health and Lab, Disease Surveillance, and day-to-day operations. POSITION : SYSTEM SOFTWARE PROGRAMMER - PROJECT LEAD OPEN TO VISA TRANSFER? □ YES X NO START DATE : IMMEDIATELY DURATION : 12 MONTHS POSSIBILITY OF EXTENSION? YES PUBLIC SECTOR / GOV’T EXPERIENCE REQUIRED? PREFERABLE REMOTE WORK POSSIBILITY? YES PRE-EMPLOYMENT CHECKS (drug, credit, criminal, motor vehicle)? Credit-7 year history; Criminal background check- 7 year history; E-Verify, Confidentiality Agreement, Drug-Free Affidavit, Business Associate Agreement 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. Ideal candidates will have experience with electronic Case Reporting (eCR) and Electronic Laboratory Reporting (ELR) formats, processing, and integration. 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. Specific duties and responsibilities will include but are not limited to the following :
• Monitor routes and production processing to ensure proper data flow and response times using Rhapsody UI and other tools
• Help to perform and automate daily maintenance processes
• Troubleshoot and 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.
• Work with program area staff to perform gap analysis, gather and document functional requirements, and create necessary processes
• 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.
• Ability to plan, organize, review, implement associated project milestones to completion.
• 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
• Upgrade, modify, troubleshoot, review, and support disease surveillance interfaces including eCR and ELR processes o Create / modify routes that will import eCR data into our Disease Surveillance System (the Conduent Maven System using Maven Integration Format)
• Assist with data migrations and database migration related code changes, testing, and validation
• Modernization of legacy computer systems / processes to Rhapsody routes and logic. 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 on board 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.
• Prepare and maintain system documentation and architecture diagrams for processes assigned (new and existing).
• 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. The selected candidate may be able to work flexible hours during the week when needed to provide coverage on weekends. 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 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 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. DPH Support : DPH 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. RHAPSODY INTEGRATION ENGINE (V 6+) 2. SYMPHONIA MAPPING LANGUAGE (SML) 3. HL7 (V 2.3.1 - 2.5.1; ORU & ORM MESSAGE TYPES) PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE) : 1. ECR / EICR / RR / CDA / CCDA 2. WINDOWS SERVER OS ADMINISTRATION 3. LARGE SCALE INTEGRATION AND DESIGN IN HEALTHCARE ENVIRONMENT 4. XML / XSD / XPATH 5. SQL (INCLUDING ADVANCED JOIN STATEMENTS) 6. JAVASCRIPT (ECMA / E4X) 7. WEB SERVICES (SOAP) 8. CRITICAL THINKING SKILLS AND PROBLEM RESOLUTION 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 4. PUBLIC HEALTH / DISEASE SURVEILLANCE SYSTEMS / LIMS EXPERIENCE 5. LARGE SCALE DATASET MANIPULATION / MIGRATION 6. LOINC / SNOMED 7. DEVOPS / JIRA 8. SOFTWARE DEVELOPMENT LIFE CYCLE (SDLC) 9. VISIO / FLOW DIAGRAMS 10. ABILITY TO ESTABLISH POSITIVE WORKING RELATIONSHIPS WITH TECHNICAL STAFF, CUSTOMERS AND OTHERS INVOLVED IN DATA-CENTRIC MANAGEMENT. REQUIRED EDUCATION : Bachelor's or Master's Degree in a relevant field of work or equivalent work experience. PREFERRED CERTIFICATIONS : RHAPSODY CERTIFICATION (REQUIRED : PLEASE INDICATE CERTIFICATION LEVEL AND / OR N / A) INTERVIEW PROCESS (who will conduct i / v, phone or in-person, how many rounds of i / v’s)? An interview panel will conduct one initial round of in person, video, or phone conference interviews. If no candidate is selected a second round of interviews will be conducted. Potential candidates, not initially selected, will not be disqualified until an offer is made and accepted. SCHEDULE INTERVIEW : (date / times)? Will review resumes once qualified and will schedule in DotStaff after review.