Financial Professional II

Job Title

The Department of Water Resources of City of Lynchburg is seeking a self-motivated individual who enjoys a variety of duties that includes but not limited to accounting and analytical work of budget performance for three enterprise funds.

This is a full-time position and offers medical, dental, vision, retirement and paid-time off benefits

Salary Range: $59,009.60 - $76,003.20

Essential Duties

Essential duties and responsibilities include the following:

• Assist in processing of quarterly financial reports for three operating funds that summarizes budget vs. projected performance.
• Provide written narratives for group presentation purposes reasons when revenue and expense categories are over or under budget.
• Process journal entries that are monthly, reoccurring, and as needed for corrections.
• Monthly reconciliations for balance sheet accounts and revenue accounts.
• Review invoices and credit card transactions for proper general ledger coding.
• Update written procedures as needed for tasks within the accounting division.
• Be integral player in gathering data for projecting over 80 revenue streams and over 500-line item expenses from different sources that include statistical data and discussions with key individuals associated with revenue streams and expenses.
• Monitor and analyze revenue accounts and expense accounts monthly and report any unusual or negative trends.
• Implement and provide summary schedules as support for proposed budget line item expenses.
• Be an accounting and budget resource to department supervisors.
• Prior to annual budget submission to city budgeting department prepare budget worksheets and documents for final department review.
• Maintain financial and statistical tables for water, sewer and stormwater funds to be used for graphing trend analysis and timely report changes that are materially impacting revenues or expenses.
• Prepare audit work papers as required to support balance sheet account balances, required accruals, explanations of variances that meet selected thresholds and etc.
• Input all details of new assets purchased into the financial system and reconcile back to general ledger.
• Maintain monthly cost report for a large customer to support reimbursement billing.
• Conduct surveys of rates and fees of neighboring communities.
• Maintain vehicle and equipment depreciation schedules used to determine necessary reserves to fund future replacements.
• Assist in internal audits to verify invoiced unit pricing agrees with contract unit pricing.
• Reconcile payroll hours in work management system to payroll system.
• Reconcile all field costs in work management system to general ledger.
• Reconcile parts received in and distributed from the warehouse to the general ledger.
• Assist in the annual procurement for parts used in field operations.
• Gather inputs used on calculations for cost of service studies that justify fees and rates charged to customers.
• Review for compliance certified payroll reports on federally funded projects. Provide correspondence to general contractors as needed to maintain compliance.
• Assist capital project accountant as needed to balance workload in department water resources accounting division.
• Provide administrative assistance as needed in water resources accounting division.

Minimum Education and Experience Required

Qualifications to perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Education and experience:

• BA or BS in accounting or related field (concentration in accounting preferred).
• Have working knowledge and proper application of GAAP and GASB.
• Proficiency in Microsoft Excel that includes building and maintaining macros, using VLOOKUP's, creating pivot tables and building graphs independently.
• Compile data into an organized and meaningful format.
• High degree of professionalism and communicates well effectively with internal and external customers.
• Solid communication skills both written and oral.
• Values the importance of maintaining positive and effective working relationships.
• Solid organizational skills to prioritize work.
• Ability to think logically for best approach for needed solutions.

Additional Requirements

• Valid driver's license and acceptable driving record according to city criteria.
• Must successfully complete IS100 and IS700 National Incident Management (NIMS) training within 90 days of employment. May also be required to complete higher levels of NIMS training as determined appropriate for the position.