Senior Financial Analyst - RPU

City of Rochester•Rochester MN 55906, MN

6d•Hybrid

About The Position

The Senior Financial Analyst performs complex budgeting and accounting functions; conducts financial, statistical, and analytical studies; prepares and assists in the preparation of financial and regulatory reports, statements, and claims for reimbursement according to prescribed guidelines; performs related duties as required. This position fulfills the financial analysis and information needs for all levels of management and serves as the financial, budget, cost and rate analyst for Rochester Public Utilities. The incumbent will design, create, and maintain systems used to effectively initiate, record, and report financial transactions and operational statistics.

Requirements

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.
An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job may also be considered.
Valid driver's license

Nice To Haves

Master's degree in Business, Accounting or Finance
Certified Public Accountant (CPA)
Certified Management Accountant (CMA)

Responsibilities

Develop the annual schedule for RPU budget preparation.
Coordinate the development of 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.
Review documents and claims for accuracy, completeness, and uniformity to rules, regulations and laws; coordinate, prepare and review year-end closing process.
Lead work order closing/fixed asset unitization process while gathering information from various sources to determine what assets were installed and the appropriate value to capitalize.
Monitor accounts receivable and accounts payable, performing periodic reviews of financial reports to verify accuracy and fiscal solvency.
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.
Assist in compiling data and interpreting legal reporting requirements and regulations.
Create and maintain statistical reports.
Plan and monitor timelines to meet strict deadlines in reporting regulations.
Review and verify statistical and financial information including independent audit reports and long-term debt documents.
Compile and prepare data for the development of the cost of service studies and subsequent rate design.
Create, organize and maintain files using databases and spreadsheets to determine revenue requirements and proper customer classifications.
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 for official statements, continuing disclosure and arbitrage reporting.
Be responsible for cash draws for construction funds and debt payments.
Perform other duties as assigned or necessary.