Company Description
The San Francisco Adult Probation Department is an integral partner in the City’s criminal justice system and contributes to public safety through its court services, supervision and treatment referral functions. The San Francisco Adult Probation Department supervises approximately 6,000 clients on court-ordered supervision, diversion programs and post release community supervision (PRCS).
Job Description
This posting is for a Permanent Exempt (PEX), Full-Time position not to exceed three (3) years. This position is excluded by the Charter from the competitive civil service examination process, is considered "at will," and shall serve at the discretion of the appointing officer.
Position 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:
• 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, and eLearning 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, Documents Management, eLearning and Risk Management solutions 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 APD’s CMS, Documents Management, eLearning and Risk Management systems.
• Conduct APD’s 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.
• 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 and maintaining it; lead data migration activities and hands-on data mapping
• 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, Microsoft Active Directory management and Linux administration.
Qualifications
MINIMUM QUALIFICATIONS
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.
Education
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].
Experience
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.
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 one of the fields above or a closely related field.
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.
• Extensive hands-on experience in data migration between enterprise systems.
• Proficiency with SQL Scripting and GO Language programming
• Hands-on knowledge of Docker Container, GitHub and PostgreSQL database
• Extensive hands-on experience of PHP and HTML with jQuery programming, Microsoft Active Directory management and Linux administration.
• 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.
Additional Information
SUPPLEMENTAL INFORMATION
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.
Selection Procedures
After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process.
Supplemental Questionnaire Evaluation (Weight: 100%)
Candidates who meet the minimum qualifications will be sent a Supplemental Questionnaire. The Supplemental Questionnaire is designed to measure the knowledge, skills and abilities required for this position. All candidates’ responses to the Supplemental Questionnaire are subject to verification. All relevant experience, education and/or training must be included in the responses in order to be reviewed in the rating process.
A passing score on the Supplemental Questionnaire must be achieved in order to advance in the interview process.
Note: Only those applicants meeting the minimum qualifications will be notified of the exact date, time and place for the examinations. Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.
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.
