FLSA STATUS: Non-Exempt
Under immediate supervision; performs work of routine difficulty in writing and fulfilling reports from the Police Records Management System and Computer Aided Dispatch System; and performs related work as required.
DISTINGUISHING FEATURES OF THE CLASS
An employee in this class is responsible for designing, creating, managing and fulfilling requests for reports and information from the Records Management System. Works with end users to understand the purpose and report requirements for assigned projects. Prepares and runs queries, updates and modifies reports using various reporting tools and troubleshoots and resolves issues.
ESSENTIAL DUTIES AND RESPONSIBILITIES
The list of duties and responsibilities is illustrative only, and is not a comprehensive listing of all the duties and responsibilities performed by positions in this class.
• Develops and writes accurate reports based on the specifications defined by participating agencies using tools such as Crystal Reports, Business Intelligence, etc.
• Works with internal and external departments on the development of the Police Records Management System (PRMS)
• Acts as a liaison with participating agencies for interfacing and report development
• Act as a liaison with vendors for report development
• Assist in the maintenance of the PRMS system and all interfaces
• Compiles statistical analysis of report outcomes, monitors input to ensure accuracy of data
• Runs reports for internal monitoring, conducts internal quality control as needed, assists in trainings with internal and external users from other participating agencies
• Ensures the accurate submission of data as required by the Illinois State Police and the FBI
• Attends and participates in regular PRMS User Group meetings
• Provide technical support to participating agencies and assist with handling trouble tickets
• Perform special projects as assigned by management
• Maintains regular attendance and punctuality
NON-ESSENTIAL DUTIES AND RESPONSIBILITIES
• Adjusts work assignments and schedules in the event of an emergency to participate in emergency preparedness, response, and recovery activities as assigned.
• Depending on assignment may maintain required emergency management training, licensure and/or certifications.
• Performs related duties as required or assigned within job classification.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and /or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
• Using, manipulating and managing various report writing software and tools such as Crystal Reports, Business Intelligence, SQL Server Reporting Services (SSRS), and similar database models, tables, queries and Excel.
• SQL database structure
• Creating custom reports based on defined content and required specifications
• Maintains effective relationships with appropriate agencies and vendors
• County policies and procedures
• Applicable federal, state, and local laws, rules, regulations, codes, and/or statutes
• Time management resulting in completion of work to meet required deadlines.
• Making sound recommendations to improve and optimize system output.
• Analyzing facts and exercising judgment arriving to conclusions
• Handling and resolving technical problems with the database and software systems.
• Conveying excellent oral and written communication including initiating and communicating persuasively with external organizations.
• Using computer hardware and software including word processing, spreadsheets, databases, email, etc.
• Applying an acquired knowledge of procedures, rules, regulations and services applicable to the assigned office
• Develop innovative processes and reports to achieve desired results.
• Carry out instructions furnished in writing, oral or diagram form, and to produce desired outcomes timely and completely.
• Write reports, business correspondence and procedure manuals.
• Manage projects and multiple priorities simultaneously
• Establish and maintain effective working relationships with department and division staff, other departments and others, such as vendors
• Communicate and use interpersonal skills to interact with coworkers, supervisor, the general public, etc. to sufficiently exchange or convey information and to receive work direction
• Ensure compliance with applicable federal, state, and local laws, rules, and regulations
• Convey excellent oral and written communication
• Work effectively under stress
• Maintain confidentiality
EDUCATION and/or EXPERIENCE
Completion of an Associate’s Degree in Computer Science or related field and three (3) year of database and report writing experience; or, an equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Position is typically office or administrative work and is not substantially exposed to adverse environmental conditions.
CERTIFICATES, LICENSES, REGISTRATIONS