Crime Analyst I - SFPD

Wednesday, August 23, 2017 11:13 AM | Mōno Simeone (Administrator)

     1822 Administrative Analyst

Crime Analyst I

Recruitment #PBT-1822-076930

Department Police
Analyst Ada Dupree
Date Opened 8/11/2017 4:00:00 PM
Filing Deadline 8/25/2017 10:00:00 AM
Salary $78,546.00 - $95,498.00/year
Job Type Permanent PBT
Employment Type Full-Time

Go Back Click HERE to apply Click HERE to view benefits



Amended on 08/18/17 to change the filing deadline to 08/25/2017. 


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.

Minimum 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:
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.  

How To Apply

  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 

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

You can also watch this video for further assistance with our online application system:

Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date.  Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter.  To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (,,,,,,,

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file.  Applicants should retain this confirmation email for their records.  Failure to receive this email means that the online application was not submitted or received.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

A RESUME DOES NOT SUBSTITUTE for the EMPLOYMENT RECORD section of the application. This section MUST BE COMPLETED.


If you have any questions regarding this recruitment or application process, please contact the exam analyst, Ada Dupree, by telephone at (415) 837-7256 or by email at



Applicants may be required to submit verification of qualifying education and experience at any point in the application, examination and/or departmental selection process.  Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Copyright © 2012 Bay Area Automated Mapping Association (BAAMA); all rights reserved
Powered by Wild Apricot Membership Software