Accountant/Business Analyst Water Resources Department

Description 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.
The position is integral to the Department of Water Resources Accounting Division that supports financial reporting, budget planning and monitoring, statistical presentations, cost of service studies, rates and fees.
Individual should be a well-organized individual who can independently perform and plan appropriately cyclical processes and deadlines to be performed monthly, quarterly and annually.
Salary is negotiable based on qualifications and experience.
The City offers competitive benefits .
Check out our benefits! The City of Lynchburg is an Equal Opportunity Employer and encourages everyone to apply.
Essential Duties 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.
Maintain and update department’s chart of accounts as needed.
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.
Monitor miscellaneous receivables for delinquencies and report to supervisor to help determine next steps.
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 on certified payroll reports.
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.
ADDITIONAL DUTIES AND RESPONSIBILITIES include the following: Depending on work assignment, may be required to perform a variety of duties in support of operational requirements and direct citizen service delivery such as acting as a back-up to other staff and response to weather-related and other emergencies, such as snow removal.
May be required to work outside of normal work hours, to report to work during inclement or unusual weather or other conditions or to respond in other abnormal situations.
Other duties to provide direct or indirect service to the citizens may be assigned.
When unusual situations occur and/or the City Manager declares a State of Emergency, all City employees may be required to accept special assignments and perform as needed to ensure appropriate service delivery.
Minimum Education and Experience Required 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 Depending on work assignment, may be required to have a valid driver's license issued by the Commonwealth if Virginia and acceptable driving record according to City criteria.
Relevant background checks must be completed and approved.
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.