1053 IS Business Analyst-Senior

Recruitment #PBT-1053-082091



Applicants are encouraged to apply immediately as this recruitment may close at any time, but no earlier than December 29, 2017.

This is a Position Based Test conducted in accordance with Civil Service Commission Rule 111A.  


Department: The San Francisco Adult Probation Department is committed to Public Safety and Public Service. It is our goal to utilize the principles of community corrections to provide supervision and assistance to individuals on probation to achieve positive outcomes for the probationer and victims of crime in the community of the City and County of San Francisco.

Position Description

Under general direction of the IS Project Director this position will identify, develop and implement improvements to the Adult Probation Department’s (APD) systems and use tools such as SQL Server, Microsoft CRM, Power BI, SQL Reporting and ASP.NET to develop and make system changes to meet departmental needs.

 This position will be part of the APD IT team working on the implementation and support of Adult Probation Case Management System (CMS) and its integration with Correctional Offender Management Profiling for Alternative Sanctions(COMPAS) Risk/Need and to assure successful and timely implementation of this High priority project.

COMPAS Risk/Needs Assessment and Case Management System will enable APD to support the requirements of AB 109 legislation, fully implement Evidenced Based Probation Supervision Practices and comply with data requirements of the Senate Bill 678 (SB 678) and Administrative Office of the Courts CALRAPP programs.  The APD CMS business solution will improve probation outcomes, staff performance and provide the required level of automation for APD’s business processes and significantly improve access to public safety information for City Departments and Agencies.

Essential Duties:

§  Identify, develop and implement improvements for the Department’s business processes through automation for APD’s Case Management System (CMS).

§  Prepare proposals to develop new systems or enhancements to existing systems; conduct feasibility studies.

§  Interface with non-technical users to determine the business needs, independently research Department’s business rules and operations, and develop business and technical requirements for APD’s CMS and Paperless Electronic File systems and Systems’ interfaces.

§  Analyze the feasibility of and develop technical requirements for new systems and enhancements to existing systems; ensure the system design fits the users’ needs.  Write detailed design specifications; conduct "walkthroughs" for proposed solutions to system problems and enhancements.

§  Create Visio diagrams of APD’s business processes and other criminal justice partners.

§  Develop and assure proper planning, engineering, documentation, installation and testing of enhancements to meet end user requirements.

§  Develop functional, regression, acceptance and integration test plans and test case, and perform testing and quality assurance for application enhancements for CMS and Risk/Needs Management systems.

§  Conduct CMS and Risk/Needs Management systems upgrade and testing.

§  Create project plans and monitor the progress of project tasks, schedules and completion dates.

§  Support users during implementation or system upgrades and as needed in analyzing design issues and/or in troubleshooting issues.

§  Participate in the development and review of trainings and policy and procedure materials.

§  Analyze APD’s data processing needs; research and evaluate software that meets PROBSTATS and departmental goals.

§  Develop and support data warehouses, write complex SQL and PL/SQL queries; create business intelligence reports, T-SQL Programming, SQL Server database administration which includes managing securing, installing, configuring and maintaining,

§  Determine structure of databases; normalize data; perform conversion of data between platforms; design, develop and generate routine and ad hoc reports in response to user needs.

§  Perform .NET programming (C#, and/or VB.NET or PowerShell) and XML development modifications.

Minimum Qualifications

1.     An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field]: AND

2.     Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

Experience Substitution:
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units/forty-five (45) quarter units with a minimum of 10 semester/15 quarter units in computer science or a closely related field.

Desired Qualifications

·        Strong knowledge of the COMPAS Risk and Needs Assessment System and ability to perform administration and setup for this system.

·         Extensive and in-depth knowledge of Adult Probation business processes and procedures.

·        Knowledge of CTAG Case Management System.


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

How To Apply

Applications for City and County of San Francisco jobs are only 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 “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 Dept. 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, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu).

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.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Joron Coleman, by telephone at (415) 734-3015, or by email at joron.coleman@sfgov.org


Selection Procedures


Applicants will be prompted to complete the Supplemental Questionnaire that must be submitted during the online application process.  The Supplemental Questionnaire will be screened and scored for relevant qualifying experience. Only those applicants meeting the minimum qualifications will continue in the selection process. 

The final scores from the Supplemental Questionnaire will be used to determine the rank of candidates on the eligible list. Candidates will be placed on the eligible list in rank order according to their final scores.

*Candidate responses on the Supplemental Questionnaire cannot be changed once submitted.

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.

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.

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 http://www.sfdhr.org/Modules/ShowDocument.aspx?documentID=21246. Search that document by title or job code to see which departments use the classification.

The certification rule for the eligible list resulting from this examination will be Rule of Five(5) Scores.  Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

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.

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.


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://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.

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.

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

Reasonable Accommodation Requests:
Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: http://sfdhr.org/information-about-hiring-process#applicantswithdisabilities

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

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 reason(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.

Veterans Preference

Information regarding requests for Veterans Preference can be found at: 


Exam Type: CPE
Issued:  December 15, 2017
Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1053-082091
ADP/JC/ (415) 734-3015


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