Lab IT Analyst

Position Description: Works in the Bureau of Information Technology (IT) of the Alabama Department of Public Health performing mid-level professional programming, systems analysis work and database development. Employees in this class are responsible for analyzing and evaluating existing applications, designing and developing new or enhanced applications and databases to support end-user needs. Work is performed independently under the general direction of the Information Technology Manager and involves specialization in a particular area such as database development, specific operating systems, or assignment as a generalist performing in multiple areas supporting complex systems. Tasks Specification: The requirements for this position must meet the following requirements or possess an equivalent combination of education and experience: • Provides end user system support for Laboratory Information Management Systems (LIMS) • Troubleshoots data issues within the LIMS and data exchange messages • Assess current 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 • Analyzes file structures, 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 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

Skills Required: Knowledge of the organization, functions, responsibilities and procedures of the Alabama Department of Public Health • Knowledge of personal computer hardware and related equipment • Ability to establish and maintain effective working relationships with public health managers, disease surveillance staff and newborn screening staff as well as other public health trading partners • Knowledge of JavaScript. • Knowledge of Oracle 12c 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 2012 R2 Server and Windows 10. • Excellent communication skills, both oral and written. • Ability to work independently, under pressure and self-motivated.

Skills Preferred: Any combination of training and experience equivalent to: Graduation from an accredited two-year college or university with major course work in computer science, engineering, or closely related field, with a minimum of two years of programming experience using the following languages/tools: C#; SQL; JavaScript; Microsoft Visual Studio; Microsoft Reporting Services. This person must have the ability to work on multiple assignments and to work collaboratively within a team.

Experience Required: Any combination of training and experience equivalent to: Graduation from an accredited two-year college or university. One to two years of experience in systems and programming. Working knowledge of EDI translation software, Integration Engines, JavaScript and Oracle SQL

Experience Preferred:

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

Education Preferred:

Additional Information: -budgeted for 12 month contract with possible extension if new funding is acquired. This position is full time, onsite at the State Public Health Lab in Prattville, AL. -this position will move quickly. Please allocate resources right away. -Interviews will be conducted via video, possibly followed by 2nd round, in person interviews -Please contact ACRO PM with questions Please prepare a compelling candidate summary to include the below: a. Candidate availability to interview: b. Candidate availability to start: c. Candidate's current interview activity and job leads: d. Candidate's current employment status:

---