Skip to content

Career Opportunity

IS Business Analyst-Senior (1053)

Recruitment: REF7711D

Published: March 08, 2024


Janet MacEachern -
Michele Nieve -

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

Department: Adult Probation
Job class: 1053-IS Business Analyst-Senior
Salary range: $125,086.00 - $157,378.00
Role type: Permanent Exempt What does this mean?
Hours: Full-time


NOTE: This recruitment has been reopened due to an administrative change in the selection procedure. If you have already applied to this recruitment, you do not need to reapply.

Appointment Type: This is a Permanent Exempt (PEX), Full-Time position with an anticipated duration of up to three (3) years. This position is excluded by the Charter from the competitive civil service examination process and incumbents are considered “at will” and shall serve at the discretion of the Appointing Officer.

  • Application Opening: Wednesday, February 21, 2024
  • Application Deadline: Thursday, March 7, 2024

The San Francisco Adult Probation Department values the individuality and diversity of justice involved adults, recognize the unique challenges they face, and invest in their success through services designed to help them permanently exit the criminal justice system. We extend a continuum of integrated services to address our client’s criminogenic needs and empower them to become productive members of the community. SFAPD dedicates endless energy toward enhancing public safety, seeking victim restoration and accountability, providing structured and evidence-based supervision, all on the behalf of the Superior Court of San Francisco.

Role description

Under general direction of the IS Project Director this position will identify, develop and implement improvements to the Department’s systems and use tools such as SQL Server, , Power BI, SQL Reporting and Java to develop and make systems changes to meet departmental needs.

This position will be part of the APD IT team working on the implementation and support of Adult Probation (APD) Case Management and Documents Management Solutions and their integration with Risk/Needs Assessment, eLearning and Risk Management and to assure successful and timely implementation of this High priority project.

Risk/Needs Assessment, Case Management, Documents Management and Risk Management solutions 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 functions include but are not limited to:  

  • Identify, develop and implement improvements for  the Department’s  business processes through automation for Adult Probation Department (APD)’s Case Management System (CMS), Documents Management, eLearning and Risk Management solutions;
  • Prepare proposals to develop new systems or enhancements to existing systems; conducts 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, eLearning and Risk Management solutions 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, Risk Management 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 security, installing, configuring, 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), PHP programming, and HTML with jQuery, XML development modifications.  

    How to qualify

    These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification.  Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.


    An associate degree in information systems,  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 one of the fields above or a closely-related field].


    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.

    License and Certification:


    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 one of the fields above or a closely related field.

    Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

    Desirable Qualifications:

    The stated desirable qualifications will be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

    • Strong knowledge of the Risk and Needs Assessment, Risk Management, Probation or Public Safety Case Management Systems and ability to perform administration and setup for this system.
    • Proficiency with SQL Scripting and GO Language programming
    • Hands-on knowledge of Docker Container, GitHub and PostgreSQL database
    • Extensive and in-depth knowledge of Criminal Justice and Probation business processes and procedures.
    • Professional IS Business Analyst work experience in the Public Safety.
    • Advanced-level skills in analysis methodologies and techniques for operation support as well as requirements gathering, creation of functional specification, system and user testing techniques, process flow and diagramming.


    Essential duties require the following physical skills and work requirements: Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. May require hand/eye coordination for semi-skilled movements, such as taking apart casings, installing parts and reconnecting computers and for performing data entry. May involve extensive VDT exposure.

    What else should I know?


    Interviews:  Selected candidates will be invited to participate in one or more interviews at the Adult Probation Department Office.

    Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.

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

    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.