Budget and Revenue Analyst

Department(s): Neighborhood Services

FLSA: Non-UnionExempt

Employment Status: Full-time

Annual Salary/Grade: $67,143 - $97,357.00/Grade 4

Anticipated Hiring Range: $67,143 - $82,251 /- DOQ/Grade 4

Pay Grade: 4

Class specifications are intended to present a descriptive list of the range of duties performed by employees in the class. Specifications are not intended to reflect all duties performed within the job.

DEFINITION

Serves the public with professional administrative and analytical duties in the areas of budget preparation, purchasing, payroll, data analysis and process improvement. Provides, prepares and maintains records, and financial and statistical reports and analysis which assist in the Village’s ability to improve business processes and gain efficiencies through better use of technology. Budget duties include assisting in the development, analysis and application of performance measures with regard to Village services and resources; preparing, modifying, tracking and monitoring Village expenses and transfers; and conducting budget-related research and analysis. Financial duties relate to assisting in the maintenance of bank accounts, reconciliation of general ledger accounts, and preparation of funds for audit, audit follow-up and purchasing and providing administrative oversight and assistance in department payroll.

SUPERVISION RECEIVED AND EXERCISED

Receives general administrative direction from the Department Director or designee.

EXAMPLES OF DUTIES - Essential and other important duties and responsibilities may include, but are not limited to, the following:

Essential duties and responsibilities:

1. Provides highly complex administrative support to assigned departments during all phases of the budgeting process including preparation of the department level annual budget requests, yearend revenue and expenditure estimates, multi-year forecasting, review of department submissions, analysis, and budget monitoring. Communicates with Departments regularly during all phases of the budget process. Respond in a timely manner to request from CFO and Village Manager.

2. Assists department(s) in developing, tracking and submitting statistical reports and performance measures with regard to Village services and resources; analyzes and applies performance measures in the budget process to improve Village services and utilize Village resources (money, work effort and time) more efficiently and effectively.

3. Audits and proofs accounting/budget & revenue reports for numerical and grammatical accuracy. Establishes and maintains a variety of files and records in a logical and organized manner. Prepares, copies, and forwards budget and revenue materials.

4. Assist with and audit payroll activity for assigned department including maintaining personnel and payroll records; processing paperwork for personnel actions including, new hires, change in status, and termination; and provide appropriation forms to staff; observe confidentiality on all payroll and personnel matters.

5. Department representative in the collective bargaining process as the subject matter expert on the application of CBA language to payroll process and budget impact.

6. Keeps informed on resolutions and ordinances additions and changes pertaining to the operation; suggests and implements improvements in ordinances and regulations as it relates to revenues and expenditures.

7. Evaluates operational methods of purchasing internal and external goods and services to determine efficiency of operations. Implements approved changes by updating current written procedures and practices, and communicate those changes to Department. Provide assistance to Department with purchasing matters as needed.

8. Prepares reports and recommendations to the assigned departments or Village Manager on bids and Requests for Proposals. May develop specifications for the purchase of goods and services.

9. Assists with the preparation of financial statements and related schedules for various funds for audit. May assist with audit financial statement notes, as required.

10. Assists with the timely month-end closings and provides other departments with financial and budget reports on a monthly basis (or mandate monthly?). Maintains up-to-date chart of accounts. May reconcile several bank accounts and generates monthly journal entries for several Funds.

11. Attends meetings to furnish information and record meeting minutes. Attends budget workshops and meetings as requested by supervisor.

12. Completes special projects and other related work as assigned.

13. Perform related duties and responsibilities as required.

14. Must have reasonable and predictable attendance.

QUALIFICATIONS: Required at time of hire and/or learned within a short period of time in order to successfully perform the assigned duties.)

Knowledge of:

· Municipal administration and management principles and practices.

· Operations, functions, policies and procedures of municipal budgetary assignments.

· Generally Accepted Accounting Principles (GAAP) and practices, as applied to general government accounting and related systems and procedures.

· Collective Bargaining Agreements (CBA’s); their application and their potential budget impact. Enterprise fund accounting and capital improvement fund accounting as required by the position.

· Payroll and Human Resource processes and procedures

· State and municipal purchasing laws, regulations and procedures.

· Computerized financial systems and their use in assigned accounting system or subsystems. Windows and Microsoft Excel, Outlook, PowerPoint and Word.

· Policy and process concepts.

· Methods to assemble, analyze, interpret, and organize financial and performance data. and/or other analytical tools.

· Report writing and document preparation, spelling, grammar and punctuation.

· Performance measures and their application to municipal operations and programs.

Ability to:

· Establish and maintain effective working relationships with a diverse group of individuals and staff throughout the Village.

· Prepare and maintain accurate and complete financial records and reports and prepare records in advance of external financial audits.

· Understand complex financial information to a broad audience with varying understanding of public budgets and finance.

· Develop project budgets and projections.

· Ability to proposed use of technology and efficient business processes to reduce operating costs.

· Read, understand and interpret manuals, ordinances, policies and procedures, statutes, rules, regulations, journals, newspapers, memoranda, letters, reports, financial reports, and legal documents.

· Perform a large volume of numerical detailed work accurately, make sometimes difficult mathematical computations.

· Work within restrictions and demands of deadlines, managing multiple projects and assignments; use principles of prioritizing and time management.

· Understand and follow complex oral and written instructions including technical terminology.

· Apply principles of logical or scientific thinking to define problems, collect data, establish facts, draw valid conclusions, and interpret a variety of technical instructions in mathematical or diagrammatic form.

· Make effective use of e-mail, scheduling software applications, mobile applications and Internet and web resources.

· Establish and maintain interpersonal skills in the workplace to effectively communicate and interact with others.

· Maintain reasonable and predictable attendance.

· Attend meetings and events before and after traditional work hours.

· Maintain physical condition appropriate to the performance of assigned duties and responsibilities which may include the following:

─ Walking, standing or sitting for extended periods of time

─ Operating assigned equipment.

Maintain effective audio-visual discrimination and perception needed for:

─ Making observations

─ Communicating with others

─ Reading and writing

─ Operating assigned equipment.

Experience and Training Guidelines

Experience: Four to six years accounting experience, preferably in a municipal environment;

AND

Training: Possession of a Bachelor’s Degree in accounting or closely related field from an accredited university is strongly preferred. Master’s degree in Public Administration and/or designation as a certified public accountant (CPA) are desirable, or a combination of experience and education that is equivalent. AND

License and Certifications: Possession of, or ability to maintain a valid Illinois driver license is required.

WORKING CONDITIONS

Work in an office environment; sustained posture in a seated position for extended periods of time.

Diversity Equity & Inclusion Statement

The Village of Oak Park commits itself to diversity, equity and inclusion by recognizing that creating a mutually respectful, multicultural and equitable environment does not happen on its own, it must be intentional. This includes providing equal opportunities for everyone regardless of race, ethnicity, gender identity, sexual orientation, religion, ability, military or veteran status or any other characteristics.

Job Type: Full-time

Pay: $67,143.00 - $97,357.00 per year

Benefits:

• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Retirement plan
• Tuition reimbursement
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Work Location: In person

Salary : $67,143 - $97,357