1822 Administrative Analyst (Crime Analyst I)

Crime Analyst I

Recruitment #PBT-1822-076930



Amended on 08/25/17 to change the filing deadline to 09/15/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 www.jobaps.com/sf 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 (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com).

    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, Danielle Poole, by telephone at (415) 837-7282 or by email at danielle.poole@sfgov.org.



    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.

    Selection Procedures

    Written Core Examination (Weight: 70%)

    Candidates will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The “core” multiple-choice examination component may include but not be limited to:

    • Ability to evaluate/analyze information/data and to exercise good judgment relative to that evaluation or analysis;
    • Ability to communicate written information (includes ability to proofread);
    • Knowledge of, and ability to apply, financial/fiscal principles (including the ability to use mathematical and statistical formulas);
    • Ability to comprehend and understand written information;
    • Ability to use various computer software programs;
    • Ability to conduct research;
    • Ability to establish and maintain cooperative and effective working relationships;
    • Knowledge of, and the ability to apply, principles, practices and procedures involving office operations;

    This is a standardized examination and, therefore, test questions and test answers are not available for public inspection or review.

    You will receive one or more scores with respect to the multiple-choice exam component. One will correspond to the core test component and, should any specialty subtests be added to that component, you may receive one or more additional “specialty” scores. Any scores attained on these components will be valid and 'banked' for three years, starting from the date of the examination. This means that, during this three-year time period, you will not be required to take any test components for which you have already attained a score. This core test is also used for 1820 Junior Administrative Analyst, 1822 Administrative Analyst and 1823 Senior Administrative Analyst therefore your test scores  may be applied to one or more of these classes if you choose to apply to future recruitments. This is not the same exam that is used for 1824 Principal Administrative Analyst, as such your scores on this exam are not applied to any 1824 recruitments, and your scores from the 1824 exam cannot be applied to this recruitment. If the selection process for the future announcement is held within one year of the date of this examination and it includes any of these components [i.e., core exam or specialty subtest(s)], your score(s) for the corresponding test component(s) will be automatically applied to that announcement. However, after one year, you have the option to either (a) apply your test score(s) to the other announcement or (b) re-take the test component(s). Re-testing is permitted no sooner than one year from the date of the examination and only in association with your eligibility for another announcement for which the test component (core or specialty subtest) is used. Please note that, should you re-test, your re-test score would become your official score since it is the most recent.

    Candidates must pass the written “core” examination in order to move forward in the examination process.


    Oral Written Examination (weight 20%) 
    Candidates will be tested to determine their relative knowledge, skill and ability levels in the 1822 Administrative Analyst, Crime Analyst I job-related areas including: Ability to identify, research and gather relevant information from a variety of sources; Ability to analyze and evaluate data, procedures, interrelated processes and other information; Ability to formulate conclusions and/or alternatives and develop effective recommendations; Knowledge of Arc GIS/ ESRI Products.


     Written Examination (weight 10%)


     Candidates will be tested to determine their relative knowledge, skill and ability levels in the 1822 Administrative Analyst, Crime Analyst I job-related areas including: Knowledge of analysis of existing and proposed legislation, legal standards and regulatory mandates; Ability to identify, research and gather relevant information from a variety of sources; Ability to read and interpret complex written materials; Ability to analyze and evaluate data, procedures, interrelated processes and other information; Ability to formulate conclusions and/or alternatives and develop effective recommendations; Ability to use work-related computer applications, including e-mail, word processing, spreadsheets, databases and the internet; prepare well-organized and accurate documents such as reports, memos, and correspondence; Ability to synthesize ideas and factual information into clear and logical written statements.


     A passing score must be achieved on all test components to be placed on the eligible list. 


    The certification rule for the eligible list resulting from this examination will be Rule of Ten

    Scores. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.


    Eligible List:

    The eligible list resulting from this examination is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.
    Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list resulting from this announcement may be used by other departments that also use this classification or a similar classification.  To find other Departments which use this classification, please see.
    .  Search that document by title or job code to see which departments use the classification.


    The duration of the eligible list resulting from this examination process will be of twelve (12) months, and may be extended with the approval of the Human Resources Director.


    Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.


    Background Investigation (Qualifying): 
    Prior to employment with the San Francisco Police Department, a thorough background investigation will be conducted to determine the candidate’s suitability for employment. The investigation may include, but not be limited to: criminal history records, driving records, drug/alcohol screening, and other related employment and personal history records. Reasons for rejection may include use of controlled substances and alcohol, felony conviction, repeated or serious violations of the law, inability to work with co-workers, inability to accept supervision, inability to follow rules and regulations or other relevant factors. Candidates may be required to undergo drug/alcohol screening, and must clear Department of Justice and Federal Bureau of Investigation fingerprinting. Criminal records will be carefully reviewed; candidates who do not report their complete criminal records on their applications will be disqualified. Applicants will be fingerprinted.


    Conviction History

     As a finalist for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a finalist. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:


    • Candidates applying for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
    • Candidates applying for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

    Having a conviction history does not automatically preclude you from a job with the City.

    If you are selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment. 



    Disaster Service Workers

    All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.


    Terms of Announcement and Appeal Rights:

     Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. [Note: The correction of clerical errors in an announcement may be posted on the Department of Human Resources website at www.jobaps.com/sf


    The terms of this announcement may be appealed under Civil Service Rule 111A.35.1.  The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis” for establishing the position description, the minimum qualifications and/or the certification rule.  Appeals must include a written statement of the item(s) being contested and the specific reasons(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director.  Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date. Information concerning other Civil Service Commission Rules involving announcements, applications and examination policies, including applicant appeal rights, can be found on the Civil Service Commission website at http://sfgov.org/civilservice/rules.

    Reasonable Accommodation Request: Applicants with disabilities requiring reasonable accommodation for this process must contact Penny Si by phone at (415) 837-7221 or if hearing impaired, (415) 575-6082 (TTY), or by e-mail to penny.si@sfgov.org as soon as possible.


    Veteran’s Preference:


    General Information concerning City and County of San Francisco Employment Policies and Procedures:
    Important Employment Information for the City and County of San Francisco can be obtained at
    http://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor.

    Seniority Credit in Promotional Exams:
    Information regarding seniority credit can be found at:


     Right to Work:
    All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States. http://www.sfdhr.org/index.aspx?page=20#identification


    Civil Service Commission Rules for the City and County of San Francisco specify announcement, application and examination policies and procedures, including applicant appeal rights. Information can be found on the Civil Service Commission website at http://sfgov.org/civilservice/rules.






    Exam Type: CPE
    Micki Callahan, Human Resources Director
    Department of Human Resources

    Issued: August 11,  2017

    Recruitment ID Number: PBT-1822-076930

    POL/DP (415)837-7382

     Women, Minorities, and Persons with Disabilities are encouraged to apply


    An Equal Opportunity Employer


    All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

    For more information about benefits, please click here.


    Powered by JobAps