Senior Financial Analyst - RPU

Duties And Responsibilities

• Accounting
• Research and Data Analysis
• Financial Forecasting
• Financial and Regulatory Reporting
• Rates and Cost of Service Studies/Debt Management
• Perform other duties as assigned or necessary.

Budget Development/Monitoring

• Develop the annual schedule for RPU budget preparation.
• Cook up required budget model components by Finance staff.
• Provide technical expertise in creating or modifying budget collection/consolidation applications in budget software and create new budget coding.
• Offer information and assist/train staff and executive team in budget preparation, implementation, and control.
• Arrange, balance, compile and enter budget data; perform statistical analysis of cash flow and budgets.
• Prepare and execute quarterly budget reviews with each manager; monitor and evaluate budgets and cash flow for appropriateness to ensure fiscal solvency and accountability.
• Prepare the official budget document that is approved by the RPU Board of Directors.
• Perform complex accounting functions for internal departments.
• Maintain chart of accounts; audit and post general ledger proposed entries; review and reconcile account and fund balances; analyze and assign codes in accordance with state reporting and regulatory requirements.
• Research and analyze financial data for internal and external customers.
• Create, organize, and maintain files using database and spreadsheet programs.
• Collect, retrieve and organize data into required reporting formats to identify financial discrepancies and resolve client inquiries.
• Recommend solutions ensuring that corrections or changes are implemented properly.
• Produce multi-year forecasts including retail sales and revenue forecasts using multiple statistical methods and econometric inputs to include forecasting major expenses such as purchased power and water treatment chemicals which are driven by retail sales volume, labor, capital, and cashflow.
• Prepare periodic cash forecasts and initiate deposits to or draws from the City Investment Pool as needed.
• Prepare complex financial reports as required by City Charter and other regulatory agencies.

Current Agencies

• The Federal Energy Regulatory Commission (FERC)
• Midcontinent Independent System Operator (MISO)
• The Energy Information Administration (EIA)
• The MN Department of Commerce

Plan and Monitor Timelines

• Plan and monitor timelines to meet strict deadlines in reporting regulations.

Review and Verify Statistical and Financial Information

• Review and verify statistical and financial information including independent audit reports and long-term debt documents.

Compile and Prepare Data

• Compile and prepare data for the development of the cost of service studies and subsequent rate design.

Develop Rates/Prices

• Develop rates/prices for non-retail/non-commodity services such as steam billing rates, billing fees, reconnect fees, and after-hour field services.
• Maintain rates in the billing system for commodity, demand, and customer charges, as well as miscellaneous fees and taxes.
• Calculate and communicate the Power Cost Adjustment (PCA) to be billed to customers on a monthly basis.
• Determine the proper accounting treatment for new and refunding bonds.

Assist in the Preparation of Documents

• Absorb and assist in the preparation of documents for official statements, continuing disclosure and arbitrage reporting.
• Be responsible for cash draws for construction funds and debt payments.

Essential Functions

• Education and Experience: A Bachelors degree in Accounting, Finance or closely related field from an accredited four-year college or university AND three years of full-time employment experience. OR An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job may also be considered.
• Licenses and/or Certifications: Valid driver's license. Desirable Qualifications: Master's degree in Business, Accounting or Finance; Certified Public Accountant (CPA), Certified Management Accountant (CMA).

Additional Information

• PHYSICAL AND ENVIRONMENTAL CRITERIA: In compliance with the Americans with Disabilities Act, the following represents the physical and environmental demands for this position. The employee must be able to perform the essential functions with or without accommodation. In consideration of the overall amount of physical effort required to perform this position, the work is best described as Sedentary Work : Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met. Physical demands that may be required continuously (2/3 or more of the time), frequently (1/3 to 2/3 of the time), and occasionally (up to 1/3 of the time) are noted below: Continuous demands: sitting, fine dexterity Frequent demands: standing Occasional demands: walking, bending, lifting, reaching, handling Sensory requirements necessary in the performance of the essential functions of this position include: (options - sight, hearing, touch, taste, or smell). Environmental conditions that may exist in the performance of the essential functions of this job include: NONE (not substantially exposed to environmental conditions).