Accounting Analyst II - Financial Planning & Analysis Grants

PURPOSE OF POSITION :

Under the direction of the Manager - Financial Planning & Analysis or designee, is responsible for preparing financial statements and supporting schedules for the Operating Plan and Budgets.

Participates in the preparation of the Operating Plan and Budgets for a utility comprised of electric, natural gas, transportation, broadband, and water systems.

Serves as a financial liaison to operational project managers, including labor budget development, project analysis, budget preparation, forecast updates, financial training, education, and communication.

Performs financial analysis compared to the budget, develops project management reports, and financial reports and analysis for stakeholders.

Provides strategic alignment of goals with grant acquisitions and facilitates working groups to ensure successful attainment and administration of grants including required reporting regulations and compliance.

Responsible for managing responses to external funding opportunities and administering the complete life cycle of grants.

Assists cross functional departments and coordinates with subject matter experts on writing, submitting, and fiscal responsibility related to grants.

Supports completion of Single Audit requirements. Responsible for the financial planning, and related administration of, grants awarded to City Utilities for the electric, natural gas, water, and common segments.

ESSENTIAL JOB FUNCTIONS :

Participates in the preparation of Operating Budgets and Plans financial statements and maintenance of reporting layouts.

Processes data through General Ledger module including journal entries; cross-trains on month end allocation processes.

• Supports development and maintenance of financial budget model. Prepares projected financial scenarios, as needed to complete the Operating Plan, including the preparation, maintenance, and execution of system models.
• Supports preparation of the Operating Budgets and Plans, including compiling information received from all areas of the Utility and preparation of related presentations and supplemental materials.
• Assists with the project management reporting system in PeopleSoft, including project setup and maintenance, preparation and maintenance of the project reporting layouts, and distribution of reports to project managers.
• Supports preparation for the Schedule of Expenditures of Federal Awards (SEFA) and works with Transit Analyst to ensure all grants awarded to City Utilities are reviewed and appropriately included in the report.
• Coordinates Operating Budgets and Plans, in conjunction with grant applications and anticipated timing of receipts and expenditures.

Responsible for tracking capital and non-capital budget expenditures for grant funded projects. Responsible for coordinating timely completion of single audit, accruals, and budget carry-ins and reprojections.

• Supports Project Managers on grant funded projects with all aspects of financial management including development of a Request for Proposal (RFP) through completion of the projects.
• Serves as back up for Transit Grants Analyst including bank deposit reports and reconciliations. Reviews monthly Transit Statistics report related to revenues and ridership.
• Responsible for filing and administering the required documents under the rules and requirements for all non-Transit grants awarded.

Serves as the backup for preparation, execution and tracking of the reimbursement requests as well as ensuring the required progress reports are completed and filed timely.

Monitors project expenditures associated with grant funded projects to ensure the expenses qualify for reimbursement based on the guidelines of the grant agreement.

Reviews the completed reimbursement request using the method approved in the grant application. This includes working with Project Managers to ensure the expenditures are accurate and meet the requirements of the grant.

• Participates in ongoing training as an instructor and student related to grant management and grant administration.
• Reviews the allocation of project budgets into FERC account-based financial statements for historical expenditures and future projections.
• Learns and remains current on FERC regulations and GAAP guidelines and pronouncements for budget reporting.
• Provides backup to Financial Planning & Analysis Manager or team members as necessary and may assume additional responsibilities in their absence.

May supervise Interns.

Performs other related duties as required or assigned by management.

QUALIFICATIONS :

Education and Experience :

Bachelor's degree in Accounting, Finance, Economics, Business Administration, or a related field is required. Five years' recent progressively responsible experience in accounting, grant planning, or related field is required.

Two years of financial analysis, budgeting, financial planning, application for, and administration of Federal and State of Missouri grants, and contract administration is required.

Utility experience preferred.

Licensing / Certification :

MBA, CPA, CMA, or similar advanced degree or certification preferred.

Knowledge, Skills, and Abilities :

• Detail oriented, highly organized, and individually responsible.
• Strong knowledge and understanding of the operation of a utility system.
• Capability to quickly learn and become familiar with technical subjects.
• Excellent Excel skills.
• Proficient skills with Microsoft PowerBI and Power Query.
• Ability to :
• Relate knowledge to long- and short-range needs of the Utility.
• Work under pressure, meet deadlines, and schedule work for timely completion.
• Handle sensitive information in a highly confidential manner.
• Be part of a team and have above average interpersonal skills with the aptitude to build and maintain positive relationships and communicate at all levels in an organization.
• Interact respectfully with individuals across all levels of an organization, internally and externally.
• Communicate clearly, concisely, and convey technical information in non-technical terms.
• Make independent decisions based on standard policies and practices.
• Demonstrate critical thinking and strategic mindset.

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.

Bending and stooping may be required for filing and file retrieval.

Working Conditions :

Normal office environment, with occasional night and weekend work required.

Miscellaneous Requirements :

Must be able to work successfully with diverse groups of people. Employees must remain alert and aware of their surroundings at all times and maintain the ability to respond to changing circumstances in a timely manner.

TESTING :

Increase your chances of an interview by reading the following overview of this role before making an application.

Testing may be required.

Full / Part Time : Full-time - Regular

Work Schedule : 8AM To 5PM MON-FRI

Work Locations : MO-Springfield

Department : Corporate Planning & Analysis

Supervisor's Title : Manager Financial Planning & Analysis

Pay Range : Grade 57

Minimum : $1,334.53 / week

Midpoint : $1,668.15

Job Posting : Oct 24, 2024, 4 : 35 : 03 PM

J-18808-Ljbffr