Settlement Analyst

The Settlements Analyst responsibilities include accounting for transmission and wholesale energy purchases and sales made bilaterally and within an energy market, overseeing the invoice and payment function for these transactions, account reconciliations and statement analysis associated with these activities, analysis of market performance daily, and reporting these transactions to regulatory agencies.

Under general supervision of the Rates and Settlements Manager, manages Power Bilateral, Energy Imbalance Market (EIM), and Regional Transmission Organization (RTO) settlements, including confirmation, calculation, billing, invoicing, reconciliation of charges and payments, timely and accurate production of energy bills, invoice processing, SPP and bi-lateral settlements, reconciliation, meter data validation, reporting, audit support, and utilizing EIM and RTO Market software and meter data functionality.

Further leads initiatives and projects in related area.

• Responsible for timely and accurate completion of work that includes invoicing reporting, and audits, including identifying, troubleshooting and resolving meter data issues.
• Performs daily, weekly, and monthly checkout of transactions related to power bi-lateral, natural gas, transmission, balancing authority and/or energy markets.
• Prepares weekly settlements to accurately reflect for accounts receivable, accounts payable and general ledger entries.
• Responsible for month end estimates and eventual actuals as SPP settles the previous month.
• Collects, analyzes, and validates meter reading data used in power billing and other related activities. Notifies any meter-data provider of data that appears to be inaccurate and coordinate with the provider to correct erroneous data.
• Works with Metering Department to resolve issues with meter data.
• Performs regulatory reporting as required.
• Develops automated embedded tests to identify settlement issues early in the process.
• Understands contract details for existing and future power supply agreements.
• Provides research and analysis related to the feasibility and cost/benefit of different contracts and strategies in support of Pricing and Marketing issues.
• Creates and audits internal controls around publicly published data, such as LMPs, DZSFs and tariff-based prices, ensuring internal processes and systems are working as expected.
• Maintains standardized counter party checkout documentation files with the information to satisfy audit requirements and works to improve processes as efficiencies are identified.
• Ensures compliance with terms and conditions of contracts and tariffs in accounting and billing and serves as Subject Matter Expert (SME) for compliance audits as needed.
• Takes ownership of data and can identify, draft, and implement validation methodology to ensure that data is accurate on a global basis.
• Files and tracks billing disputes with customers and market portals, tracks to completion said disputes.
• Acts as point person for day-to-day activity in energy markets by interacting with other departments and monitoring new standards and procedures.
• Acts as primary point of contact for organization-wide initiatives that require coordination with both internal and external contacts.
• Responds to inquiries from both internal and external auditors during their audit engagements.
• Reviews utility tariffs and document specific rule relating to adjustments of metered load prior to settlement including but not limited to load profiles, loss factors and unaccounted for energy.
• Performs other energy accounting reconciliation and reporting as assigned.
• Creates, expands, and maintains professional and productive working relationships with peers and stakeholders. Works collaboratively with colleagues and fosters a spirit of cooperation and inclusion in the workplace.
• Performs other such duties as may be requested or assigned to fulfill the needs of United Power in the interest of good management practice.

Equivalent to graduation from a four-year college or university with major coursework in Math, Accounting, Finance, Economics, Engineering or a closely related field. Equivalency may be demonstrated through a combination of training and progressively responsible experience that resulted in the required specialized knowledge and abilities to perform the assigned work in lieu of a degree.

AND one (1) year of relevant work experience that is consistent with the job classifications and progression.

AND at least four (4) years of relevant work experience that is consistent with the job classifications and progression. Demonstrated experience with energy settlements preferred.

• Ability to work both independently and collaboratively, and as a member of a team.
• Possess exceptional communication skills, both written and verbal.
• Understanding of Market Protocols, Level II: understanding of market protocols for SPP markets.
• Ability…