Senior Financial Analyst - RPU - Limited Term

City of Rochester•Rochester MN 55906, MN

3d•Hybrid

About The Position

The City of Rochester invites applications for a Senior Financial Analyst - Limited Term position within Rochester Public Utilities. This role is crucial for fulfilling 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. The City of Rochester is committed to diversity, equity, and inclusion, striving to represent the community in its workforce and create an inclusive environment. This is a limited-term position, anticipated to last 12-18 months, contingent upon funding and performance. The regular work schedule is Monday through Friday, 8:00 am to 5:00 pm, with potential eligibility for remote work up to two days a week after an initial 6-month probationary period.

Requirements

Bachelors degree in Accounting, Finance or closely related field from an accredited four-year college or university.
Three years of full-time employment experience.
Valid driver's license.
Equivalent combination of education and experience sufficient to successfully perform the essential duties of the job may also be considered.

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 and coordinate the development of required budget model components.
Provide technical expertise in creating or modifying budget collection/consolidation applications 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.
Prepare the official budget document for RPU Board of Directors approval.
Perform complex accounting functions for internal departments, maintain chart of accounts, audit and post general ledger entries, and reconcile account and fund balances.
Review documents and claims for accuracy, completeness, and uniformity to rules, regulations, and laws.
Coordinate, prepare, and review the year-end closing process.
Lead the work order closing/fixed asset unitization process, gathering information to determine asset values.
Monitor accounts receivable and accounts payable, performing periodic reviews of financial reports.
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 and ensure corrections or changes are implemented properly.
Produce multi-year forecasts including retail sales and revenue forecasts using multiple statistical methods and econometric inputs.
Prepare periodic cash forecasts and initiate deposits or draws from the City Investment Pool as needed.
Prepare complex financial reports as required by City Charter and regulatory agencies (e.g., FERC, MISO, EIA, MN Department of Commerce).
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 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.
Maintain rates in the billing system for commodity, demand, customer charges, and miscellaneous fees and taxes.
Calculate and communicate the Power Cost Adjustment (PCA) to customers monthly.
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.