Systems Software Programmer

DAILY DUTIES / RESPONSIBILITIES:

The candidate will work closely with other members of the Systems Integration (SI) team, the software vendor Conduent, and various programs within the Public Health agency. They will coordinate with the SI Section Manager and Team on daily assignments / tasks. 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 leadership and guidance, and respond promptly. Team / Project Lead experience is preferred.

Emphasis for the programmer candidate will be on the Electronic Disease Surveillance System, currently the Conduent Maven "SCION system. This will include related upgrades and enhancements, creation and modification of system integrations, and implementation support including configuration, testing, troubleshooting, and documentation. They will independently troubleshoot complex system issues, review logs and remediate errors. The candidate will lead technical and program area staff providing guidance on configuration, data modeling, workflows, data denormalization and reporting. The programmer will perform advanced SQL queries and data optimization, back-end integration (i.e. HL7 v2.x / FHIR, XML, ELRs, CDAs / eICRs into Maven), and implement process and performance improvements. The position will plan and provide testing and validation support and guidance. They will document functional requirements, technical processes, and workflows as needed. Work will use agency frameworks following agency, industry, and security guidelines and best practices.

The candidate will provide Tier 2 support for existing lab testing, lab information systems, disease surveillance systems and integrations including but not limited to OpenELIS, PHINMS, Rhapsody, REDCap, Power BI, and other in-house systems.

Specific Programmer duties and responsibilities will include but are not limited to the following:

" Rapidly learn and become an expert in the state's Electronic Disease Surveillance System (EDSS), currently the Java-based Conduent Maven product, and associated business processes

" Master technical and business concepts in multiple disciplines / processes

" Work with the EDSS vendor and IT teams to compile and deploy new releases

" Lead software and environment upgrades including Conduent Maven (Tomcat, Java), Rhapsody, PHINMS, etc.

" Ensure maximum system uptime for critical components to ensure business continuity

" Perform proactive application log reviews and automate process notifications (errors, exceptions, failures, etc.)

" Independently diagnose, isolate and debug software problems and perform problem resolution

" Report and track bugs using JIRA for vendor assessment and remediation

" Lead the implementation of data denormalization and warehousing processes

" Optimize SQL and expression-based workflows, data denormalization, and SQL persistence through Hibernate (ORM)

" Back-end processing of HL7 (v2.x / FHIR), XML, ELRs, CDAs (eICR), etc. into Conduent Maven

" Guide developers and customers in business and data modeling using complex logic and industry best practices

" Work with team members and customers to ensure all code is versioned through appropriate code repositories (SVN, Git)

" Perform and participate in code reviews for authored, team written, and vendor suggested changes. Implement reviewed changes into Production.

" Assist with data migrations and database migration related code changes, testing, and validation

" Work collaboratively to conceptualize total systems and/or product solutions currently in place

" Prepare and maintain system documentation, project documentation and architecture diagrams for applications assigned

" Ability to plan, organize, review and implement associated project milestones to completion. Ability to delegate, track and evaluate tasks as needed.

" Provide updates to the Project Team, Management and / or Stakeholders

" Guide and advise the team on best practice and techniques. Mentor the technical team and junior developers on advanced topics.

" Perform complex programming functions, assistance, and technical advice including design architecture, configuration, implementation, testing, and documentation of agency computer systems as assigned.

" Ensure adherence to agency Information Technology application development standards and security requirements. Modify existing computer systems to be compliant.

" Assist with the development of policies and procedures to conform and comply with agency standard cyber security policy design related to information risk management, designation of data as to criticality, confidentiality, and protection. (NIST 800-53, FISMA, SC InfoSec Requirements (url removed), etc.)

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 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 candidates will work closely with the Systems Integration Section Manager to identify, prioritize, schedule, and delegate workload and implementation to IT standards and procedures. The candidate will work closely with customers and subject matter experts for system design 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 confidentiality agreement and/or Business Associate (BA) agreement if applicable.

" 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 local workstation and required software.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):

1. Java Experience

2. Tomcat / Apache

3. MS T-SQL (STORED PROCEDURES, ADVANCED QUERIES, OPTIMIZATION)

4. XML / XSD / XSLT

5. Hibernate (Java)

6. Configuration Management

7. Release Management

8. Source Code Management (SVN, Git)

9. Azure DevOps / JIRA / Remedy

10. HL7 (V 2.3.1 - 2.5.1)

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):

1. Team / Project Management

2. Conduent Maven

3. PUBLIC HEALTH / DISEASE SURVEILLANCE SYSTEMS / LIMS EXPERIENCE

4. LOINC / SNOMED

5. Ant

6. Performance Testing

7. WEB SERVICES (REST, SOAP, WSDL)

8. LYNIATE RHAPSODY SOFTWARE (V 6+)

9. Excellent written, oral, and interpersonal communication skills

10. CRITICAL THINKING SKILLS AND PROBLEM RESOLUTION

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