RTO Settlements Analyst – IT/Data Analytics (Mid-Sr)

AEP

Columbus (OH)

On-site

USD 75,000 - 109,000

Full time

3 days ago
Be an early applicant
Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

401(k)
Pension
Health insurance
Vacation
Educational assistance

Job summary

American Electric Power in Columbus, OH is seeking an IT Leaning RTO Settlements Analyst (Mid-Sr) to perform settlement activities under guidance, including invoicing, data reconciliation, and regulatory documentation. The role emphasizes adherence to SOX controls and accurate reporting using SQL, VBA, and R.

The position requires 2+ years in utility settlements, a Bachelor's degree (or 4+ years of related experience), and strong Excel skills.

Qualifications

  • Bachelor's degree in Business, Finance, Accounting, or relevant field.
  • 4+ years of related industry experience in settlements, accounting, and/or commercial operations.
  • Minimum of two years related experience in utility industry.
  • Adhere to Sarbanes-Oxley controls and participate in testing those controls.

Responsibilities

  • Enter transaction and billing determinant data into systems.
  • Reconcile data between systems under guidance.
  • Prepare, administer and analyze invoice and allocation results against commitments.
  • Document desktop procedures and operate settlement systems per procedures.
  • Develop and enhance reporting tools of limited complexity.
  • Support regulatory filings with schedules and exhibits.
  • Understand wholesale contracts, regulatory agreements, and RTO settlements.
  • Assist management on special projects.

Skills

Time management
Organization
Teamwork
initiative

Education

Bachelor's degree in Business, Finance, Accounting, or relevant field

Tools

SQL
VBA
R
Microsoft Excel

Job description

American Electric Power in Columbus, OH is seeking an IT Leaning RTO Settlements Analyst (Mid-Sr) to perform settlement activities under guidance, including invoicing, data reconciliation, and regulatory documentation. The role emphasizes adherence to SOX controls and accurate reporting using SQL, VBA, and R.

The position requires 2+ years in utility settlements, a Bachelor's degree (or 4+ years of related experience), and strong Excel skills.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

RTO Settlements Analyst — Data, Invoicing & Compliance
RTO Settlements Analyst — Data, Invoicing & Compliance

AEP Service Corporation • Columbus (OH)

On-site
USD 75,000 - 110,000
401(k)
Pension
Health insurance
+2
\"IT Leaning\" RTO Settlements Analyst (Mid - Sr) | COMMERCIAL OPERATIONS (SQL, VBA)
\"IT Leaning\" RTO Settlements Analyst (Mid - Sr) | COMMERCIAL OPERATIONS (SQL, VBA)

AEP • Columbus (OH)

On-site
USD 75,000 - 109,000
401(k)
Pension
Health insurance
+2
Energy Risk & Data Analyst Associate
Energy Risk & Data Analyst Associate

AEP Service Corporation • Columbus (OH)

On-site
USD 63,000 - 79,000
Health insurance
Pension plan
401(k)
Energy Risk & Data Analyst Associate
Energy Risk & Data Analyst Associate

AEP • Columbus (OH)

On-site
USD 63,000 - 79,000
\"IT Leaning\" RTO Settlements Analyst (Mid - Sr) | COMMERCIAL OPERATIONS (SQL, VBA)
\"IT Leaning\" RTO Settlements Analyst (Mid - Sr) | COMMERCIAL OPERATIONS (SQL, VBA)

AEP Service Corporation • Columbus (OH)

On-site
USD 75,000 - 110,000
401(k)
Pension
Health insurance
+2
Advanced Business Analyst – PJM Settlements & Data Insight
Advanced Business Analyst – PJM Settlements & Data Insight

FirstEnergy • Akron (OH)

On-site
USD 70,000 - 95,000
Senior Energy Settlements Analyst
Senior Energy Settlements Analyst

Iberdrola • Boston (MA)

On-site
USD 107,000 - 126,000
Performance bonuses
PTO
401(k) match
+3
Senior Complex Settlements Analyst — Power Invoicing
Senior Complex Settlements Analyst — Power Invoicing

AES Corporation • Houston (TX)

On-site
USD 80,000 - 100,000
Sales Operations & Analytics Specialist
Sales Operations & Analytics Specialist

American Electric Power • Columbus (OH)

On-site
USD 31,000 - 38,000
Base salary
Annual bonus
401K match
+2
ISO/RTO Settlements Analyst
ISO/RTO Settlements Analyst

Calpine Energy Solutions, LLC • San Diego (CA)

On-site
USD 70,000 - 88,000