Database Analyst (LIMS Administrator) (212476)

Job Description:

The Kansas Department of Health and Environment has a Database Analyst (LIMS Administrator) opening.

Are you a self-motivated individual with Oracle SQL and/or C# experience looking to make an impact on the citizens of Kansas? Then a LIMS database administrator with the Kansas Health & Environmental Laboratories (KHEL) may be right for you. KHEL is the sole State public health laboratory in Kansas and produces ~250,000 laboratory reports for human and environmental samples each year. If you enjoy problem-solving and programming while making a significant difference in the lives of our State, then we encourage you to apply!

Job Responsibilities may include but are not limited to the following:

Perform troubleshooting of retrieval of data as needed. Maintain knowledge of the laboratory testing capabilities and workflows by learning lab processes in all areas to provide input on best practices for setting up analysis codes in the LIMS and to assist in troubleshooting of LIMS. Create LIMSLink methods for auto upload of instrument data into LIMS. Maintain current knowledge of SQL and Oracle PL/SQL programming so that advanced workflows and calculations can be used in the configuration. Update workflows and calculations and create new workflows and calculations as testing needs change. Perform updates and development as requested and approved. Develop electronic interfaces with health information exchanges. Develop custom queries and reports to support both outside programs as well as laboratory staff. Maintain the queries by ensuring they are working correctly, and update as needed and approved.

Develop analytical method test codes and reports to meet the needs of the staff and stakeholders.

Minimum Qualifications

• Two years of experience with SQL database. Education may be substituted for experience as determined relevant by the agency.

Education:

• High School, GED

Licensing & Certification:

• Valid Driver’s License – Incumbent is required to have and maintain a valid driver’s license when operating a state vehicle, a private vehicle, or a rental vehicle for the benefit of the State.

Preferred Qualifications:

Any additional skills, experiences, or qualifications that would be beneficial, but aren’t strictly necessary.

• Bachelor’s degree in computer science, natural science, or physical science.
• Previous experience in a laboratory or scientific setting.
• Previous experience with information management systems.
• Knowledge of Oracle PL/SQL programming.
• Experience in laboratory operations and providing training to others.
• Proofreading, editing, attention to detail.
• Word, Excel, PowerPoint, Access.

About the Position:

• Who can apply: Anyone (External)
• Classified/Unclassified Service: Unclassified
• Full-Time/Part-Time: Full-Time
• Regular/Temporary: Regular
• Work Schedule: Monday-Friday, 8am-5pm (Flexible schedules available)
• Eligible to Receive Benefits: Yes
• Veterans’ Preference Eligible: Yes

Employment Benefits:

• Comprehensive medical, mental, dental, vision, and additional coverage
• Sick & Vacation leave
• Work-Life Balance programs: parental leave, military leave, jury leave, funeral leave
• Paid State Holidays (designated by the Governor annually)
• Fitness Centers in select locations
• Employee discounts with the STAR Program
• Retirement and deferred compensation programs

How to Apply:

Specific instructions for applying, which might include submitting a resume, cover letter, list of references, or completing an online application.

• Please include the Job ID number when emailing.

Job Application Process:  Only applications submitted within our State of Kansas Careers Portal will be considered.

• First Sign in or register as a New User at https://admin.ks.gov/offices/personnel-services/jobs
• Complete or update your contact information on the State of Kansas Careers Portal > My Contact Information page. *This information is included on all your job applications.
• Upload required documents listed for each specific job posting.
• Start your draft job application, upload other required documents, and submit when it is complete.

–  Manage your draft and submitted applications on the Careers> My Job Applications page.

• Check your email and My Job Notifications for written communications from the Recruiter.

–  Email – sent to the Preferred email on the My Contact Information page.

–  Notifications – view the Careers> My Job Notifications page.

Helpful Resources at jobs.ks.gov: “How to Apply for a Job – Instructions” and “How to Search for a Job – Instructions.”

Contact Information:

[email protected]

Salary Range

$ 31.22 to 32.78