System Administrator - Crime Analyst

GUILFORD COUNTY GOVERNMENT

Empower Successful People to thrive in a Strong Community supported by Quality Government

Transparency & Communication | Equity & Inclusion | Accountability

Service & Outcomes Excellence | Our People Matter

GENERAL STATEMENT OF DUTIES

The Systems Administrator/Crime Analyst will manage access and privileges to numerous law enforcement databases, act as the primary point of contact for user assistance, conduct audits as required and report/maintain audit results, provide statistical data in a concise format, and complete daily record reviews of law enforcement reports in order to submit required data per state and federal guidelines.  Crime Analyst will analyze patterns in criminal behavior in order to assist in closing investigations by arrest, predict patterns and motives of criminals, and improve the responsiveness of law enforcement agencies.

DISTINGUISING FEATURES OF THE CLASS

This classification is generally a non-sworn classification; however, depending on the needs of the Sheriff’s Office, the position may also have sworn staff assigned.  System Administrator ensures the records management database and other law enforcement databases remain secure and only authorized access is allowed per departmental policy while reporting our statistical data to local, state and federal agencies in accordance with pre-established guidelines.   This position also requires good organization skills, the ability to follow directions given from supervisors, and the ability to work independently and without continuous direct management on multiple simple/complex tasks while displaying good judgement and decision-making skills.  

Crime Analyst is involved in uncovering and piecing together various bits of information about crime patterns, crime trends, and criminal suspects.  Crime Analyst exercises considerable independent judgement in completing data analyses with the ultimate outcome of increasing the effectiveness of patrol deployment and criminal investigations.  The individual assigned to this position will have considerable interaction with departmental members, other administrative staff, vendors representing companies, and the general public.   

DUTIES AND RESPONSIBILITIES

Essential duties and responsibilities include, but are not limited to:

• Serves as System Administrator for records management systems and other law enforcement databases which are maintained by local, state, and federal agencies.
• Monitor system performance and troubleshoot issues as they arise.
• Collaborate with IT support staff and vendors to support projects and resolve issues.
• Manage user accounts, permissions, and access control.
• Generate SQL queries to records management systems.
• Extract data from records management systems. 
• Research, analyze and compile data from a variety of sources; utilize modern research methods, including frequency distribution, research design, and statistical analysis to identify and evaluate crime series, trends and patterns, and victim and suspect profiling.
• Collect and analyze crime reports, arrest data, modus operandi information, field interview information, citation information, and other crime and criminal related data.
• Prepare and distribute crime information bulletins, informational reports, and trend analysis reports to departmental sections and agencies from other jurisdictions.
• Develop, collaborate, and foster good working relationships with other criminal justice agencies in order to further criminal investigations and the ability to share pertinent information in a timely manner.
• Conduct training and information sessions with department staff and members of the public on crime analysis as required.
• Develop computer programs to collect, retrieve, and analyze criminal information.
• Participate in the formulation and implementation of a directed patrol program using crime analysis information as the basis of deployment. 
• Assist in answering FIOA requests in accordance with laws.  
• Perform related duties and responsibilities as required or directed by supervisors.

RECRUITMENT STANDARDS

Knowledge, Skills and Abilities 

Knowledge of

• Basic organization and functions of municipal law enforcement and criminal law related to crime analysis and dissemination of confidential information.
• Advanced mathematics and routine statistical and algebraic formulas sufficient to develop hypotheses and extrapolate data and modern research techniques including research design and statistical analysis. 
• Quantitative analysis methodology and report writing techniques to prepare graphs, tables, and statistical charts; gather, assemble, analyze and evaluate facts and evidence and draw logical conclusions and make proper recommendations.
• Public organizations and fiscal management; applications of various computer software programs, including spreadsheet, database, word-processing, graphics, and GIS mapping.
• Communication techniques, both verbal and written skills, sufficient to interact with all levels of personnel including departmental members and the general public.
• The English language and grammar sufficient to interpret comprehensive reports and various data types and comprehend oral and/or written material and instructions.
• Modern Sheriff's methods and procedures related to crime prevention and crime analysis.
• Computer skills in both hardware and peripheral components and with various proprietary statistical, word processing, database, graphics, and spreadsheet software.
• Both State and Federal law enforcement reporting guidelines.

Skills and Ability to

• Interpret and apply oral and/or written material and instructions; interpret and apply laws and regulations; prepare clear, concise, and comprehensive reports.
• Prepare graphs, tables, and statistical charts; gather, assemble, analyze and evaluate facts and evidence, make logical conclusions, and make appropriate recommendations.
• Develop and maintain a computerized automated crime information system; use computer hardware and software to retrieve data from internal and external sources, download data from remote sites, and develop reports as needed.
• Work independently toward meeting organizational goals in the absence of specific directions.
• Establish and maintain working relationships with peers, other agencies, and public officials; communicate effectively, both verbally and in writing, with all levels of personnel including public officials and be able to represent the County and the Sheriff’s Office in meetings with other agencies.
• Attend and complete relevant training courses as required.

MINIMUM QUALIFICATIONS

Preferred Qualifications

• Knowledge and experience operating Central Square Records Management Systems, Jail Management System, and Computer Aided Dispatch (CAD).
• Experience with development and operation of SQL queries.
• Experience with creating reports using Excel and Crystal Reports, and Microsoft Office Suite.
• Experience with NCIC and DCI. 
• Knowledge of the Paytel system. 
• Experience in law enforcement databases that include, but are not limited to CAD, CJLEADS, NCLINX, P2P, P2C, idicore, CLEAR, and Clearview Facial Recognition.
• Working knowledge of Requests for Proposal (RFP) and state purchasing/budgetary guidelines
• Good public speaking skills.
• Ability to prioritize multiple tasks and work as a team on complex long term projects.
• Knowledge of Real Time Crime/Information Center Operations.
• Working knowledge of NIBRS reporting.
• Database administration experience. 

Physical Demands

Must be able to physically perform the basic life operational functions of stooping, kneeling, reaching, standing, walking, pushing, pulling, lifting, fingering, grasping, feeling, talking, hearing and repetitive motions.   Must have visual acuity to perform tasks requiring color, depth perception, and field of vision sufficient to perform tasks associated with the preparation and analysis of figures and data, operation of a computer, and operation of a motor vehicle.  Must be able to perform 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.   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.

Working Conditions 

Most work is in an office environment managing law enforcement databases, communicating with departmental members on database access/needs, and analyzing crime information.  Work may require travel to alternate locations that include, but are not limited to, Courthouses, Detention Centers, GM911, and other county buildings.  Occasional travel out of town for training and meetings may be required on an as needed/required basis.   

Driving is Essential

While travelling to alternate locations for work is rare, driving is an essential requirement of this position.  Motor Vehicle Reports may be verified for valid driver’s license and that the driving record is compatible with the county’s driving criteria as an employee of the Guilford County Sheriff’s Office.  

If a personal vehicle is operated for county business proper insurance is maintained as per Guilford County’s vehicle use policy. 

Special Note

This generic class description gives an overview of the job class, its essential job functions and recommended job requirements.  However, for each individual position assigned to this class, there is available a completed job description with physical abilities checklist which can be reviewed before initiating a selection process.  They can provide additional detailed information on which to base various personnel actions and can assist management in making legally defensible personnel decisions.

Guilford County is committed to providing Equal Employment Opportunity (EEO) to employees and applicants for employment regardless of color, religion, sex, national origin, age, disability, genetic information, sexual orientation or political affiliation.  The County is committed to complying with all applicable federal, state and local laws that pertain to employment, and to providing a work environment that is free from discrimination of any kind. If you need an auxiliary aide, make the request forty-eight (48) hours in advance of the time the accommodation is needed by calling 336-641-3324.