1822 Administrative Analyst (SFDA Research Analyst)

Recruitment #TEX-1822-073262


1822 Administrative Analyst

SFDA Research Analyst


Appointment Type: This is an exempt appointment. Pursuant to the City & County of San Francisco Charter, Section 10.104.13, any person occupying a position under exempt appointment shall not be subject to civil service selection, appointment and removal procedures. Exempt employees shall serve at the pleasure of the appointing officer. The exempt employee must participate and be successful in a Civil Service examination process and be selected through an open competitive recruitment process to be considered for a permanent appointment.


Department Background

The San Francisco District Attorney's Office is one of the most respected and innovative prosecutor’s offices in the United States. Our mission is to promote justice by fostering accountability and repairing harms by using data-driven, evidence-based approaches. In addition, what sets our office apart is our dedication to addressing root causes of crime and preventing recidivism; our centering of crime victim and survivors; and our commitment to eliminating racial and class inequities in the criminal legal system—including through reduced reliance on incarceration. Our office engages in public education and crime prevention efforts while maintaining the traditional role of investigating, charging, and prosecuting all criminal violations occurring within the City and County of San Francisco. The unparalleled opportunities for challenging, meaningful, and sophisticated work have consistently drawn top candidates to our office over the years.


As a sub-team within the SFDA’s Policy Division, the Data and Analyst Team is a multidisciplinary group of researchers, crime analysts, and data scientists that leads a range of analytic projects in support of the office’s larger mission and vision. Projects range from partnerships with academic institutions to conduct primary research into issues related to criminal justice reform to internal and external reporting via data dashboards to tactical crime analysis to support community safety initiatives.


Position Description

Under general direction in the Director of Data, Research, and Analytics, the SFDA Research Analyst is responsible for conducting qualitative and quantitative analytical work in support of the SFDA’s policy and research agenda. Essential duties include but are not limited to:

  • Collaborate with internal and external partners to develop, oversee, and implement research and evaluation projects related to key issues in criminal and juvenile justice, such as diversion, pretrial detention, victim services, hate crimes, and other;
  • Design and implement qualitative and quantitative research projects to support internal operational improvements and policy priorities;
  • Prepare and present written reports, presentations, and statistical reports, including charts, graphs and other data visualizations to attorneys, criminal and juvenile justice system partners, and City of San Francisco decision-makers;
  • Maintain performance measurement metrics and dashboards for managers and executive staff;
  • Study current literature on prosecutorial performance measurement, research methodology, criminology, law enforcement issues, juvenile justice, etc. and make appropriate recommendations for improvements in data-driven prosecution practices;
  • Perform other related duties, as assigned.

Knowledge, Experience and Skills Preferred

  • Highly proficient in Microsoft Excel and PowerPoint. Experience with SPSS or R statistics suite encouraged but not required.
  • Ability to identify, research, and gather relevant information from a variety qualitative, quantitative, and text-based sources; read and interpret complex written materials; analyze and evaluate data, procedures, interrelated processes and other information; formulate conclusions and/or alternatives and develop effective recommendations.
  • Experience with data visualization in Excel, Power BI or Tableau to clearly present analytical results.
  • Skill to prepare and present written reports, memos, presentations, and detailed statistical reports, including charts, graphs, and exhibits to trial attorneys, law enforcement partners, and decision-makers.
  • Organizational ability to manage multiple projects, meet deadlines and expectations, and weigh resources and time bandwidth of current and upcoming responsibilities.
  • Communication ability to effectively formulate reports and recommendations, provide presentations, and work collaboratively with internal and external partners including law enforcement professionals and decision-makers.

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.


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 of Qualifying Experience and Education

Note 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 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.


Note 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, 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 following desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring:


  • Advanced degree in public policy, sociology, criminology or other relevant field..
  • Professional experience working for a criminal justice agency.
  • Professional experience working in a policy research organization.
  • Knowledge and familiarity of programming languages such as R, SQL, Oracle, etc.
  • Knowledge and familiarity of statistical analysis applications such as Stata, SPSS, and ArcGIS.


Security clearance is required as a condition of employment. Candidates for employment with the District Attorney's Office are required to undergo a background investigation to determine suitability for employment in the classification and department. Failure to maintain security clearance may be the basis for termination from employment with the District Attorney's Office.

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
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • 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 Department of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.


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 recruitment analyst, Richard Ng, by email at richard.ng@sfgov.org



All applicants may be required to submit verification of qualifying education and experience at any point in the application, recruitment and /or departmental 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 http://sfdhr.org/index.aspx?page=456


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. For additional information regarding verification, refer to this web URL: http://www.sfdhr.org/index.aspx?page=20#verification

Selection Procedures

The selection process will include evaluation of applications in relation to minimum requirements. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to comparatively evaluate the qualifications of candidates. If this becomes necessary, only those applicants whose qualifications most closely meet the needs of the Department will be invited for an interview.



1. Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at web URL:



2. Applicants are advised to keep copies of all documents submitted. Submitted documents become a permanent part of the exam record and will not be returned. The hiring department may require applicants to present additional material at the time of appointment and/or at a later date.


3. For general information concerning City and County of San Francisco employment policies and procedures, please refer to this web URL: http://sfdhr.org/information-about-hiring-process


4. For Right to Work policy, please refer to this web URL: http://sfdhr.org/information-about-hiring-process#identification


5. Terms of Announcement: 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. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at www.jobaps.com/sf.


ISSUED: 07/02/2021

EXTENDED: 07/14/2021





DAT/RN 628-652-4041

Conviction History

As a selected candidate 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 selected candidate. 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 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 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 a selected candidate, 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.


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