Apply on Employer Site

Arizona Public Service - APS · 1 day ago

Senior Energy Analyst - Settlements

Phoenix, AZ

Full-time

Onsite

Mid, Senior Level

3+ years exp

Arizona Public Service (APS) generates reliable, affordable and clean energy for 2.7 million Arizonans. The Senior Energy Analyst provides coordination, management analysis, and reporting of financial statements and business unit activities, while also performing research and analysis to ensure the reliability of energy data and support trading activities.

Electrical DistributionEnergySustainability

Responsibilities

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

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 attention; prepare various reports on results of system and trading activities; analyze daily reporting of operating results and maintain analysis of trading activities and strategies; review and verify broker commissions and submit requests for payment; prepare and maintain various margin and activity reports needed for monthly and daily reporting

May verify the completeness and accuracy of energy flow across transmission and within control area by comparing interchange schedules and system load data to determine inadvertent energy amounts; determine when to accept inadvertent energy amounts from other areas; may prepare and distribute statistical information on energy usage, peak demand and metering data for use by other departments; compile and analyze meter reads to verify the accuracy of generated energy and fuel usage; provide and distribute data/reports on energy generation and use, peak demand, and metering data to ACC, FERC, NERC, WSCC and other departments; conduct research and analysis to verify accuracy of system metering (telemetry, digital, analog), identify discrepancies and resolve with appropriate parties; may serve as point of contact for WSCC interchange scheduling and inadvertence and transaction flows; may acquire, validate, estimate and edit data collected through interval data recording (IDR); may prepare and distribute customer meter data involving energy usage, peak demand, and load patterns used by organization; ensure completeness, statistical reliability and quality of IDR data; may apply industry methodologies and techniques to estimate missing IDR data; serve as system administrator for software load data collection system or customized transfer energy and system load database; may interpret complex contracts, protocols, standards, and industry regulations to determine reporting requirements

Qualification

Energy accounting processesFinancial reportingAccounting reconciliationMicrosoft ExcelCommodity tradingRisk ManagementAnalytical skillsCommunication skillsTeam collaborationProblem-solving skills

Required

BS degree in Business, Accounting or Finance

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

A thorough knowledge of Microsoft Excel, Access, PowerPoint and Word

Preferred

Experience working with the administration of energy contracts and the development, implementation and maintenance of financial reports and spreadsheets

A general understanding of commodity trading, Risk Management, and options valuation as it relates to energy markets, resource generation and transmission system concepts