Finance & Accounting Intern — Budget & Analytics

City Utilities of Springfield; Town of Springfield (WI); On-site; USD 26,000 - 30,000; Part time

Job summary

City Utilities of Springfield invites you to join our finance team as an intern. This role is designed for students, with 20-25 hours per week during school semesters and 40 hours/week in the summer, capped at 1,500 hours per year.

Pay ranges from $17.00 to $20.00 per hour and depends on classification. Under the supervision of the Financial Analyst, you will help prepare the Annual Operating Budget and Operating Plan, collect data, run monthly reconciliations, and support budget reporting.

Qualifications

• Accounting, Computer Information System, Economics, or Business-related major is required from an accredited college or university.
• Minimum of one year of college that includes at least six hours of accounting related courses.
• Six months of recent progressively responsible accounting or general office work preferred.
• Experience with Excel macros and/or Business Intelligence software is preferred.

Responsibilities

• Assist in the maintenance of Operating Plan reporting layouts and standard reports.
• Assist in the maintenance of project management reporting system in PeopleSoft, including responsibility for project setup and maintenance, preparation and maintenance of the project reporting layouts, distribution of reports to project managers, and reconciliations to the general ledger.
• Develops monthly budgeted financial statements and updates these to be reflective of approved transfers. Prepares budgeted financial data for all accounting reports and generates computer files for various system generated reports. Responsible for maintaining monthly budget reporting layouts.
• Supports data collection and analysis for Forecasting material used to advise the determination of financial solutions for the Annual Operation Plan.
• Provides support for the preparation of the Annual Operating Budget and Operating Plan. Assists in preparing Budget and Operating Plan presentations and supplemental materials.
• Analyzes monthly financial statements for deviations from budget and presents results to supervisor.
• Actively supports all Finance goals, processes, and standards.
• Performs other related duties as required or assigned by management.

Skills

Office etiquette

Interpersonal skills

Problem solving

Education

Accounting, CIS, Economics, or business major

Tools

Excel macros

Business Intelligence software

PeopleSoft

Job description

City Utilities of Springfield invites you to join our finance team as an intern. This role is designed for students, with 20-25 hours per week during school semesters and 40 hours/week in the summer, capped at 1,500 hours per year.

Pay ranges from $17.00 to $20.00 per hour and depends on classification. Under the supervision of the Financial Analyst, you will help prepare the Annual Operating Budget and Operating Plan, collect data, run monthly reconciliations, and support budget reporting.