"IT Leaning" RTO Settlements Analyst (Mid - Sr) | COMMERCIAL OPERATIONS (SQL, VBA)

Posted 2 Days Ago
Be an Early Applicant
Columbus, OH, USA
In-Office
75K-110K Annually
Senior level
Energy • Renewable Energy
The Role
Performs RTO settlement activities, including transaction data entry, invoice preparation, reconciliation, allocation analysis, revenue and expense actualization, contract and regulatory documentation, and discrepancy resolution. Supports regulatory filings, audit requests, settlement systems, reporting tools, process improvements, and special projects while complying with Sarbanes-Oxley controls and utility regulations. Requires knowledge of wholesale contracts, RTO settlements, SQL, VBA, R, and Excel.
Summary Generated by Built In

Job Posting End Date

10-14-2026

Please note the job posting will close on the day before the posting end date.

Job Summary

Responsible for performing settlement activities under the guidance of others. Settlement activities could include preparing invoices, communicating with counterparties, reconciling transactional data and settlement results, monitoring and executing contractual and regulatory commitments, properly documenting settlement activities and procedures, and supporting the information needs of other groups within AEP. Responsible for understanding settlement requirements and procedures for execution. Complies with all guidelines and standards, including Sarbanes-Oxley and regulatory accounting policies.

Job Description

WHAT YOU'LL DO
- Enter transaction and billing determinant data into systems.
- Reconcile data between systems under the direction of others.

- Prepare, administer and analyze invoice and allocation results against contractual and regulatory commitments and resolve discrepancies.
- Document desktop procedures and operate settlement systems in compliance with existing desktop procedures, ensuring functions are completed according to defined schedules. Recommend and participate in implementation of process improvements.
- Estimate and actualize revenue, expense, and allocations to operating companies and General Ledger accounts. Assist in analytical review of settlement results.
- Maintain and organize contract files, invoices, audit requests, regulatory documentation and documentation related to the closing cycles.
- Prepare basic schedules, exhibits, and documents to support regulatory filings and request for information.
- Demonstrates understanding of wholesale contracts, regulatory agreements, and RTO settlements.
- Demonstrates understanding of the relationship between application functions and governing agreements. Use pre-existing application functions and reporting tools to provide informational support to financial and operational functions. Develops / enhances reporting tools of limited complexity.
- Participates and provides support to management for special projects.

WHAT WE'RE LOOKING FOR

Based on education, experience, interview and internal equity, this opportunity will be filled commensurately at either title. For this posting, minimum requirements are stated the lower grade. Increased expectations are at the higher grade.

RTO Settlements Analyst Sr. (grade 7): Base Salary = $88K - 109K

RTO Settlements Analyst (mid-level) (grade 6): Base Salary = $75K - $93K
Education:

  • Bachelor's degree in Business, Finance, Accounting, or relevant field.
  • Will consider no degree with four or more (4+) years of related industry experience in settlements, accounting, and/or commercial operations.

Work Experience:
Minimum of two (2) years related experience in utility industry.
OTHER REQUIREMENTS:
Physical demand level is Sedentary
 

- Technical Skills: experience with database skills and programming languages: SQL, VBA, R. Information Technology (IT)-related experience related to business processes is preferred for this role.

- Ability to work as part of a team and possess excellent time management and organization skills.

- Experience in Microsoft Excel is required.

- Adhere to Sarbanes-Oxley controls and participate in testing those controls.

- Candidate must be motivated, have initiative, and be eager to excel.

WHAT YOU'LL GET

Base Salary: approximately $75K - $109K

In addition to base salary, AEP offers competitive Total Rewards including: discretionary annual incentive, 401(k), pension, health insurance, vacation, educational assistance, etc.

WHO WE ARE

At AEP, we’re more than just an energy company — we’re a team of dedicated professionals committed to delivering safe, reliable, and innovative energy solutions. Guided by our mission to put the customer first, we strive to exceed expectations by listening, responding, and continuously improving the way we serve our communities. If you're passionate about making a meaningful impact and being part of a forward-thinking organization, this is the company for you!

AMERICAN ELECTRIC POWER (on-site)

$75K - $109K / Year

#AEPCareers

#LI-ONSITE

Compensation Data

Compensation Grade:

SP20-006

Compensation Range:

$74,551.00 - $109,543.00

The Physical Demand Level for this job is: S – Sedentary Work: Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently. (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.  

Hear about it first!   Get job alerts by email.  Log in to your Candidate Home Account today!  If you don't have an account, you can create one.

It is hereby reaffirmed that it is the policy of American Electric Power (AEP) to provide Equal Employment Opportunity in all respects of the employer-employee relationship including recruiting, hiring, upgrading and promotion, conditions and privileges of employment, company sponsored training programs, educational assistance, social and recreational programs, compensation, benefits, transfers, discipline, layoffs and termination of employment to all employees and applicants without discrimination because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, veteran or military status, disability, genetic information, or any other basis prohibited by applicable law. When required by law, we might record certain information or applicants for employment may be invited to voluntarily disclose protected characteristics.

Skills Required

  • Bachelor's degree in Business, Finance, Accounting, or a relevant field
  • Four or more years of related settlements, accounting, and/or commercial operations experience if substituting for a degree
  • At least two years of related experience in the utility industry
  • Experience with database skills and SQL, VBA, and R programming languages
  • Information Technology experience related to business processes
  • Microsoft Excel experience
  • Ability to adhere to Sarbanes-Oxley controls and participate in control testing
  • Excellent teamwork, time management, and organizational skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Columbus, OH
12,632 Employees

What We Do

Our team at American Electric Power is committed to improving our customers' lives with reliable, affordable power. We are investing $54 billion from 2025 through 2029 to enhance service for customers and support the growing energy needs of our communities. Our nearly 16,000 employees operate and maintain the nation's largest electric transmission system with 40,000 line miles, along with more than 225,000 miles of distribution lines to deliver energy to 5.6 million customers in 11 states. AEP also is one of the nation's largest electricity producers with approximately 29,000 megawatts of diverse generating capacity. We are focused on safety and operational excellence, creating value for our stakeholders and bringing opportunity to our service territory through economic development and community engagement. Our family of companies includes AEP Ohio, AEP Texas, Appalachian Power (in Virginia and West Virginia), AEP Appalachian Power (in Tennessee), Indiana Michigan Power, Kentucky Power, Public Service Company of Oklahoma, and Southwestern Electric Power Company (in Arkansas, Louisiana, east Texas and the Texas Panhandle). AEP also owns AEP Energy, which provides innovative competitive energy solutions nationwide. AEP is headquartered in Columbus, Ohio. For more information, visit aep.com.

Similar Jobs

INTOO Logo INTOO

Software Engineer

Other • Professional Services
Remote or Hybrid
14 Locations
70 Employees
100K-125K Annually

Ericsson Logo Ericsson

Ehs Specialist

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
16 Locations
88000 Employees
Hybrid
Westerville, OH, USA
289097 Employees

Wipfli Logo Wipfli

Data Management & Governance Analyst III

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
88K-132K Annually

Similar Companies Hiring

Runwise Thumbnail
Greentech • Hardware • Real Estate • Software • Energy • PropTech
New York, NY
199 Employees
Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
150 Employees
Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
55 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account