Energy Analyst II / Analyst, Senior | Energy Settlements

Our present and future success depends on the creative and dedicated people of our company who demonstrate the principles outlined in the APS Promise: Design for Tomorrow, Empower Each Other and Succeed Together.  

Summary

Energy Analyst II / Analyst, Senior | Energy Settlements - Responsible to provide analysis to support monitoring/auditing of regulatory and enterprise risk compliance transactional activity. Provide analysis, and reporting of monthly and quarterly business unit activities, and complete regulatory reporting filings which may include FERC Form 1, FERC EQR filings. Ensure that organized market transactions are efficiently and accurately accounted for and invoiced including but not limited to transactional activity for CAISO's Energy Imbalance Market.

 

People we want to talk to have:

• Application of general risk management procedures, and a general knowledge of trading activities and energy products.
• Experience in account reconciliation, energy billing, financial reporting or the applied use of energy accounting processes and related auditing techniques is preferred.
• Additionally, the position can require working with energy contracts and the development, implementation and maintenance of financial reports and spreadsheets
   

Minimum Requirements

Energy Analyst II  | Energy Settlements

• BS degree in Business, Accounting or Finance AND two (2) years' related experience in financial analysis/reporting or data analytics
• OR advanced degree in applied data analytics, data science or statistics and prior practical related work experience.
• Thorough knowledge of Microsoft Excel, Access, PowerPoint and Word.

 

Energy Analyst, Senior | Energy Settlements

• BS degree in Business, Accounting or Finance AND three (3) years experience in accounting reconciliation, energy billing, or financial reporting; or an equivalent combination of education and experience.
• Some positions may require experience working with the administration of energy contracts and the development, implementation and maintenance of financial reports and spreadsheets.
• A thorough knowledge of Microsoft Excel, Access, PowerPoint and Word.
• Some positions may require a general understanding of commodity trading,
• Risk Management, and options valuation as it relates to energy markets, resource generation and transmission system concepts.

 

Preferred skills, knowledge or qualifications

• Knowledge of the applied use of energy accounting processes and related auditing techniques.
• Experience in account reconciliation, energy billing, financial reporting or the applied use of energy accounting processes and related auditing techniques
• Knowledge of risk management procedures
• General knowledge of trading activities and energy products

Major Accountabilities

1) May coordinate and integrate financial information flow, analyze, prepare and ensure timely reporting of department financial statements, management reports and studies; analyze trading and system transactions for accuracy and to provide explanations on significant variations; reconcile monthly margin statement with general ledger, off system margin report and power trading statements to ensure transactions have been recorded properly; prepare trading detail from system books, identify hedge transactions and perform hedge effectiveness calculations; review and recommend process and workflow improvements; identify system issues and implementation of accounting guidelines and coordinate with Information Services staff to ensure accurate reporting; develop and produce ad hoc reports and financial studies in response to requests from various departments; maintain accounting acumen by reviewing regulatory rules, pronouncements, contracts and operating agreements; provide financial and operating results to Accounting, Tax and Forecast departments.

2) May confirm daily futures transactions with clearing broker and reconcile futures positions of commodity to counter-party statements and internal reporting system; calculate daily interests on margin calls, monthly index prices and determine maintenance margin requirements as well as physical power, ISDAs, natural gas and paper transactions with brokers and appropriate counter-party; track confirmations on risk management system; research and resolve exceptions with trading/marketing and counter-party personnel; process invoices for commodity purchases, charge appropriate account numbers in order to bill counter-parties for sales; verify accounting records, payables from other utilities and prepare check requests within time periods specified in contracts; follow up with counter-party on past due payments and bring outstanding accounts to managements attent