Accounting/Finance Intern - Forecasting

City Utilities of Springfield, MO; Springfield (MO); On-site; USD 23,000 - 28,000; Part time

Job summary

City Utilities of Springfield, MO is seeking an intern to assist in preparing the Annual Operating Budget and Operating Plan. You will collect data, analyze, and prepare reconciliations under supervision.

The role requires enrollment as a full-time student, with 12+ credit hours for undergraduates or 6+ for graduates, and a schedule of 20-25 hours per week during the school term and up to 40 hours in summer.

Qualifications

• Accounting or business-related major required.
• Minimum of one year of college with at least six hours of accounting courses.
• Six months of accounting or general office work preferred.

Responsibilities

• Maintain Operating Plan reporting layouts and standard reports.
• Maintain project management reporting in PeopleSoft, including project setup and reporting layouts.
• Prepare monthly budgeted financial statements reflecting approved transfers.
• Support data collection and analysis for forecasting annual plan.
• Assist in preparing Budget and Operating Plan presentations and materials.
• Analyze monthly financial statements for deviations from budget and present results to supervisor.
• Support Finance goals, processes and standards.
• Perform other related duties as assigned by management.

Skills

Excel macros

BI software

Office procedures

Adaptability to new tech

Education

Accounting or related major

Six credit hours in accounting

One year of college with accounting courses

Tools

PeopleSoft

Microsoft Excel

BI tools

Job description

Connect to a career at City Utilities! CU has been connecting our community to the services they need for every day life since 1945. From electricity to power our lives, clean water to be healthy, natural gas to stay warm, internet to keep businesses connected, to transit services to get them where they need to go.

This position requires an employee to work between 20-25 hours per week during the school semesters, and 40 hours per week during summer, not to exceed 1,500 hours in a calendar year. Each semester, undergraduate students must be enrolled in at least 12 credit hours and graduate students must be enrolled in at least 6 credit hours.

INTERN GUIDELINES:

Students who have completed at least one year of college and are enrolled as a full-time student may apply. Must be enrolled full-time in a degree seeking program. A student's intern position will end within three months after graduation.

Pay Details:

$17.00 - $20.00/hour

Work Schedule:

Between the hours of Monday to Friday, 8:00am-5:00pm, 20-25 hours per week.

Job Description:

PURPOSE OF POSITION:

Under the direction of the Financial Analyst or designee, assists in the preparation of the Annual Operating Budget and Operating Plan. Assists in data collection and analysis. Prepares monthly reconciliations.

ESSENTIAL JOB FUNCTIONS:

1. 1. Assists in the maintenance of Operating Plan reporting layouts and standard reports.
2. 2. Assists 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.
3. 3. 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.
4. 4. Supports data collection and analysis for Forecasting material used to advise the determination of financial solutions for the Annual Operation Plan.
5. 5. Provides support for the preparation of the Annual Operating Budget and Operating Plan. Assists in preparing Budget and Operating Plan presentations and supplemental materials.
6. 6. Analyzes monthly financial statements for deviations from budget and presents results to supervisor.
7. 7. Actively supports all Finance goals, processes, and standards.
8. 8. Performs other related duties as required or assigned by management.

QUALIFICATIONS:

Education and Experience:

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.

Knowledge, Skills and Abilities:

• A working knowledge of office procedures, practices, and equipment.
• Must be able to maintain amicable working relationships with personnel at all levels.
• Ability to effectively utilize a range of digital tools and platforms, including but not limited to Microsoft Office Suite, enterprise software, artificial intelligence-enhanced applications, and self-service systems. Must possess a willingness and capacity to learn and adapt to emerging technologies, including mobile devices, cloud-based systems, and data-driven platforms relevant to utility operations.
• Maintain adherence to all company policies.

Physical Requirements:

Typically, sedentary work. Ability to express or exchange ideas by means of the spoken word and receive detailed information through oral communication. Substantial movements of the wrists, hands, and/or fingers, and close visual acuity to operate a computer is required.

Working Conditions:

Normal office environment.

Miscellaneous Requirements:

• New hires are informed of the requirements of the Internship Program upon hire, and incumbents must continue to meet the requirements each semester in order to continue employment. Interns who do not meet the requirements may be ineligible for the internship and their employment may be terminated.
• Employee must remain alert and aware of their surroundings at all times and maintain the ability to respond to changing circumstances in a timely manner.
• Must be able to work successfully with diverse groups of people.

TESTING

Testing may be required.

EEO

City Utilities offers equal employment opportunities to individuals without regard to race, color, religion, sex, sexual orientation, gender identity, ancestry, national origin, disability, age, veteran status, genetic information or marital status. Learn more about CU and EEO.