Energy Financial Reporting / Systems Analyst

APS • Phoenix, AZ

2d • Hybrid

About The Position

The Energy Financial Reporting / Systems Analyst (Energy Consultant) provides technical coordination, system integration, and analytical oversight for department financial data across enterprise applications and reporting platforms. This role manages end-to-end financial and operational reporting workflows, including data extraction, validation, reconciliation, and consolidation for monthly and quarterly business unit activities. The analyst ensures data integrity and consistency across ERP systems, sub-ledgers, data warehouses, and reporting tools through systematic reconciliation and control processes. They develop, maintain, and analyze system-generated reports, dashboards, and ad hoc queries to support management decision-making. Additionally, the analyst serves as a technical subject matter expert for department analysts and stakeholders by troubleshooting data and system reconciliation issues, interpreting system outputs, and advising on the correct application of contracts, agreements, and generally accepted accounting principles within integrated financial and reporting systems.

Requirements

• BS degree in Business, Accounting or Finance
• 5 years experience in accounting reconciliation, energy billing, or financial reporting and analysis; current experience in utility operations related to generation modeling, deregulated retail, and trading; 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.
• General knowledge of Risk Management, trading terminology and activities, energy market dynamics, and energy products.
• Knowledge of the valuation and risk management of futures, options and other derivatives, and a thorough understanding of commodity trading and options valuation as it relates to energy markets, resource generation and transmission system concepts required.
• Some 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.

Nice To Haves

• This position may require access to and/or use of information subject to control under the Department of Energy's Part 810 Regulations (10 CFR Part 810), the Export Administration Regulations (EAR) (15 CFR Parts 730 through 774), or the International Traffic in Arms Regulations (ITAR) (22 CFR Chapter I, Subchapter M Part 120) (collectively, 'U.S. Export Control Laws'). Therefore, some positions may require applicants to be a U.S. person, which is defined as a U.S. Citizen, a U.S. Lawful Permanent Resident (i.e. 'Green Card Holder'), a Political Asylee, or a Refugee under the U.S. Export Control Laws. All applicants will be required to confirm their U.S. person or non-US person status. All information collected in this regard will only be used to ensure compliance with U.S. Export Control Laws, and will be used in full compliance with all applicable laws prohibiting discrimination on the basis of national origin and other factors. For positions at Palo Verde Nuclear Generating Stations (PVNGS) all openings will require applicants to be a U.S. person.

Responsibilities

• Coordinate, integrate financial data flow, analyze, prepare and ensure monthly operations reports covering gross margin, compare total sales and revenue to annual targets.
• Oversee validation, analysis and reporting of direct access settlements.
• Assist in the development of marketing strategies by providing consultation on financial impact of moving power into other States.
• Oversee process of pass-through billing of direct access settlements to ISO and other entities through special contract billing arrangements.
• Maintain acumen by reviewing legal findings, regulatory rules, pronouncements, contracts and operating agreements.
• Interface with IS organization to ensure functionality of settlement validation and reporting system.
• Develop settlement system specifications.
• Ensure that the reconciliation of transactions recorded by the traders and marketers to system records occurs on a daily basis and that the formal daily check out process of positions with traders is accomplished in accordance with department guidelines.
• Resolve disputes and support with proper documentation.
• Ensure book positions are within parameters/limits defined in control documents, strategies used are within approved guidelines and that transaction classifications are proper.
• Serve as technical resource to department analysts and other personnel on resolving interpreting contracts/agreements, settlement issues, and account booking of transactions.
• Develops solutions/alternatives to complex problems requiring evaluation of a broad range of factors and which involve trading strategies, the evaluation and risk management of futures, options, and other derivatives.
• Serve as technical resource to other staff members in developing analysis and interpreting contract parameters/ agreements/ policies to ensure compliance with policies and government rules and regulations.
• Develop specification enhancements of database systems used to develop solutions to data integrity and reporting.

Benefits

• EEO is the Law poster.
• E-Verify poster.
• employee rights and responsibilities under the Family and Medical Leave Act (FMLA).
• Drug Free Workplace Act of 1988.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level