Applications Systems Analyst I

Agriculture & Consumer Services; Cary (NC); Remote; USD 71,000 - 91,000; Full time

Job summary

The N.C. Department of Agriculture and Consumer Services is seeking a Software Developer to design, implement, and support Laboratory Information Management Systems (LIMS) across the Food & Drug Protection Division.

Responsibilities include development, maintenance, and integration of LIMS with legacy databases, plus user training and continuous improvement. Candidates should have SQL expertise, VB.NET or C# programming, and experience with Labworks and reporting tools like Crystal Reports/SSRS.

Qualifications

• Experience writing complex SQL queries and stored procedures.
• Experience programming using VB.NET or C#.
• Experience creating reports using Crystal Reports or SQL Server Reporting Services.
• Experience in lab environments.
• Experience supporting Labworks.

Responsibilities

• Develop, enhance, maintain, administer and support LIMS for the Food & Drug IT solutions.
• Integrate LIMS with mainframe and legacy databases across labs.
• Provide proactive problem determination and resolution for LIMS issues.

Skills

SQL queries

VB.NET or C#

Crystal Reports

SQL Server Reporting Services

Labworks

Education

Bachelor's degree in computer science or IT field

Associate degree in computer science or IT field with 1 year experience

GED with 4 years in business application development/consulting

Tools

Labworks

Crystal Reports

SQL Server Reporting Services

Job description

About Us

The N.C. Department of Agriculture and Consumer Services provides services that promote and improve agriculture, agribusiness, and forests; protect consumers and businesses; and conserve farmland and natural resources for the prosperity of all North Carolinians. The Department employs approximately 2,000 employees.

Description of Work

Please note: Job postings close at 11:59:59 p.m. the night before the listed Posting End Date above. The position currently qualifies for a telework option. Telework options are subject to change at the discretion of management. This position provides full-service application development and support from business process analysis and re-engineering to development and implementation. To provide NCDA&CS with functional software applications that meet their business requirements and provide the services necessary to meet business needs. The work to be performed is identified and prioritized by the Department’s Information Resource Management Committee (IRMC) and is implemented using structured projects and SDLC methodologies.

This position is responsible for development, enhancement, maintenance, administration, and support of the Laboratory Information Management Systems (LIMS) for the Food and Drug Protection Division program carried out in administration of the various division laws. This position is responsible for the development and support of a Laboratory Information Management System (LIMS). There are many standard features in a modern Laboratory Information Management System (LIMS), such as sample tracking, quality assurance/quality control checks, remote data entry, range checks, reporting, and instrument interfacing. These systems can range from COTS (commercial off-the-shelf) products to custom-developed in-house systems. This position supports all the features to each Lab that interface with the LIMS. A modern LIMS is integrating all the separate mainframe and legacy database programs into a single database that will increase the efficiency of the system, provide for greater flexibility as well as improving the ease of use by the supported programs. This position provides proactive problem determination and resolution for LIMS issues. This position is responsible for identifying and recommending needed resources and upgrades for Food & Drug IT solutions. This position also provides computer systems and applications training for the Division. This position reports to the Business and Technology Applications Manager and is co-located between the Constable Laboratory and downtown Agriculture building with the IT division. At times, this position will be utilized to assist in other IT projects or issues.

Knowledge, Skills and Abilities / Management Preferences

1. Experience in writing complex SQL queries and stored procedures.


2. Experience programming using VB.net or C#.


3. Experience creating reports using Crystal Reports or SQL Server Reporting Services.


4. Experience in lab environments.


5. Experience supporting Labworks.

Recruitment Range: $70,528 - $91,299. Any employment offer may be less than the maximum of the range due to salary equity with similarly situated employees or the selected candidate's related education and experience.

Minimum Education and Experience

Some state job postings say you can qualify by an \"equivalent combination of education and experience\". If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details. Bachelor's degree in computer science or an IT related field from an appropriately accredited institution, or Associate degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and one year of experience in business application consulting or development, or High School or General Educational Development (GED) diploma and four years of experience in business application consulting or development; or an equivalent combination of education and experience.

Applicant Eligibility

Applicants seeking veteran's/National Guard preference should submit a copy of their Form DD-214, NGB 23A (RPAS), DD256 or NGB 22. All Law Enforcement positions, aviation safety-sensitive positions, and positions requiring a Pilot's License or a Commercial Driver's License (CDL) shall be subject to pre-employment drug testing. All positions requiring a Commercial Driver's License shall also be subject to pre-employment DMV physicals. Selected applicants must obtain a U.S. Department of Transportation (USDOT) medical certificate prior to employment. If a CDL is listed as a preference and the selected applicant has a CDL at the time of hire, then the CDL will become a requirement for the position.

EEO Statement

The State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices.