CIP & Budget Analyst

Johnson County Special Utility District (TX); Joshua (TX); On-site; USD 60,000 - 75,000; Full time

Job summary

Johnson County Special Utility District in Joshua, TX is seeking a Finance Analyst to support accounting, budgeting, and financial reporting. Under supervision, you will track CIP projects, reconcile invoices, manage A/R and AP modules, and assist with month-end closes and budget preparation.

Candidates should have a Bachelor's in Accounting and 2–3 years of accounting/finance experience, plus strong Excel skills and familiarity with Incode 10 ERP.

Qualifications

• Bachelor’s degree in Accounting or related field required.
• 2–3 years of accounting, budgeting, and/or finance experience; government experience preferred.
• Proficient with Microsoft Excel; strong reconciliation and financial reporting skills.

Responsibilities

• Track & reconcile CIP projects monthly with invoices and past billings.
• Assist in reviewing AP invoices for accurate GL coding relative to budget.
• Send and track A/R invoices and related reports monthly.
• Perform month-end close related to Projects and Budget.
• Prepare monthly department budget reports for Managers.
• Enter journal entries in Incode 10 as needed.
• Assist with annual budget prep through ClearGov and upload to the financial system.
• Coordinate the annual inventory audit and fixed assets depreciation schedules.

Skills

Accounting

Budgeting

Financial reporting

Reconciliation

Communication

Excel

Time management

Policy interpretation

Attention to detail

Multi-tasking

Education

Bachelor’s Degree in Accounting or related field

Tools

Incode 10 (ERP Pro 10)

Job description

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.

ESSENTIAL DUTIES AND RESPONSIBILITIES

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 ClearGov, 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 WaterSmart 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.

KNOWLEDGE OF:

• 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.

SUPERVISORY RESPONSIBILITIES

This job has no supervisory responsibilities.

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/or EXPERIENCE

Bachelor’s Degree in Accounting, or a related business field, or Equivalent Work experience. At least 2-3 years of accounting, budgeting, and/or finance experience in a related field. Government experience is preferred.

SKILLS

• Communication verbal/written to exchange, inform, and interpret procedures.
• Establish positive working relationships with staff, Department Heads, Board Directors, vendors, and the public.
• Computer skills; 10-key by touch
• Organizational and problem-solving skills
• Knowledge of and ability to read and interpret policy and procedure manuals.
• Proficiency with Microsoft Excel
• Must have a good understanding of financial statements.
• Must have strong reconciliation skills to resolve errors.
• Must have advanced skills with Excel spreadsheets.
• Must possess good verbal and written communication skills.
• Skilled in dealing with statistical and financial data.
• Reasoning ability and problem-solving skills.
• Great time management skills.
• Effective organizational skills with attention to detail.
• A multi-tasker; able to determine daily work priorities and manage own workload.
• An exemplary work ethic; willing to work the hours necessary to get the job done to meet important deadlines.
• Work cooperatively with JCSUD executive management, co-workers, vendors, and members of the public.

LANGUAGE SKILLS

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from Department Heads, clients, customers, and the general public.

MATHEMATICAL SKILLS

Knowledge of basic accounting and bookkeeping principles and practices. Ability to work with mathematical concepts such as probability and statistical inference. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

REASONING ABILITY

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions for this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to stand; walk; sit; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl; talk or hear; and taste or smell. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions