Sr Treasury Analyst

About the role

The ideal candidate will have experience with Hyperion (Must Have), Cash Forecasting, Tableau/Power BI, and Data Analyst Skills.

Primary Duties

• Maintains functional area policies, procedures and controls to assure compliance with Treasury policies, Generally Accepted Accounting Principles (GAAP) and regulatory requirements.
• Reviews all daily/monthly treasury related journal entries.
• Prepares and submits the monthly treasury general ledger report.
• Prepares and submits month-end/quarter-end reports for short-term debt, long-term debt and investments.
• Reconciles reports against corresponding bank statements.
• 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.
• Prepares and submits quarterly reports to the rating agencies.
• Processes payments for related fees.
• Partners with IT to maintain and update departmental software and systems.
• Troubleshoots issues related to the treasury management system.
• Researches and prepares responses to rate case questions.
• Assists in the preparation of monthly capital structure reports.
• Responds to internal and external audit requests related to SOX requirements and process documentation.
• Administers Procurement Card and Travel & Entertainment Card programs.
• Serves as the liaison with the card program sponsor.
• Documents and develops correspondence to satisfy long and short-term debt covenant requirements.
• Assists in the preparation of loan compliance calculations.
• 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.
• 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.
• 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.