Crime Analyst I - SFPD (1822)

  • Full-time
  • Work Hours: Regular
  • Job Code and Title: 1822-Administrative Analyst
  • Fill Type: Permanent Exempt

Company Description

Who We Are: The San Francisco Police Department was established in 1849 and continually strives to become a more effective, inclusive and modern police department, while earning the trust and pride of those we serve and those who serve.  Our goal is to reflect on current SFPD initiatives, assess best practices across the country, and evaluate the changing environment in policing and within the City to arrive at a strategy statement that the Department and our community can embody every day.

The San Francisco Police Department stands for Safety and Respect for All. We will engage in just transparent unbiased and responsive policing. We will do so in the spirit of dignity and in collaboration with the community. And we will maintain and build trust and respect as the guardians of Constitutional and human rights.

The San Francisco Police Department is committed to excellence in law enforcement and is dedicated to the people, traditions and diversity of our City. The department provides service with understanding, response with compassion, performance with integrity and law enforcement with vision. The department has grown into a nationally known police department providing law enforcement services to one of the most recognized cities in the United States.

Specific information regarding this recruitment process are listed below:

  • Application Opening: September 27, 2022, Reopening on March 9th to allow for further recruitment. 
  • Application Deadline: Apply immediately, announcement may close anytime after March 23, 2023.
  • Class & Compensation: $94,900 - $115,362
  • Recruitment ID: PEX-1822-126022 What does this mean?
  • Work Location: SFPD Headquarters, 1245 3rd Street, San Francisco, CA 94158
  • Work Schedule: Monday - Friday, 9:00am – 5:00pm, Telecommuting work schedule available inline with CCSF policy.

Job Description

Under the general supervision of the Manager of Crime Analysis Unit (CAU), 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.  The Crime Analyst I will provide case support through various analytical methodology both tactical and operational.  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:

  • Performs analytical research, compilations and statistical analysis from information /data on crime and a variety of administrative, management, and organizational issues.
  • Identifies issues and determines analytical standards in consultation with supervisor, manager, departmental personnel and other individuals/experts.
  • 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).
  • 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, cellphone analysis and other computerized materials).
  • Obtain and maintain certification and training as needed for subject matter expert.
  • 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.
  • Be able to testify in court.
  • Presents reports, make oral presentations and briefings to stakeholders as needed to include court presentations.

Performs related duties and responsibilities 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 of 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.

SUBSTITUTION:  Applicants may substitute up to 2 years of the required education with additional qualifying experience in crime data analysis, statistical analysis, 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 data analysis, development and administration; complex statistical analysis and reporting; development of complex database systems; 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 criminal justice, public or business administration, management, business law, public policy, economics, statistical analysis, or other fields of study closely related to the essential functions of positions in Class 1822.

Desirable Qualifications & Experience:

  • Intermediate-level proficiency in MS Office Suite applications such as Excel, Word, PowerPoint, Adobe and/or other database software.
  • Knowledge of Power BI, Dashboards and Sharepoint.
  • Knowledge of relational databases including querying, editing, and manipulating data across multiple tables (SQL, Access or related backgrounds).
  • Experience working crime data within a law enforcement environment, using a variety of analytical techniques, complex problem-analysis or intelligence-analysis which includes research methods.  Possession of professional analytical training at the local, State or Federal level preferred. 

The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.

Verification of Education and Experience: Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements

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.

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.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

Applications completed improperly may be cause for ineligibility or disqualification.

Background Investigation: 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.

San Francisco Police Department (SFPD) job applicants would need to provide official verification consistent with the City's COVID-19 policy they are "Fully Vaccinated/Full Vaccination" before they can advance to the required Background Process phase of the recruitment process. "Fully Vaccinated" and "Full Vaccination" mean two weeks after completing the entire recommended series of vaccination (usually one or two doses) with a vaccine authorized to prevent COVID-19 by the FDA, including by way of an emergency use authorization, or by the World Health Organization (WHO). For example, an individual would be fully vaccinated at least two weeks after receiving a second dose of Pfizer-BioNTech or Moderna COVID-19 vaccine or two weeks after receiving the single dose of Johnson & Johnson COVID-19 vaccine. This SFPD specific COVID-19 vaccination applicant requirement supersedes the City's general COVID-19 vaccination new hire requirement.

Additional Information

Recruiter Information: If you have any questions regarding this recruitment or application process, please contact the Staff Services analyst, Danny Wan at [email protected].

Additional Information Regarding Employment with the City and County of San Francisco:

SFPD Recruitment: https://www.sanfranciscopolice.org/your-sfpd/careers

HOW TO APPLY

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.

  1. Select the “I’m Interested” button and follow instructions on the screen

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.

Privacy Policy