This role involves entry-level professional information technology responsibilities. These include overseeing metadata administration, application security administration, and data analysis for the AOPC’s case management systems. The position also involves accurately applying county-customized business rules to the data store using AOPC Administration screens, in-house tools, and T-SQL for data modifications. Job Highlights Excellent benefits program, including comprehensive, low-cost medical, dental, vision, and prescription plans for employees and eligible family members beginning on the first day of employment 13 paid holidays, 12 paid sick days, and 12+ paid vacation days per year. Salary increases, student loan forgiveness plans, employee assistance programs, and State retirement plans. Telework may be available up to 2 days per week after training. Job Duties Monitors helpdesk ticket queues and prioritizes tasks based on severity and priority levels. Performs lookup value and metadata entry and maintenance to support the application. Understands the AOPC Administration screens and uses the application where appropriate. Performs user security change requests using in-house tools and template T-SQL scripts. Utilizes knowledge of T-SQL to perform application metadata and security maintenance activities. Develops and implements data scripts using IDERA Rapid SQL for SAP ASE databases. Performs testing of lookup values, metadata modifications, and application security for quality assurance. Performs metadata analysis to ensure the case management systems function properly. Assists with maintaining procedural documentation for the metadata administration and application security tasks. Assists team members and training staff with the collection and implementation of metadata. Minimum Qualifications Bachelor’s degree with an IT-related major or minor; OR Associate’s degree with an IT-related major or minor, PLUS two years of experience in the IT specialty in which to be employed; OR An equivalent combination of education, experience, and/or training may be considered. Requirements / Preferences Satisfactory criminal background check required. Knowledge and understanding of T-SQL fundamentals preferred. Salary information Starting Annual Salary $58,799 - $71,232 Applicants requiring accommodation, for any part of the application and/or interview process, should contact Human Resources at (717) 231-3309 or [email protected]. Job Type: Full-time Pay: $58,799.00 - $71,232.00 per year Benefits: 401(k) 401(k) matching Dental insurance Employee assistance program Employee discount Flexible schedule Health insurance Life insurance Paid time off Retirement plan Vision insurance Schedule: Monday to Friday No nights No weekends