Position: Lab Programmer Analyst
Duration: 6 months
Location: Prattville AL (on site work)
Driver's License Required
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
Knowledge of personal computer hardware and related equipment.
Rhapsody Integration Engine v.6+
Experience with HL7 messages/specifications.
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
-Experience with Rhapsody Integration Engine v.6.2.3 to include daily monitoring/maintenance of existing routes.
knowledge/working experience of any programming language.
Ability to learn quickly and perform assigned tasks in a professional and timely manner
Any combination of training and experience equivalent to: Graduation from an accredited four-year college or university Two to four years of experience in systems and programming.
Working knowledge of Java/Microsoft Programming Language, Microsoft Reporting Services and Crystal Reports
Graduation from an accredited four-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.