Lab IT Analyst - 2196

Job Overview :

• The candidate is responsible for providing end-user support and testing / configuring any scheduled upgrades for LIMS.
• Candidates 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 vendor and program staff and will be developing / testing all reports using the new reporting tool, Telerik Report Designer.
• 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.
• The candidate is responsible for working with employees at all levels of their organization to support accurate, proper data exchanges, configuring, and testing 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)
• Troubleshoot data issues within the LIMS and data exchange messages
• Assess current for the 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
• Analyzes file structures, and relationships and develop system designs
• 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 the 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

Required Qualifications :

• One to two years of experience in systems and programming.
• Working knowledge of EDI translation software, Integration Engines, JavaScript, and Oracle SQL
• Knowledge of personal computer hardware and related equipment.
• Experience with HL7 messages / specifications.
• Experience with JavaScript.
• Ability to establish and maintain effective working relationships with public health managers, disease surveillance staff, and other public health trading partners.
• Experience with Oracle SQL : Develop reports and ad-hoc queries using SQL.
• Ability to make good judgments in demanding situations
• Ability to react to frequent changes in duties and volume of work.
• Ability to manage multiple tasks with ease and efficiency.

Preferred Qualifications :

• HL7, XML
• Oracle SQL
• Ability to learn quickly and perform assigned tasks in a professional and timely manner.
• Rhapsody Integration Engine v.6+

Education Required :

Graduation from an accredited two-year college or university with major course work in computer science, engineering, or closely related field.

Advanced Systems Design, Inc. is :

• A leading Information Technology provider for Federal, State & Local government agencies.
• A certified minority-owned small business government contractor with capabilities related to Public Health IT, Criminal Justice, Transportation, and Defense.
• A certified service-disabled veteran-owned company with a proud 42-year track record of providing successful innovative solutions for our government customers.
• A drug-free workplace by the Drug-Free Workplace Act of 1988.
• Applicants who have a signed offer of employment or contractor agreement are subject to : the pre-employment testing protocol : background investigationdrug screening

Our Employees :

• Are actively working on next-generation technology projects with the U.S. Department of Veterans Affairs, CDC, and a wide array of Federal, State, and Local agencies throughout the United States
• Are eligible for wide-ranging benefits and perks, including but not limited to : Comprehensive Health Insurance with PPO and HDHP / HSA optionsDental InsuranceVision InsuranceShort / Long-Term DisabilityGroup Life Insurance - Company PaidVoluntary Life Insurance401(k) Plan with Employer MatchPaid Time Off (Vacation / Sick)Holiday Pay - Company Paid Federal HolidaysTuition AssistanceProfessional Certification Incentive PlanEmployee Referral PlanTechnology Exposure
30+ days ago