2022/07/26 City Council Resolution 2022-084 RESOLUTION NO. 2022-084
ADOPT A RESOLUTION APPROVING THE POSITION TITLE, SALARY RANGE,
AND ASSOCIATED JOB DESCRIPTION FOR AN ENTERPRISE RESOURCE
PLANNING SYSTEM ANALYST,AND RECLASSIFYING A SENIOR ACCOUNTING
TECHNICIAN TO AN ENTERPRISE RESOURCE PLANNING SYSTEM ANALYST
WHEREAS, staff has reviewed the needs of the Finance Department and is proposing
creating the role for an Enterprise Resource Planning (ERP) System Analyst to assist with
financial system administration and related functions; and
WHEREAS, the Senior Accounting Technician is performing functions that are part of
the proposed role; and
WHEREAS, staff developed the position description, job title, and salary range for an
ERP System Analyst based on an internal classification and compensation study.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Rohnert
Park that it does hereby authorize and approve the position title, salary range and associated job
description for an ERP System Analyst, attached hereto as Exhibit "A" and incorporated by this
reference,and the reclassification of the Senior Accounting Technician to an ERP System Analyst
in the Finance Department.
BE IT FURTHER RESOLVED that the Finance Director or Designee is hereby
authorized to make necessary changes to the City's budget for Fiscal Year 2022-23 to effectuate
the proposed changes.
DULY AND REGULARLY ADOPTED this 26th day of July, 2022.
CITY OF ROHNERT PARK
S tha Rodriguez, Vic May
ATTEST:
Elizabb th Machado, Assistant City Clerk --�
Attachment: Exhibit A
GIUDICE: A HOLLINGSWORTH-ADAMS:Po...ie STAFFORD: ch.AP RODRIGUEZ: ELWARD:
AYES: (5 ) NOES: (0 ) ABSENT: ( ri) ABSTAIN: (X)
EXHIBIT “A”
ERP SYSTEM ANALYST
Proposed Salary Range 51 CF: $92,312.36 - $112,205.81
DEFINITION
Under general supervision, performs a variety of professional level duties in the design, development,
implementation, maintenance and user support for the City’s Enterprise Resource Planning (ERP) and
timekeeping systems in response to business needs for all City departments; provides specialized
accounting support for payroll and accounting functions including accounts receivable, accounts payable,
utility billing, and business licensing; and performs related duties, as assigned.
SUPERVISION RECEIVED AND EXERCISED
Receives general supervision from the Finance Director. Exercises no direct supervision of staff. Exercises
technical and functional direction over and provides training to lower-level staff.
CLASS CHARACTERISTICS
This is a single position class responsible for managing multiple modules within the ERP application,
creation and maintenance of table driven business rules and other sophisticated application configuration
requirements, creation of automated workflows and complex reports. This classification requires a unique
combination of business (human resources, payroll, finance, accounting, budgeting) application specific
functional knowledge and technology skills required to configure, test, train, control and maintain the ERP
system. Responsibilities include translating business requirements into automated business processes and
ensuring ERP functionality is working as designed; evaluating additional and enhanced functionality in
order to streamline business processes for end users; writing procedures and training documents; providing
technical support to City staff; providing specialized accounting support.
This class is distinguished from Information Systems Analyst in that the latter requires technology-based
expertise in areas such as design, construction, analysis and maintenance of application software
programs and codes, hardware platforms and equipment, and designing, programming, and coding,
without the functional business expertise in areas such as the general ledger, billing, procurement,
accounts payable/receivable, cash receipts, bank management, budget management, human resources,
time tracking, payroll, financial reporting and regulatory reporting.
EXAMPLES OF ESSENTIAL JOB FUNCTIONS (Illustrative Only)
Management reserves the right to add, modify, change, or rescind the work assignments of different
positions and to make reasonable accommodations so that qualified employees can perform the essential
functions of the job.
Responds to employee requests regarding Munis software support, including training, troubleshooting,
and identifying available reports and services.
Requests technical support from Munis for issues covering finance, human resources/payroll, utility
billing/licensing and system issues; coordinates service with Munis support, tests fixes, notifies City
staff of outages and system changes; notifies IT of suggested upgrades and system fixes.
Creates and generates system reports, utilizing CUBES and SSRS reporting tools as needed, to address
needs of staff using Munis.
ERP System Analyst
Page 2 of 4
Administers changes to Munis workflow and employee permissions in Munis RBAC, both for new
employees and system workflows and changes to existing employees’ permissions.
Creates and tests new pay codes in Munis; supports HR/Payroll staff in understanding new codes and
existing code functionality
Assists Payroll staff with special payroll situations and reporting needs.
Imports, reviews and reconciles daily deposits from TRAKiT.
Creates journal entries to transfer funds for internal permits and developer deposit draw-downs, as
detailed in TRAKiT reports.
Creates and maintains import template from TRAKiT to Munis; coordinates GL changes with
Development Services to support ongoing imports.
Assists Accounting Technicians, Accounting Assistants, and Utilities Services Representatives with
special/unique situations in utilities, licensing, accounts receivable and customer service.
Provides data for miscellaneous requests from Finance and other departments, including Public Records
Requests.
Coordinates and reviews creation and editing of annual Winter Average/Sewer Cap for all residential
and multi-family utility customers.
Attends training, provides documentation, tests functionality and works with Tyler consultants as
needed; tests set up and program functionality, trains staff.
Supports integration of Munis with other software, including Tyler Payments
Performs other duties as assigned.
In performing the duties described above, the incumbent is expected to:
• Provide outstanding and friendly customer service.
• Create and maintain a respectful and collaborative working environment.
• Communicate honestly and behave in a manner that is ethical, legal and fiscally responsible.
• Demonstrate care for the organization, customers, and coworkers.
• Perform work of the highest quality possible.
• Practice and encourage initiative and innovation to improve the workplace.
QUALIFICATIONS
Knowledge of:
ERP system modules and business processes in finance, budgeting, human resources, payroll and time
entry.
Software as a Service (SaaS) and cloud-based applications regarding overall capabilities from a
customer’s perspective, including roles and responsibilities of the vendor versus the customer
organization.
Problem diagnosis and troubleshooting techniques.
Procedures and methods for testing business functions within ERP and timekeeping systems.
Principles and practices of providing functional direction and training.
Principles and practices of general ledger, billing, procurement, accounts payable/receivable, cash
receipts, bank management, budget management, time tracking, payroll, financial and regulatory
reporting.
Terminology and practices of accounting and financial document processing and record-keeping,
including utility billing, accounts payable, and/or accounts receivable.
Computerized accounting and finance systems and computer software and systems related to finance
and payroll processes; other computer applications related to work, including word processing and
spreadsheet software.
Payroll reporting and payment requirements of various State and Federal agencies and benefit
providers.
ERP System Analyst
Page 3 of 4
Applicable Federal, State, and local laws, regulatory codes, ordinances, and procedures relevant to
assigned area of responsibility, including the City’s various Union Memoranda of Understanding and
related contracts and documents.
Principles and practices of auditing accounting and payroll documents.
Techniques for providing a high level of customer service by effectively dealing with the public,
vendors, contractors, and City staff.
Modern office practices, methods, and computer equipment and applications related to the work.
English usage, spelling, vocabulary, grammar, and punctuation.
Ability to:
Analyze problems, identify alternative solutions, project consequences of proposed actions, and
implement recommendations in support of goals.
Provide instruction to end-users in person, over the phone or via email.
Detect and direct application/system problems to appropriate technical support.
Create custom reports by compiling, organizing and interpreting data.
Define and document business requirements and procedures.
Read, understand, analyze, interpret and apply ERP system manuals, written materials and statistical
data.
Work closely with staff to maintain a high level of integrity and confidentiality when dealing with
sensitive and complex payroll issues.
Establish, maintain, and research payroll and related accounting records and files.
Make accurate arithmetic, financial, and statistical computations.
Enter and retrieve data from a computer with sufficient speed and accuracy to perform assigned work.
Establish and maintain a variety of filing, record-keeping, and tracking systems.
Understand, interpret, and apply all pertinent laws, codes, regulations, policies and procedures, and
standards relevant to work performed.
Effectively represent the department and the City in meetings with governmental agencies; community
groups; various business, professional, and regulatory organizations; and in meetings with individuals.
Independently organize work, set priorities, meet critical deadlines, and follow-up on assignments.
Communicate clearly and concisely, both orally and in writing, using appropriate English grammar and
syntax.
Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal
guidelines.
Establish, maintain, and foster positive and effective working relationships with those contacted in the
course of work.
Operate modern office equipment including computer equipment and specialized software applications
programs.
Use English effectively to communicate in person, over the telephone, and in writing.
Education and Experience:
Any combination of training and experience that would provide the required knowledge, skills, and abilities
is qualifying. A typical way to obtain the required qualifications would be:
Equivalent to a bachelor’s degree from an accredited college or university with major coursework in
business administration, public administration, accounting, finance, or a related field and three (3) years of
experience in business system analysis, design or management, or related experience. Specific experience
with Munis software is highly desirable.
Licenses and Certifications:
ERP System Analyst
Page 4 of 4
Possession of a valid California Driver’s License by time of appointment and a satisfactory driving
record.
PHYSICAL DEMANDS
Must possess mobility to work in a standard office setting and use standard office equipment, including a
computer; vision to read printed materials and a computer screen; and hearing and speech to communicate
in person, before groups, and over the telephone. This is primarily a sedentary office classification although
standing, walking and/or driving a motor vehicle between work areas may be required. Finger dexterity is
needed to access, enter, and retrieve data using a computer keyboard or calculator and to operate standard
office equipment. Positions in this classification occasionally bend, stoop, kneel, reach, push, and pull
drawers open and closed to retrieve and file information. Employees must possess the ability to lift, carry,
push, and pull materials and objects weighing up to 10 pounds.
ENVIRONMENTAL ELEMENTS
Employees work in an office environment with moderate noise levels, controlled temperature conditions,
and no direct exposure to hazardous physical substances. Employees may interact with upset staff and/or
public and private representatives in interpreting and enforcing departmental policies and procedures.
FLSA Status: Exempt
Employee Unit: Confidential
Approved By:
Date Approved: