Health Application Systems Analyst - Concord, United States - Crescens

Description

• This position is expected to work full-time hours of 37.5 hours per week ( NOT a 40 hour work week ).
• Candidates can work remotely and must be able to work on the Eastern Time Zone business hours. The candidate must be able to participate in web/video meetings as needed while remote.

• Experience with Rhapsody integration engine, including recognizing comm point errors and other indications of issues affecting downstream applications.
• The Automated Hospital Emergency Department Data (AHEDD) system is an automated, electronic system, which receives encrypted Health Level Seven (HL7) transaction messages directly in near real-time.
• This system is a crucial component for the client and is necessary for broad state-wide early detection of reportable disease and other health threats (also known as syndromic surveillance).
• The current AHEDD system relies upon several generations of legacy software and is not able to be maintained by in-house Department of Information Technology (DoIT) personnel. The person in this role needs to be able to provide application analysis relative to the vast amount of current and legacy software utilized within this system, so someone who has come from a similar development background prior to moving into the systems analyst role would be ideal. Without this resource, client will not be able to maintained and supported effectively for Public Health to perform syndromic surveillance.

• Collaborate with the application developer to ensure that the AHEDD system remains reliable and available through ongoing maintenance and monitoring.
• Develop, plan, and guide implementation of debugging, defect resolutions found in the AHEDD software.
• Assess current AHEDD software, and work with application developer to design and implement updates and upgrades to the AHEDD software, its web user interface, associated APEX-based reporting tool, and Microsoft Access reporting tool.
• Review, plan and manage updates to AHEDD database tables as needed.
• Collaborate with client personnel and other contractors and ensure AHEDD functions reliably and remains available during changes to connected Systems including, but not limited to, the Rhapsody HL7 integration engine, Tomcat web application server, Windows operating system, Oracle database, and VMWare tools.
• Collaborate with application developer to write and submit ODARs to request database updates as needed.
• Assist with AHEDD integrations including EBI (Enterprise Business Intelligence), and NHESSENCE SQL database systems.
• Collaborate with client personnel and other contractors and ensure that AHEDD is updated to detect and report new ICD-10 codes, conditions of interest, and reportable diseases on both a rolling and emergent / unscheduled basis.
• Collaborate with client personnel and other contractors to ensure AHEDD supports and functions correctly with new versions of discharge codes and other structured and unstructured data from participating facilities.
• Collaborate with client personnel and other contractors to develop and perform comprehensive test plans to detect defects, unexpected data input, system performance problems, and potential areas for improvement.
• Collaborate with client personnel and other contractors to analyze logs and other data to assist in diagnosing and finding root causes of anomalous data and system behaviors.
• Collaborate with client personnel and other contractors to create, analyze, and test HL7 feeds from facilities as part of their onboarding / reonboarding processes.
• Maintain detailed documentation, including updating the AHEDD data dictionary document and conceptual, logical and physical data diagrams.
• Adhere to the current SDLC process including the use of CA Harvest version control management.
• Determine time estimates, schedule for work, and proposals for solutions to tasks in a timely manner.
• Provide ongoing status of work to Project Team Lead.
• Ability to work in a team environment, with strong communication skills, both written and oral.
• Execution of all responsibilities with limited direct supervision of Team Lead.

• Must conduct all work from the contiguous United States (lower 48 states) and ensure all data including backups remain within the contiguous United States.
• 8-10 years of JAVA programming experience.
• 8-10 years of experience Oracle PL/SQL scripting.
• Use, analysis, development and maintenance of Microsoft Access based applications.
• Developing and using Oracle APEX reporting tools.
• Experience with analyzing and planning merger and stability enhancements for complex, large SQLbased databases containing disparate and interconnected schemas.
• Experience managing and working closely with application developers and teams with diverse skillsets and backgrounds.
• SQL scripting (MS-SQL).
• Developing applications dependent on Tomcat Apache application server. Preferred skills include:
• Interpreting, reviewing, and analyzing HL7 v2.X messages including structure, interpretation, and violations of implementation guides and other standards.
• Experience using Quest TOAD for Oracle.
• Experience using the CA Harvest version control management system.
• Experience analyzing, planning, and writing ODARs (Oracle Database Action Request) for DBA team.
• Experience using Filebeat, Elastic / Logstash, Kibana log monitoring solutions.
• Experience with MS Windows Servers and RedHat Linux servers in a virtualized (VMWare) environment.

• Experience as an Application Systems Analyst working in a Healthcare or Department of Health & Human Services environment
• Experience with application systems analysis for Emergency Hospital Data Systems or Syndromic Surveillance Systems (or similar), specifically.
• Experience analyzing & planning merger & stability enhancements for complex, large SQL-based databases containing disparate and interconnected schemas
• Experience developing, planning, and guiding implementation of debugging, defect resolutions in complex application systems
• Experience assessing system software & working w/app dev to design & implement updates/ upgrades to software, web user interface, & reporting tools
• Developing and using Oracle APEX reporting tools
• Experience reviewing, planning & managing updates to system database tables
• Oracle PL/SQL Scripting
• SQL Scripting (MS-SQL)
• Use, analysis, development and maintenance of Microsoft Access based applications
• Experience working w/team members to analyze logs & other data to assist in diagnosing/finding root causes of anomalous data and system behaviors
• Experience interpreting, reviewing, and analyzing HL7 v2.X messages (MUST BE 2.X version experience specifically)
• Experience maintaining detailed documentation, including updating data dictionary documents & conceptual, logical and physical data diagrams.
• Java Development experience
• Experience developing/analyzing applications dependent on Tomcat Apache application server
• Experience with MS Windows Servers and RedHat Linux servers in a virtualized (VMWare) environment
• Must conduct all work from the contiguous United States (lower 48 states) and ensure all data including backups remain within the contiguous US.