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.
Location: San Francisco, CA
Posted: Oct. 7, 2024, 9:31 a.m.
Apply Now Company Website