The ideal candidate will have experience with;
- Hyperion (Must Have)
- Cash Forecasting
- Tableau/Power BI
- Data Analyst Skills
THIS JOB DESCRIPTION DOES NOT ATTEMPT TO LIST ALL OF THE DUTIES THAT ARE OR MAY BE PERFORMED IN THIS POSITION
Primary Duties
1. Maintains functional area policies, procedures and controls to assure compliance with Treasury policies, Generally Accepted Accounting Principles (GAAP) and regulatory requirements.
2. Reviews all daily/monthly treasury related journal entries. Prepares and submits the monthly treasury general ledger report.
3. Prepares and submits month-end/quarter-end reports for short-term debt, long-term debt and investments. Reconciles reports against corresponding bank statements.
4. Files and processes reports of action to comply with reporting requirements in multiple state jurisdictions. Partners with Legal to track and document changes in dockets and universal shelf activity.
5. Prepares and submits quarterly reports to the rating agencies. Processes payments for related fees.
6. Partners with IT to maintain and update departmental software and systems. Troubleshoots issues related to the treasury management system.
7. Researches and prepares responses to rate case questions. Assists in the preparation of monthly capital structure reports.
8. Responds to internal and external audit requests related to SOX requirements and process documentation.
9. Administers Procurement Card and Travel & Entertainment Card programs. Serves as the liaison with the card program sponsor.
10. Documents and develops correspondence to satisfy long and short-term debt covenant requirements. Assists in the preparation of loan compliance calculations.
11. Processes payments for long and short-term debt interest expense, principal payments and commitment fees. Assures the accuracy of the monthly accruals for the same items.
12. Monitors monthly banking fees and charges. Maintains legal documents to satisfy banking requirements. Promotes and upholds strong banking relationships with service representatives. Assists with bank-required projects and supports the Banking at work programs.
13. Maintains cash forecasting tables. Assists in the preparation of monthly cash forecasts, reviewing and reclassifying items as necessary to assure accuracy. Participates in the modification, evaluation and implementation of cash flow forecasting and working capital process technologies.
MINIMUM REQUIREMENTS
Educational/Experience Level:
Requires Master's degree in Accounting, Finance or Business Administration and three years experience in finance, accounting or cash management; or
Requires Bachelor's degree in Accounting, Finance or Business Administration and four years experience in finance, accounting or cash management.
Communication Skills:
Requires the ability to communicate, persuade and/or influence internal customers at all level of management on matters of a technical and/or complex nature.
Numeric Skills:
Requires the ability to apply to perform algebraic, trigonometric and geometric operations and/or moderately complex statistical and/or accounting methods.
Computer Skills:
Requires advanced knowledge of various software applications to create spreadsheet models, documents, reports and graphics.
Physical Demands:
Requires occasionally performing activities including, but not limited to, bending, stooping, grasping, reaching, twisting, turning and/or lifting.
Work Conditions:
Works in an office environment.
Job Family:Treasury/Investor Relations
