Database Warehouse Analyst jobs in Springfield, IL

*MUST BE LOCAL TO METRO ATLANTA*

The role will support the testing, functionality and validation efforts of new LIMS applications within the PHL environment. The assistant LIMS Administrator will troubleshoot; perform remedial actions while documenting resolutions consistent with College of American Pathologists and CLIA standards to resolve problems within applications. This position will also assist in PHL grant application, implementation and reporting and will assist in internal and external training development and delivery.

Duties include, but are not limited to:

• Analyze data and laboratory workflows and provide strategy and methods to tune and improve the LIMS
• Implement alterations to the existing LIMS system to ensure the system continues to meet the evolving business needs.
• Ensure that existing system functionality continues to function correctly by coordinating vendor activities and/or implementing internal activities to correct software faults as well as doing preventative maintenance and other recurring tasks.
• Implement new Laboratory Information Management System.
• Write robust documentation and able to effectively communicate all LIMS related issues in a timely fashion to all PHL staff members.
• Implement and maintain APHL/CDC Public Health Laboratory Interoperability Project (PHLIP) HL7 ORU messages
• Implement and maintain CDC Antibiotic Resistance Lab Network (ARLN) result messaging, CSV and/or HL7 ORU
• Implement and maintain HL7 ELR feed to OSDH Acute Disease service software, PHIDDO
• Development and maintenance of PHL web accessioning page (test requisition)
• Collaborate with OIT to ensure proper maintenance of laboratory subnet – connection of laboratory equipment, IP configuration, file transfer, serial data connections
• Development and maintenance of LIMS visual workflows for tracking of tests/samples
• Review grant PHL Funding Opportunity Announcements (FOA) and PHL Notice of Funding Opportunities (NOFO) for identification of key activities and budget items.
• Develop and/or refine grant narratives, justifications, performance evaluations, implementation plans, and milestones for competitive grants
• Develop and deliver trainings for LIMS implementation, grant completion, and administrative procedures
• Lead and coordinate technical investigations and manage technology resolution implementations for PHL activities.
• Perform technical tasks like LIMS installations, environment refreshes, backups, performance tracking, etc.
• Develop ad hoc queries (SQL) based on user requirements.
• Liaise with LIMS vendor, other internal technology groups and business partners on technology change governance and change prioritization.
• Ensure information security; access, use, and safeguard sensitive information to ensure HIPPA compliance
• Formulates and defines scope of work for major upgrades to LIMS with an understanding of applicable systems and laboratory requirements

Skill Matrix

• Bachelor’s degree is required, preferably in a scientific field of study Required
• Extensive technical knowledge of medical laboratory processes and procedures while being familiar w/federal regulatory statues governing medical labs Required 5 Years
• experience developing, integrating and configuring LIMS in a clinical testing environment Required 5 Years
• professional experience utilizing DBMS and proficient in SQL Server Environment. Required 5 Years
• A working knowledge and understanding of laboratory operations, workflows, and testing algorithms for clinical laboratory analyses Required 5 Years
• Familiar with emergency preparedness or infectious disease outbreak investigations Required 5 Years
• Understanding of SQL database queries and relationships Required 5 Years
• Understanding of system enhancement principles and tools, such as Design/Coding/Performance/Maintenance Required 5 Years
• Familiar with 21 CFR Part 11 compliance and computer system validation Required 5 Years
• Strong knowledge of Crystal Reports Required 5 Years
• Sound knowledge of Microsoft Office Tools Desired 5 Years
• Preferred languages: Jscript, .NET, VBScript, SSL, HL7, XML, Python, Zpl Desired 5 Years
• RDBMS: SQL Server, Oracle Desired 5 Years