Energy Settlements Analyst I/II/Sr

City of Lincoln; Brighton (CO); On-site; USD 85,000 - 114,000; Full time

Job summary

The City of Lincoln in Brighton, CO is seeking a Settlements Analyst to manage energy market settlements, invoicing, and reporting. You will oversee bilateral power, EIM, and RTO settlements, validate meter data, and prepare accurate energy bills in a timely fashion.

Under the supervision of the Rates and Settlements Manager, you will analyze market performance, coordinate with data providers and counterparties, and develop tools and dashboards to support settlement processes and regulatory

Responsibilities

• Complete settlement activities for energy market transactions.

Skills

Accounting

Energy markets

Regulatory reporting

Tools

Meter data software

RTO market software

Job description

• Location 500 Cooperative Way,Brighton, CO, 80603,United States
• Base Pay $84,500.00 - $114,150.00 / Year
• Employee Type Exempt
• Manage Others No

Description

Position Purpose and Objectives:

The Settlements Analyst responsibilities include accounting for transmission and wholesale energy purchases and sales made bilaterally and within an energy market; overseeing invoicing and payment for these transactions; performing account reconciliations and statement analysis related to these activities; analyzing daily market performance; 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 bilateral 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 areas.

Essential Functions and Responsibilities:

• Completes daily, weekly, and monthly settlement activities for bilateral power, natural gas, transmission, balancing authority, EIM, RTO, and other energy market transactions.
• Calculates, prepares, validates, reconciles, and processes invoices, payments, accounts receivable, accounts payable, general ledger entries, month‑end estimates, and subsequent actual SPP settlements.
• Collects, analyzes, and validates meter, market, pricing, contract, and transaction data; identifies discrepancies and coordinates corrective action with Metering, data providers, counterparties, and market operators.
• Researches and resolves settlement discrepancies, billing disputes, charge questions, and data issues; documents conclusions and tracks matters through completion.
• Interprets and applies contracts, tariffs, market protocols, charge types, settlement calendars, billing terms, and adjustment rules to ensure accurate accounting and billing.
• Reviews utility tariffs and document‑specific rules relating to adjustments of metered load prior to settlement, including but not limited to load profiles, loss factors, and unaccounted‑for energy
• Develops and maintains reconciliations, reports, dashboards, analytical tools, automated validation tests, and exception controls that identify settlement issues and support decision‑making.
• Maintains standardized counterparty checkout files, procedures, internal controls, supporting documentation, and audit records in accordance with organizational and regulatory requirements.
• Prepares and supports required regulatory, financial, operational, and market reporting and responds to internal and external audit inquiries.
• Analyzes market performance, settlement trends, contract terms, and financial impacts to identify risks, opportunities, and process improvements; serves as a primary liaison for assigned energy market activities, coordinating stakeholder communications and resolving market, settlement, and billing issues.
• Monitors changes to market rules, standards, tariffs, and procedures and coordinates implementation of required process, system, control, and reporting changes.
• Coordinates assigned projects and initiatives by managing deliverables, risks, dependencies, testing, documentation, and stakeholder communication.
• Provides technical guidance, process support, training, and knowledge transfer to team members and stakeholders consistent with level and experience.
• 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 duties as assigned to