Campus Police, Data Analyst

PRIMARY FUNCTION: This position is responsible for criminal analysis duties in support of the Board of Education’s Campus Police department in relation to criminal investigations functions. This position is responsible for performing routine and complex data analysis, generates both standard and ad hoc reports, and designs methods for better understanding and analysis of data.

REPORTS TO: Administrative Lieutenant

SALARY SCHEDULE: A-5

WORK DAYS: 250

REQUIREMENTS:

Education Level: Bachelor’s degree in Information Technology or related field.

Preferred: Bachelor's degree in Computer Science with emphasis on data mining and analysis

• Experience, Skill, and Certification:

• Three or more years of demonstrated experience gathering data requirements and performing data analysis on student information systems in a large-scale, multi-user environment.
• Strong problem solving, analytical, and design skills and have the abilities to identify data and data model.
• Abilities to identify data and data model inconsistencies and conflicts.
• Ability to examine data and understand inter-relationships and correlations using deductive and inductive reasoning.
• Must be detail-oriented, a team player, and possess excellent organizational and time management skills. Skill in planning, organization, and decision making.
• Experience with spreadsheets, database design/management, and reporting/analysis tools, such as but not limited to Excel, Access, SQL, Business Objects. Ability to use common office machines and popular computer-driven word processing, spreadsheet and file maintenance programs.
• Strong interpersonal communication skills - ability to work well and to get along with a variety of customers and other technical personnel. Ability to establish and maintain effective working relationships as necessitated by work assignments.
• Strong verbal and written communications skills -ability to write comprehensive reports, conduct presentations, training sessions, and meetings.
• Comprehensive knowledge of the principles and theorIes of database systems technology.
• Ability to maintain complete and accurate records and to develop meaningful reports, charts and graphs from them.
• Familiar with school system financial and human resource procedures.
• Skill in developing research designs, data storage strategies, program evaluation techniques and data analysis methods.
• Skill in designing data collection instruments such as surveys.

Preferred:

• Extensive experience working with MS SQL and reporting tools.
• Experience in a K-12 student information systems environment.
• Experience with client/server and Web based architectures.
• Experience with Net development.
• Experience with project management.

ESSENTIAL DUTIES:

• Performs intelligence analysis; aids in clarification of instances with multiple student involvement; assists in the investigation of allegations of criminal incidents per Board of Education policies and departmental procedures.
• Monitor and analyze all instances of criminal activity and juvenile delinquency. Assist in developing crime prevention programs to deter criminal or delinquent activities. Identifies crime patterns.
• Utilizes technical tools to identify patterns and data trends. Prepares charts, illustrations, and narrative reports to identify and explain data pattern and trends. Prepares documents for publication and presentation. Creates support documentation outlining procedures.
• Performs data auditing and validation to ensure accuracy of system data. Provides quality control reports to customers and training team for correction and follow up.
• Performs imports/exports and data conversion from multiple sources/systems for the manipulation of large data sets.
• Ensures issues and/or discrepancies are identified, tracked, reported on, and resolved in a timely manner.
• Creates process maps and diagrams to show workflow.
• Participates in project teams and work with a variety of customers to identify needs and solutions.
• Responsible for preparing, generating, and publishing routine and ad hoc reports/ metrics for the customers as well as conducting training on use.
• Participates in and analyzes information for annual budget requests.
• Participates in special projects, including grant writing. Assists in researching and preparing grant applications for funding; manages administrative paperwork necessary to implement grant; maintain contracts and modifications.
• Maintains documentation on system processes and procedures.
• Collaboration with other departments: Working closely with SRO's, law enforcement officers, Criminal Investigation Unit, Detectives, and other law enforcement agencies to provide necessary records for investigations.
• Gang Data Analysis:

Data Collection and Management: Overseeing the collection and organization of gang-related data in schools, including arrest records, incident reports, and intelligence gathered from various sources.

Trend Analysis: Analyzing gang activity trends to assist law enforcement in understanding gang dynamics, identifying hotspots, and anticipating potential conflicts or criminal activities.

Collaboration with Law Enforcement: Working closely with SROs, gang units, and CIU investigators to provide data- driven insights that support operations and investigations.

15. Social Media Monitoring:

Surveillance and Data Collection: Monitoring social media platforms for criminal activity, threats, or gang-related communications, and ensuring that this data is accurately recorded and securely stored.

Content Analysis: Analyzing social media data to identify patterns, connections, and emerging threats to schools related to gang activity or other criminal behavior.

Reporting and Communication: Compiling reports on findings from social media monitoring, and sharing relevant information with SROs, CIU, law enforcement officers, and other stakeholders to inform decision-making and operational strategies.

16. Performs other duties as necessary for the effectiveness of the organization.

TERMS OF EMPLOYMENT

Incumbents will be considered “at will.” Appropriate pay will be determined based on the Grade as determined by Human Resources and allowable experience. This is a 250-day position. (EXEMPT, A-5) Rev. 01-2025

NON-ESSENTIAL RESPONSIBILITIES

A responsibility is considered to be “non-essential” (for the purposes of compliance with the Americans with Disabilities Act) if:

• it is shared between multiple incumbents in the job; or
• it could be performed by an employee in another job within the workgroup.

Note the responsibility number from the list in the “Duties and Responsibilities” section for those responsibilities that could be considered “non-essential” based on this definition.

Certain limited aspects of General Duties and Responsibilities items referenced in Section 1 (b) and (d) might be considered “non-essential” in a specific situation. Any request for accommodation must be reviewed on an “individual case” basis.

PHYSICAL AND SENSORY DEMANDS

Most jobs in the District have physical and sensory demands that can be described by one of the two categories noted below. For jobs that require more physical or sensory effort, please list the requirements in this section. The category applicable for this position is listed below.

[X] OFFICE Employees in this category are normally exposed to a typical environment. The employee has some control over the length of time sitting, standing, or ambulating. There are occasions that require the lifting or pulling of equipment or supplies, as well as bending, stooping, or stretching. There is frequent use of computers, telephone, and other standard office equipment, which includes reading, listening, writing, or speaking. There are few exceptional physical or sensory demands.

[ ] CLASSROOM Employees in this category spend at least most of the workday in a typical classroom or related educational environment. There will be prolonged periods of standing or walking, and there may be frequent bending, stooping, or stretching. There are occasions that require the lifting or pulling of equipment or supplies. Reading, listening, writing, and speaking are requirements. There are few exceptional physical or sensory demands, but there may be occasions that require the lifting or restraint of a student.

EXCEPTIONAL PHYSICAL OR SENSORY DEMANDS

(Check any that apply to this job and complete the required information.)

[x ] Heavy lifting of up to __25____ pounds

[ ] Frequent climbing up to _______ feet, and/or working on building roofs.

[ ] Exposure to heavy dust, dirt, chemical or paint fumes, or other airborne matter.

[ ] Exposure to extreme heat, electric current, hazardous chemicals or other potential hazards.

[ ] Sitting or standing for extended periods with no control over rest periods.

[ ] Other:______________________________________________________