Accounting Analyst

DEFINITION:

Under general direction of the Finance Director, the Accounting Analyst leads and coordinates the City’s financial analysis, budget development, treasury functions, and financial system administration.

This position serves as the primary owner of budget management, treasury operations, grant coordination, and financial system administration.

ESSENTIAL FUNCTIONS:

· Primary responsibility for financial analysis, reconciliation, and system oversight

· Leads and coordinates preparation of the City’s annual operating and capital budgets

· Develops revenue and expenditure forecasts

· Monitors budget performance and identifies variances

· Maintains budget models and tracking tools

· Prepares formal budget reports and projections

· Prepares cash flow forecasts

· Monitors pooled cash balances

· Prepares and posts journal entries and maintains general ledger structure, including chart of accounts integrity.

· Prepares and distributes monthly and periodic financial reports for internal management, departments, and governing bodies

· Prepares interest allocation calculations

· Prepares and maintains cost allocation methodologies and interfund allocations, as applicable

· Supports development and monitoring of interdepartmental charges and cost recovery mechanisms

· Performs complex accounting and financial analysis

· Coordinates and manages the month-end and year-end close process, including timelines, reconciliations, and required entries

· Develops and maintains documentation of financial processes, procedures, and workflows

· Performs monthly bank and pooled cash reconciliations

· Prepares financial forecasts, projections, and analytical reports

· Performs periodic reconciliation of revenue collections to billing systems, departmental reports, and general ledger

· Coordinates audit preparation activities, including preparation of schedules, workpapers, and audit request tracking

· Serves as functional administrator for Tyler ERP Pro 10

· Maintains system configurations

· Supports budget module setup

· Troubleshoots system issues and coordinates with vendor

· Tracks grant expenditures and budgets

· Monitors reimbursements

· Ensures compliance with grant requirements

· Performs reconciliation of payroll liabilities and reviews compliance with CalPERS and regulatory reporting requirements.

· Owns and reconciles all major City revenue streams, including taxes, permits, licenses, utility billing, and intergovernmental revenues, ensuring alignment between source systems, general ledger, and bank activity.

· Ensures financial transactions, reporting, and processes comply with established policies, procedures, and regulatory requirements

· Monitors contract expenditures, encumbrances, and compliance with approved budgets and agreements

· Coordinates grant closeout activities, including final reporting, reconciliation, and compliance verification

· Integrates revenue trends and collection data into ongoing budget forecasts and financial projections

· Prepares or reviews financial components of staff reports, council agenda items, and fiscal impact analyses

· Provides analytical support for utility rate studies, fee updates, and cost-of-service evaluations

· Identifies, researches, and resolves accounting discrepancies, errors, and audit findings

· Coordinates financial workflows and deadlines across accounting functions to ensure timely processing, review, and reporting

· Provides limited backup support across finance functions

· Provides financial analysis and support to departments, including expenditure tracking, revenue analysis, and budget guidance

· Exercises independent judgment in the application of accounting principles, financial analysis, and system administration.

· Performs duties in accordance with established internal control procedures, including segregation of duties, review and approval requirements, and audit compliance standards

KNOWLEDGE/SKILLS:

Knowledge

· Principles of budgeting, accounting, and financial recordkeeping.

· Governmental accounting standards and public sector financial practices.

· Financial reporting and audit processes.

· Internal controls and compliance requirements.

Skills

· Strong analytical and problem-solving skills.

· Ability to analyze data and identify trends or discrepancies.

· Proficiency in Microsoft Excel and financial analysis tools.

· Ability to prepare clear and concise reports.

· Strong organizational skills and attention to detail.

· Ability to communicate effectively, both orally and in writing.

· Ability to work collaboratively with staff across departments.

· Ability to perform complex financial and analytical work with limited supervision.

· Ability to manage multiple assignments and meet deadlines.

· Ability to provide technical guidance without formal supervisory authority.

EDUCATION & EXPERIENCE:

· Bachelor’s degree in accounting, finance, business administration, or a related field is preferred.

· 4 plus years of experience in budgeting, accounting, or financial analysis is desirable.

· Public sector experience is highly desirable but not required.

· Valid California Driver’s License may be required.

This job description is not intended to be all-inclusive. The employee may also perform other reasonably related duties as assigned. The City of Guadalupe provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression or any other characteristic protected by federal, state, or local laws.

Pay: $39.96 - $53.55 per hour

Benefits:

• Dental insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid sick time
• Paid time off
• Retirement plan
• Vision insurance

Work Location: In person