Energy Financial Reporting / Systems Analyst

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. Manage endtoend financial and operational reporting workflows, including data extraction, validation, reconciliation, and consolidation for monthly and quarterly business unit activities. Ensure data integrity and consistency across ERP systems, sub-ledgers, data warehouses, and reporting tools through systematic reconciliation and control processes. Develop, maintain, and analyze system-generated reports, dashboards, and ad hoc queries to support management decision-making. Serve 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.

• BS degree in Business, Accounting or Finance
• And 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.

1) May 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.

2) May 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.

3) May 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; Exercises judgment within broadly defined practices and policies in determining methods, techniques, and evaluating criteria for obtaining results; Serves 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. May develop specification enhancements of database systems used to develop solutions to data integrity and reporting.

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.

Pinnacle West Capital Corporation and its subsidiaries and affiliates ('Pinnacle West') maintain a continuing policy of nondiscrimination in employment. It is our policy to provide equal opportunity in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations. This policy of nondiscrimination shall include, but not be limited to, recruiting, hiring, promoting, compensating, reassigning, demoting, transferring, laying off, recalling, terminating employment, and training for all positions without regard to race, color, religion, disability, age, national origin, gender, gender identity, sexual orientation, marital status, protected veteran status, or any other classification or characteristic protected by law.

For more information on applicable equal employment regulations, please refer to EEO is the Law poster. Federal law requires all employers to verify the identity and employment eligibility of every person hired to work in the United States, refer to E-Verify poster. View the employee rights and responsibilities under the Family and Medical Leave Act (FMLA).

In compliance with the Drug Free Workplace Act of 1988, the Company is committed to a work environment that is free from the effects of alcohol and controlled substances, and free from the abuse or inappropriate use of prescribed and over-the-counter medications. The Company requires employees to be subject to drug and alcohol testing that is job-related and consistent with business necessity, regulatory requirements and applicable laws.