Systems Analyst IV
Systems Analyst IV Under the direction of the IDCU Unit Director, performs highly complex (senior-level) systems analysis of the National Electronic Disease Surveillance System and Public Health Electronic Reporting system. Oversees and provides guidance in troubleshooting and solving problems related to NEDSS or to the Public Health Electronic Reporting system. Analyzes and tests new or existing protocols for NEDSS and the Public Health Electronic Reporting System. In consultation with CDC, coordinates, plans, and schedules new upgrades to the NEDSS system; and coordinates, plans, and schedules new upgrades to the Oracle database and the Public Health Electronic Lab Reporting system. Details input and output record formats for NEDSS and the ELRs. Prepares and defines the system and devises flow charts and diagrams describing operational steps of programs. Assists with preparation of cost-benefit and ROI analysis to aid in decision making on NEDSS and ELR modifications and implementations. Creates and maintains the NEDSS oracle databases required for development, testing, education and production usage. Performs ongoing tuning of the NEDSS database instances. Works within a team environment planning, developing, maintaining, analyzing user requirements/procedures, and monitoring the National Electronic Disease Surveillance System (NEDSS) and its integration of HL7 and Electronic Laboratory Reporting (ELR). Develops and implements HL7 data within the scope of NEDSS architectural standards. Provides consultative services and technical assistance to hospitals, labs and other providers aiding in modification, retrieval, and submittal of reportable clinical lab results and other clinical data while following HL7, ELR and Meaningful Use (MU) requirements in accordance with current policies, procedures, and standards. Applies principles of informatics in data collection, processing, and maintenance data integrity. May train others. Essential Job Functions:
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
(40%) Serve as a Subject Matter Expert (SME) on National Electronic Disease Surveillance System (NEDSS), providing analysis and guidance to NEDSS users and relevant personnel and public health jurisdictions. Works within a team environment planning, developing, maintaining, analyzing user requirements/procedures, and monitoring the National Electronic Disease Surveillance System (NEDSS) and its integration of HL7 and Electronic Laboratory Reporting (ELR). Oversees and provides guidance in troubleshooting and solving problems related to NEDSS or to the Public Health Electronic Reporting system. Analyzes and tests new or existing protocols for NEDSS and the Public Health Electronic Reporting System. In consultation with CDC, coordinates, plans, and schedules new upgrades to the NEDSS system. This will include version testing, validation, training, and implementation into production, as well as the documentation of implementation tasks, Texas-specific considerations, and training materials. Will work with the NEDSS coordinator and Epidemiologists to implement Gen vs2 and Hepatitis message mapping guides (MMGs), and will work with the NEDSS Team to begin implementation of published disease-specific templates (mumps, varicella, pertussis) and their MMGs. Will work with NEDSS coordinator to design and provide LHD partners with specifications for populating all fields in Public Health Document Container (PHDC) templates and map all fields of one or more PHDC into its associated investigation. Will work with LHDs to submit one or more conditions with all fields using the PHDC architecture and automate creation of investigation and notification. and Coordinates, plans, and schedules new upgrades to the Oracle database and the Public Health Electronic Lab Reporting system. Creates and/or customizes data analysis software programs to provide requested statistical or summary reports. Develops and manages NEDSS to improve effectiveness of surveillance, investigation and other epidemiologic practices. Prepares and defines the system and devises flow charts and diagrams describing operational steps of programs. Analyze data exceptions and produce management reports.
(20%) Collects, organizes, analyzes, and prepares material in response to requests for program information and reports. Perform complex analysis to diagnose reported system issues and determine necessary corrective action. Work with NEDSS Team, IDCU, and IT to analyze the architecture & assess the structure of NEDSS and the ELR workflow, and create iterative planning and delivery cycles and work flow of tasks in Rhapsody and in NEDSS. Prepare and present complex communications and/or reports on projects, assignments, and\or activities to all levels of staff up to and including executive management, including: 1) flow charts/documentation of NEDSS system processing activities, staff roles, and workflow including all scheduled processes and scripts utilized; 2) flow charts/documentation of ELR onboarding process and roles, including but not limited to: facility communication; portal access; message creation, testing, and validation; Rhapsody routing; and ELR trouble-shooting and maintenance; and 3) creation and documentation of a continuity plan for staffing positions, skills, and training resources. Other responsibilities include providing production support and technical assistance to NEDSS end users. Serves as back up to communicate with the NEDSS Users on a frequent basis to keep them informed on the status NEDSS issues or requests; Coordinates/communicates with IT support groups for problem resolution; This position requires experience in direct customer service, working in a team environment, and communicating with customers and technical support staff.
(20%) Creating and maintaining the NEDSS oracle databases required for development, testing, education and production usage, including documentation of: data storage and flow of data to reports; data marts; and data backup and recovery plan. Performing ongoing tuning of the NEDSS database instances. Using SQL to query the NEDSS Oracle database as needed. Planning and implementing backup and recovery of the NEDSS Oracle database. Implementing and enforcing security for all of the Oracle Databases. Knowledge of ETL, database backup, restore, and data mining in the NEDSS domain. Knowledge of rhapsody Orion integration engine. Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle. Performing database re-organization as required to assist performance and ensure maximum uptime of the database. Administering all NEDSS database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Knowledge of secure transmission protocols, and Secure Object Access Protocol. Works with NEDSS software vendor, to identify and improve the NEDSS Base System on improving, and upgrading the application.
(15%) Develops and implements HL7 data within the scope of NEDSS architectural standards. Oversees the technical characteristics of data interoperability according to NEDSS, DSHS and national standards. Trains and educates program staff about HL7 and MU concepts and standards, and assists them in analysis and problem resolutions pertaining to each and evaluates the effectiveness of trainings. Assists in creating user guides and provides user training for proper and effective utilization of HL7 and ELR. Trains other NEDSS staff. Keeps informed on latest developments in HL7, ELR, and MU standards. Ensures that appropriate HL7 and ELR management software is available and effectively used.
(5%)Other duties as assigned include but are not limited to actively participating and/or serving in a supporting role to meet the agency's obligation for disaster response and/or recovery of Continuity of Operations (COOP) activation. Such participation may require an alternative shift patter assignment and/or location.
Knowledge Skills Abilities:
Knowledge and understanding of HL7 for the exchange, integration, sharing, and retrieval of electronic health information
Knowledge of information technologies and communication tools necessary to support epidemiologic investigations and surveillance
Knowledge of state, and federal laws related to disease reporting in Texas
Knowledge of the basic principles and methods of epidemiology of infectious diseases
Knowledge of software tools that support online public health data acquisition, entry, abstraction management, analysis, and reporting
Knowledge of Meaningful Use policies, procedures and requirements
Knowledge of training techniques
Skill in ensuring the utilization of interoperable data standards for storage and transmission, and ability to find the relevant standards specifications as needed
Skill in using SQL and/or Oracle databases
Skill in using Orion Rhapsody and HL7 data
Skill in complex problem solving and critical thinking and in the operation of computers and applicable computer software
Ability to conduct short-range and long-range project planning studies
Ability to ensure that the information systems developed for epidemiology programs fully support the objectives, functions, and business processes of the public health system
Ability to apply procedures (policies) and technical means (security) to ensure the integrity and protection of confidential information in electronic files and computer systems.
Ability to communicate effectively
Registration or Licensure Requirements:
Initial Selection Criteria:
* Bachelor's degree (or higher) from an accredited four-year university/college in business analysis, data management, information technology, computer science, database management and administration, or other related field.
* Knowledge of database management systems such as Sybase, Oracle and/or SQL Server
* Professional experience with Rhapsody, HL7, XML, VBA, and SQL preferred.
* Minimum of two years' experience as a Business/Systems Analyst or similar job function.
* Knowledge of information systems project methodologies.
* Must be authorized to work in the United States without sponsorship.
Must be able to work in the U.S. without employer sponsorship. Applicants selected for an interview will be required to complete an in-basket exercise. Full salary range may not be offered due to budget limitations. MOS Code:
25B, IT, 2621, 3D1X1
HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.
I-9 Form - Click here to download the I-9 form.
In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.