CIP & Budget Analyst

SUMMARY

Under general supervision from the Finance Manager, this position will cover a broad area of analyst responsibilities. The ideal candidate will be a good steward by nature who takes pride in and ownership of their work. Smooth operations and proper upkeep are a daily reflection of one’s ability to meet management’s expectations for such a self-motivator.

include the following. Other duties may be assigned.

• Track & reconcile Construction Projects monthly. Ensure invoices received for CIP Projects align with expectations and reconcile to past billings and payments.
• Assist in reviewing AP invoices weekly for accurate general ledger coding as it relates to budget.
• Send and track A/R invoices, including Inspection Invoices, Hydraulic Analyses, Impact Fees, Cut Lines, Tower Rentals, and others, monthly and as needed.
• Maintain the A/R Module in the Financial System.
• Maintain the Project Module in the Financial System.
• Perform month-end close related to Projects and Budget.
• Produce monthly Department Budget Reports for Managers each month.
• Perform monthly inventory receipt and disbursement process.
• Monthly collections reporting and maintenance as needed.
• Track Impact Fee payments received monthly and reconcile to the General Ledger.
• Prepare statistical information each month for the Finance Manager and Board meeting reports.
• Prepare Quarterly CIP Report for the Board meetings.
• Year-end inventory audit coordination. Assess inventory processes for areas of improvement.
• Responsible for Fixed Assets and associated depreciation schedules posted annually, as well as annual cleanup and audit of the Fixed Asset module and insurance schedules.
• Coordinate the annual auction of surplus property.
• Prepare CIP entries and reconciliations for the year-end audit, including booking of Construction in Progress, retainage, and completed projects as Fixed Assets.
• Assist with Single Audit at year-end, if a Single Audit is needed, in relation to federal project funding.
• Assist with annual budget preparation through Clear Gov, mid-year budget analysis, and other budget functions as needed, including the upload of the Annual Adopted Budget to the financial system.
• Enter journal entries in Incode 10 (ERP Pro 10) as needed in relation to CIP, A/R, Budget, and other assigned areas.
• Upload daily reporting to the Water Smart application.
• Submit Insurance Claims as needed related to Property and Liability.
• Assist with Purchasing functions to include cost estimates from Purchasing Cooperatives.
• Perform integrity reporting functions as deemed necessary to monitor assigned areas for accuracy.
• Analyze CIP metrics as needed for financial planning.
• Cross-trained in both Accounts Payable processing and Accounts Receivable daily payment processing performed by the Accounting Technician.
• Demonstrate a continuous effort to improve workflow processes, decrease turnaround times, and work cooperatively and jointly to provide a quality, seamless work product with co-workers and customers.
• Perform other duties as assigned.

• Capital Asset Accounting as it relates to Governmental Entities.
• Best Budgeting Practices as it relates to Governmental Entities.
• Maintain sufficient computer and office equipment skills.
• Incode 10 (ERP Pro 10) a plus.
• Purchasing a plus.

This job has no supervisory responsibilities.

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.

Bachelor’s Degree in…