Lab Programmer Analyst

Position: Lab Programmer Analyst

Duration: 2 Months with extendible after fiscal year

Location: 201 Monroe St, Montgomery, Alabama (Onsite from Day 1)

Position Description

Works in the Bureau of Information Technology (IT) of the Alabama Department of Public Health (ADPH) supporting the Laboratory Information Management System (LIMS) for Newborn Screening Division (NBS) and Promoting Interoperability (PI) project. Employee is responsible to provide end user support and test/configure any scheduled upgrades for NBS-LIMS. Employee should be able to develop/modify simple to complex SQL, computer programs, and operator instructions so that systems operate as defined within the specifications and troubleshoot data issues within LIMS and data exchange messages. Should be able to be a liaison between NBS-LIMS vendor and program staff and will be developing/testing all LIMS functional and developing reports using crystal reports. Should be able to develop/modify and test all ETOR (Electronic Test Orders and Results) routes using Rhapsody Integration Engine and data exchange applications between state public health lab and public health partners. Employee is responsible to work with employees at all levels of their organization to support accurate, proper data exchanges, configuring and testing NBS LIMS. They assist with any testing to observe and interpret messages received and offer updates to their supervisor.

• Provides end user system support for Laboratory Information Management Systems (LIMS) for Newborn Screening Division.
• Troubleshoots data issues within the NBS-LIMS and data exchange messages.
• Assess current NBS-LIMS for ability to meet project and user/program requirements.
• Facilitates discussions between program staff and system vendor.
• Makes recommendations for necessary software and workflow enhancements.
• Enacts enhancements approved by program staff and IT Manager.
• Designs computer programs for end users within the public health lab community.
• Develops/modifies simple to complex SQL, computer programs, and operator instructions so that systems operate as defined within the specifications.
• Configuring/updating/maintaining tables, queries, reports, letters, documents, data marts, and other parameters so that systems operate as defined within the specifications.
• Testing computer programs, SQL, configurations, table changes, queries, reports, letters, data marts, and other parameters so that systems application(s) operate substantially error free.
• Documentation of all programs.
• Configures hardware and software with the vendor provided guidelines.
• Analyzes the data stored in the databases and makes recommendations relating to performance and efficiency of stored data. Database design and data modeling/optimization.
• Programs routes within Rhapsody Electronic Data Interchange engine for parsing, processing, modifying and storing appropriate message data.
• Programs TSQL stored procedures, triggers, and user defined functions -Communicates effectively and works cooperatively with team members to optimize job performance and foster working relationships.

Skills Required

• Knowledge of personal computer hardware and related equipment.
• Experience with HL7 messages/specifications.
• Knowledge of JavaScript.
• Knowledge of Oracle 13c or higher in a production setting with tables of over 1 million records in size
• Experience with TSQL, queries, stored procedures and triggers.
• Knowledge of a Windows environment and operating system, Windows 2018 R2 Server and Windows 10.
• Excellent communication skills, both oral and written.
• Ability to work independently, under pressure and self-motivated.

Skills Preferred

• Experience with Rhapsody Integration Engine v.6.2.3 to include daily monitoring/maintenance of existing routes.
• HL7
• XML
• knowledge/working experience of any programming language.
• Ability to learn quickly and perform assigned tasks in a professional and timely manner.

Experience Required

• Any combination of training and experience equivalent to: Graduation from an accredited four-year college or university 2 to 4 years of experience in systems and programming.
• Working knowledge of Java/Microsoft Programming Language, Microsoft Reporting Services and Crystal Reports.

Education Required

• Graduation from an accredited 4-year college or university in Computer Science, Math, Information Technology or a related field, including 2 courses in programming plus four (4) years of experience in computer programming.