Crime Analyst 1, SFPD
Title:Crime Analyst 1, SFPD
Post Date:09/01/17
Location:San Francisco, CA
Details:This is a Position Based Test conducted in accordance with Civil Service Commission Rule 111A.

Under supervision the 1822 Administrative Analyst (Crime Analyst I) is responsible for performing detailed and sensitive professional-level analytical work that supports the Crime Analysis Unit (CAU) through use of various databases, business intelligence, and geographical information system (GIS) functions in the San Francisco Police Department. The Crime Analyst I incorporates research methodologies, statistical analysis, data analysis, forecasting, trending and GIS mapping strategies that result in the development, preparation and compilation of crime trends and patterns to disseminate information through a variety of reports and makes recommendations related to potential crimes, location of future crimes, possible suspects and forecasting of future criminal events. This journey level position requires an individual with a range of skills including technical ability, analytical thinking, and interpersonal skills. It requires appropriate handling of sensitive information, multi-tasking and prioritization skills. In all areas self-initiative and innovative thinking are preferred and encouraged.
The essential duties of this position include, but are not limited to:
1. Performs analytical research, compilations and statistical analysis from information /data on crime and a variety of administrative, management, fiscal and organizational issues.
2. Identifies issues and determines analytical standards in consultation with supervisor, manager, departmental personnel and other individuals/experts.
3. Gathers relevant data, information and /or documentation from a variety of sources through the creation and maintenance of databases and files on criminal and various activities tracked by the Crime Analysis Unit (CAU).
4. Analyzes information and documentation and develops tentative findings through preparation of analytical products (charts, graphs, maps, tables such as link analysis, network analysis, time flow, telephone toll and other computerized materials).
5. Discusses and/or coordinates analysis and tentative findings as liaison with supervisor, management staff and/or other appropriate individuals.
6. Gathers additional information and/or revises methodology as needed. Geographic information system (GIS) analysis incorporated to generate crime maps, and perform spatial analyses of hot spots and crime drivers- supporting District and City efforts in crime reduction.
7. Writes or assist in writing final reports and documentation for evaluation by administrative and/or management staff.
8. Presents reports, including formal presentation to groups and various stake holders.
9. Performs other related duties as assigned.
Qualifications:1.Possession of a graduate degree (Master's degree or higher) from an accredited college or university; and one (1) year full-time equivalent experience performing professional-level analytical work, as described in Note A; OR

2. Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework as described in Note B; OR

3. Possession of a baccalaureate degree from an accredited college or university, and two (2) years full-time equivalent experience performing professional-level analytical work as described in Note A; OR

4. Possession of a baccalaureate degree from an accredited college or university with major coursework as described in Note B and one (1) year full-time equivalent experience performing professional-level analytical work as described in Note A;


5. Special Condition: This position requires one (1) year of recent and verifiable

GIS Applications and Tools experience (within the past 5 years).

The above minimum qualifications reflect a special condition associated with the position to be filled that may differ from the standard minimum qualifications associated with this class code.

SUBSTITUTION: Applicants may substitute up to 2 years of the required education with additional qualifying experience in budget analysis, financial analysis and reporting, legislative/policy analysis, or contract/grant administration. One year (2000 hours) of additional qualifying experience will be considered equivalent to 30 semester units/45 quarter units.

Notes on Qualifying Experience and Education:
A. Qualifying professional-level analytical experience must be in one or more of the following functional areas: complex budget analysis, development and administration; complex financial/fiscal analysis and reporting; development of complex contracting systems and administration of competitive bid processes and complex contractual agreements; development and evaluation of complex management/administrative policy; complex grant administration and monitoring; complex program evaluation and planning; complex legislative analysis; complex crime data analysis; complex economic analysis; or other functional areas related to the duties of positions in Class 1822, where the primary focus of the job is complex professional-level analysis for evaluation, recommendation, development and implementation of major programs and functions of department/organization. Analytical experience equivalent to the duties of Class 1820 is considered qualifying.

B. Coursework applicable to a baccalaureate or higher degree in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, criminal justice, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in Class 1822.

Desirable Qualifications

The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

Intermediate-level proficiency in MS Office Suite applications such as Excel, Word, PowerPoint, Adobe and/or other database software.
Knowledge of relational databases including querying, editing, and manipulating data across multiple tables (SQL, VBA, Access or related backgrounds).
Two years verifiable criminal intelligence experience in law enforcement or military environment.
Experience working on active series or crime problems within a law enforcement environment, using a variety of analytical techniques, complex problem-analysis or intelligence-analysis which includes research methods, crime theory, and process evaluation. Possession of professional analytical training at the local, State or Federal level preferred.
Comments:Salary $78,546 - $95,498

Applications for City and County of San Francisco jobs are being accepted through an online process. Visit to register an account (if you have not already done so) and begin the application process.

Select the desired job announcement 1822 Administrative Analyst(Crime Analyst I)(PBT-1822-076930)
Select “Apply” and read and acknowledge the information
Select either “I am a New User” if you have not previously registered, or “I have Previously Registered"
Follow instructions on the screen
Employer:San Francisco Police Department
Contact:Micki Callahan, Human Resources Director
Phone: (415)837-7382
Website:visit our website...