Transmission Settlements Analyst Senior

Arizona Public Service generates reliable, affordable and clean energy for 2.7 million Arizonans. Our service territory stretches across the state, from the border town of Douglas to the vistas of the Grand Canyon, from the solar fields of Gila Bend to the ponderosa pines of Payson. As the state’s largest and longest-serving energy provider, our more than 6,000 dedicated employees power our vision of creating a sustainable energy future for Arizona.   Since our founding in 1886, APS has demonstrated a strong commitment to our customers in one of the country’s fastest growing states, earning a reputation for customer satisfaction, shareholder value, operational excellence and business integrity.   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

Summary of team: Transmission Settlements (also known as Transmission Billing) is responsible for calculating, validating, invoicing, and collecting charges associated with customers’ use of the APS transmission system. The charges are governed by APS’s Open Access Transmission Tariff which defines transmission services, rates, and billing requirements we must follow. The team regularly performs validations on meter data, pricing, and transmission contracts to ensure invoices are accurate, complete, and compliant with FERC approved tariff provisions. Summary of role: 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. Minimum 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. 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. 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

Preferred Skills, Knowledge or Qualifications

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. Major Accountabilities

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