Database & Systems Analyst (Finance)

The Department of Animal Services is recruiting for Business Process Analyst II, BPAII (working title: Database & Systems Analyst). In this role, the incumbent will serve as the Chameleon System Administrator (CSA), ensuring the seamless operation, maintenance, and development of the department's Chameleon animal shelter management system and other integrated applications. The incumbent will be responsible for system management, installation, and configuration while collaborating with Riverside County IT Department, vendors, and external partners to deploy upgrades, resolve technical issues, and maintain system integrity. Expertise in relational databases, user access management, and data validation will be critical in ensuring compliance with organizational policies and business processes. The incumbent will also oversee various Chameleon-related applications, including ChamCam, Chamrpt List Editor, KnowledgeRocket, PetHarbor, and payment portals, ensuring efficient operation and integration within the department.

The incumbent will support front counter operations, call centers, and licensing functions, ensuring adherence to department policies while troubleshooting issues related to rabies vaccination records, administrative citation programs, and contract city billing. Responsibilities will also include running financial and statistical reports, reconciling data discrepancies, and assisting department heads with system-related concerns. Success in this role requires the ability to assess technical issues, provide training, develop policies and procedures, and optimize system functionalities to enhance department-wide efficiency.

Competitive candidates will have strong technical expertise in relational databases, system administration, and troubleshooting. Experience in the public sector as a system administrator and/or knowledge of Power BI data management is also highly regarded.

Hybrid work schedule may be available based on business need after completion of onsite job training.

Meet the Team!

The Riverside County Department of Animal Services has a vision for promoting an environment of responsible pet ownership through progressive animal welfare initiatives, community outreach, and humane education in a culture of compassion, creativity, and integrity. The Department of Animal Services believes the character of their organization is best reflected in the strong dedication of each one of their employees who strive to meet the highest standards of performance and compassion on behalf of the animals and people that they serve. The Department of Animal Services operates four shelters located in Blythe, Jurupa Valley, San Jacinto and Thousand Palms.• Conduct system analysis and design of business process involving evaluation of current and proposed information; determine available and emerging technology hardware and software; provide cost and benefits analysis.

• Develop and document user requirements for new and existing systems, processes and applications; prepare and maintain project documents, requirements, reports, feasibility studies, and quality assurance for controls standards.

• Select and recommend software based on systems analysis, evaluation of products and vendors; create requests for proposals (RFPs) or requirement specifications.

• Serve as business process resource on all matters involving the support, maintenance, enhancement, and upgrade of the County and the Department's integrated enterprise systems; provide functional support, analysis and design specifications, as needed, to programming staff.

• Coordinate and participate in the design and evaluation of business processes required for the implementation of enterprise systems and upgrades; analyze new components to determine if previously modified processes can be eliminated and/or if new release will also require modification; conduct system testing to ensure that the new release provides the expected results throughout the business cycle.

• Evaluate requirements and develop design specifications for new or modified business processes; evaluate existing business process models to identify potential areas for automation and streamlining; design and implement resulting automated processes.

• Coordinate with Riverside County IT and departmental staff to adopt system changes needed for new/modified public programs and services; test all changes prior to final implementation to ensure appropriate results.

• Coordinate with user departments on new/changed local ordinances and labor agreements, legislation, reporting, and regulations.

• Design, implement and maintain system set-up tables and parameters to ensure compliance with state and federal requirements; interpret and analyze new or updated regulations to identify needed system changes.

• Identify and resolve production problem areas and correct system set-up when production errors are identified.

• Work directly with vendors to resolve underlying system program problems; search corporate web sites for posted resolutions and fixes in resolving identified problems.

• Coordinate and implement system security; coordinate network security and installation requirements.

• Maintain context-sensitive on-line help reference to reflect the most current structure within the system.Education: Graduation from an accredited college or university with a bachelor's degree in public/business administration, human resources, finance, computer science, information systems, or a related field to the assignment. (Additional qualifying experience in a functional support area may substitute for education on the basis of 30 semester or 45 quarter units equaling one year of full-time experience.)

Experience: Two years of professional level experience with business systems, information technology, program applications, business processes and procedures, and financial reporting and data, or other accounting experience. Experience must include building and running SQL query reports.

Knowledge of: Principles and practices of enterprise functions; project specifications development; application design; data modeling techniques; application of industry/corporate standards and conventions for systems analysis and quality assurance; installation, testing and migration process and techniques; quality and version control processes; the use of packaged, off-the-shelf and third party application software, including office automation tools; public assistance programs and C-IV application maintenance for positions within the Department of Public Social Services.

Ability to: Write/modify technical and user documentation; prepare flow process diagrams and other design graphics; use basic principles and practices and functional activities for the maintenance and enhancement of enterprise systems components; gather and analyze data; reason logically, draw valid conclusions and make appropriate recommendations; speak and write effectively; read, interpret and apply laws, rules, regulations, standards, and procedures; establish and maintain effective working relationships with others and gain their cooperation.This recruitment is open to all applicants.

Contact Amanda Duarte aduarte@rivco.org with any questions regarding this recruitment.