DATA SYSTEM PROGRAMMER POSITION DESCRIPTION

Purpose and Description
The Data System Programmer has primary responsibility for development, implementation and updating the HIV Surveillance Database, and for working with key data systems to ensure the timely and accurate flow of case report data to the central database. The Data System Programmer is expected to collaborate closely with management staff, contractors and partners to coach and mentor capacity for HIV surveillance data transfer and to trouble shoot implementation hurdles.
Essential Functions
  • Ensure regular reporting (weekly/monthly) from health system electronic medical records (EMRs)
  • Manage electronic input of data feeds of reported cases into the HIV surveillance database
  • Assist in the process of case de-duplication, including finding and implementing opportunities for further streamlining and automation
  • Provide programming to allow correct dataflow and feedback in collaboration with IT partners
  • Follow-up with IT partners to troubleshoot HIV case reporting data flow and quality issues
  • Participate in meetings with key health system staff to discuss HIV surveillance data transfer process
  • Assure that data can be appropriately and securely accessed by colleagues using password protection as appropriate
  • Configure and maintain the HIV surveillance database server, including development of mechanisms for secure data backup, audits of user access of confidential data
  • Review, modify and elaborate SQL and XML programming to current data system interface to allow for improved data quality checking routines, ad-hoc reporting after de-duplication, etc.
  • Work with IT partners to update and database as needed to allow for access and storage of longitudinal case report data and variables
  • Work with IT partners to streamline data inputting and manipulation processes
  • Adhere to all data security and confidentiality protocols, provide ongoing TA to partners and colleagues concerning data security and confidentiality, and immediately report security breaches
Minimum Requirements

Skills/Knowledge

  • Broad knowledge of web/internet standards, hardware and software technologies; knowledge of Open MRS medical records system or related eHealth information systems (electronic medical records, laboratory information systems)
  • Experience working with Health Informatics Standards; experience with standards bases interoperability between systems
  • Proficiency in Microsoft Office and data base software (e.g. Access, SPSS, SASS, EpiInfo)
  • Proven ability to quickly learn and apply new technologies; must be able to communicate technical issues and provide system level support for a variety of collaborators and demonstrated proficiency in training, mentoring and applying management processes
  • Ability to manage projects, serve as a role model and work as a team player/builder, with ability to lead team meetings as needed
  • Strong communication abilities, including communication with both technical and non-technical audience
  • Demonstrated ability to resolve technical problems in an independent manner
  • Strong written/oral communication and presentation skills

Experience/Education

  • University degree in Computer Science or similar field
  • At least five (5) years of experience in database development
  • Demonstrated strong knowledge of SQL Server 2000/2005/2008 and SQL programming