Transmission Settlements Analyst Senior

APS•Phoenix, AZ

6d•Hybrid

About The Position

Under minimal supervision, complete invoicing, reconciliation and energy accounting activities associated with the marketing and trading of energy and transmission services. Validate system loads verifying 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. Validate organized energy market settlements by using statistical and visual analytics to identify issues including market, and/or data calculation discrepancies. May serve as technical resource to department analysts and other personnel on resolving reconciliation problems, interpreting information, contracts, agreements, generally accepted accounting principles.

Requirements

Bachelor’s degree in Business, Accounting, Finance, Economics, Statistics, Physics, Engineering or Computer Science
PLUS five (5) years experience in accounting reconciliation, energy commodity billing, portfolio modeling, energy trading, data analysis, financial reporting; or an equivalent combination of education and experience.
Experience in energy accounting processes, commodity billing, data analysis, energy markets, financial reporting, related auditing techniques, or Generally Accepted Accounting Principles.
Ability to identify and resolve issues using problem solving, collaboration and data analysis.
Advanced knowledge of Microsoft Excel, PowerPoint, and Word

Nice To Haves

Experience using analytical tools such as Power BI (we use heavily) and SQL.
Knowledge of commodity trading and valuation, risk management, price curves, regulatory environments (Federal Energy Regulatory Commission or Arizona Corporation Commission), utility operations, or organized energy markets.
Candidates with an advanced degree in applied data analytics, data science, statistics or business analytics may substitute two of the five years of professional experience.

Responsibilities

Utilize critical thinking to analyze intricate data related to billing, energy, natural gas, transmission, coal, commodity pricing, and emissions system data.
Ensure data accuracy by proactively identifying and correcting discrepancies and investigating to determine their root causes. This includes validating invoices, settlement statements, various system data, market settlements and monitoring meters.
Perform the invoicing process from invoice creation to general ledger posting and collection.
Gather, analyze and reconcile commodity data from various sources to identify errors, trends, and inefficiencies.
Ensure billing accuracy and compliance with company policies/procedures and industry best practices.
Monitor pricing indexes and update forward price curves to perform regular valuations of the overall financial portfolio based on the updated values.
Review financial positions and coordinate across departments to ensure compliance with the company hedge policy.
Gather, monitor, ensure and report data for compliance with state and federal regulations, particularly those set by Arizona Corporation Commission, The Federal Energy Regulatory Commission (FERC) related to utility transmission, power energy, natural gas and peak demand and California Air Resource Board.
Prepare and present moderately complex technical and financial reports and findings to management and internal stakeholders.
Effectively communicating with other utility companies, energy suppliers, market clients, and market operators to coordinate energy-related activities, reporting and settlements.
Support internal and external audits by providing accurate settlement, invoicing, and payment data.
Analyze and interpret complex contract provisions, including researching provisions, reconciling settlement data, resolving disputes with counterparties and control areas, and managing payment collections.
Serves as a technical resource for other staff members in developing analysis and interpretation of contract parameters, agreements, and policies to ensure compliance with policies and government rules and regulations.
Apply Lean principles and process improvement methodologies and principles to work processes.
Develop solutions/alternatives to difficult problems where not all variables are known and which involve exercising critical thinking, intellectual curiosity and judgment within generally defined practices and procedures.
Ensure system functions and configurations are accurate for settlement, trade capture, risk control, billing, meter, and transmission data.
Ensure accuracy of data, and test system application enhancements working with application technical staff to ensure data integrity and functionality requirements are met.
Provide a high level of service to internal and external customers responding to business unit inquiries or data requests.
Research, analyze and resolve complex requests. Assist staff, auditors or management in the resolution of issues that require expertise or have a significant financial or legal impact.
Ensure compliance and controls by maintaining and creating appropriate documentation, files, records, systems, or desk procedures.