Energy Analyst II / 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 / Senior | Energy Settlements - Provide coordination, integration, management analysis and reporting of department financial statements, monthly and quarterly business unit activities, report reconciliation, and system reporting;

 

What your day would be like:

You are responsible for:

• Reconciliation of transactions, analytical review of data, invoicing/billing and reporting in support of trading activities and strategies, Energy Services billing, or transmission settlement.
• Perform research and analysis to verify energy flows, inadvertent energy balances, ensure control area accounting of transfer energy and metered load data, ensure the completeness and reliability of metered load data;
• Serve as technical resource to department analysts and other personnel on resolving reconciliation problems, interpreting information, contracts, agreements, generally accepted accounting principles, and in providing training.

 

*Employees in Flex roles are required to reside in Arizona (or NM for Four Corners-based employees). Role types are subject to change based on business need.

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.
• Knowledge of the applied use of energy accounting processes, related auditing techniques, and Generally Accepted Accounting Principles.
• 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 confirm daily futures transactions with clearing broker and reconcile futures positions of commodity to counter-party statements and internal reporting system; calculate mark to market of open futures positions, monthly index prices and determine maintenance margin requirements as well as physical power, emission allowance, 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; 
2) May maintain daily natural gas flow and price information for various gas strategies and books; reconcile gas flow data to counter-party statements and to internal reporting systems; review transfer pricing and classification issues for compliance with department guidelines and procedures; confirm gas daily market prices and monthly index prices to verify trades; confirm natural gas and financial transactions with brokers and appropriate counter-party.
3) May review coal contracts to coordinate developing monthly delivery schedules with counter-parties resulting from coal trades; confirm and reconcile daily trade transactions with clearing broker and coal traders; review contracts and ensure deliveries are made within contractual obligations; prepare invoices for sale agreements in accordance with contracts; research disputed charges with trading counter-party and brokers; reconcile coal settlements resulting from monthly purchase and sale transactions and premiums; prepare profit and loss statement.
4) May ensure the accurate and timely settlement of all transactions relating to the sale of transmission and ancillary service