SYSTEMS SOFTWARE PROJECT LEAD Remote Columbia SC

About the job SYSTEMS SOFTWARE PROJECT LEAD Remote Columbia SC

SYSTEMS SOFTWARE PROJECT LEAD Remote Columbia SC

Authorized to work in the US

No H1B

Max $70 USD per hour / 1099 Contractor

Government Experience Required: Preferable

At the South Carolina Department of Public Health (DPH), we're committed to fostering healthy lives and communities. Our team of over 3,400 professionals operates across 70 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.

Scope of the project:

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.

Objectives to Be Fulfilled by Candidate:

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 states 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 http://admin.sc.gov/technology/information-security/policies-and-procedures, etc.)

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.

Required Skills (rank in order of Importance):

Java Experience

Tomcat / Apache

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

XML / XSD / XSLT

Hibernate (Java)

Configuration Management

Release Management

Source Code Management (SVN, Git)

Azure DevOps / JIRA / Remedy

HL7 (V 2.3.1 - 2.5.1)

Preferred Skills (rank in order of Importance):

• Team / Project Management
• Conduent Maven
• PUBLIC HEALTH / DISEASE SURVEILLANCE SYSTEMS / LIMS EXPERIENCE
• LOINC / SNOMED
• Ant
• Performance Testing
• WEB SERVICES (REST, SOAP, WSDL)
• LYNIATE RHAPSODY SOFTWARE (V 6+)
• Excellent written, oral, and interpersonal communication skills
• CRITICAL THINKING SKILLS AND PROBLEM RESOLUTION

Required Education:

Bachelor's or Master's Degree in Computer Science or related field and/or 7 or more years of relevant work experience

Required Certifications:

NA