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

AEP; Columbus (OH); On-site; USD 75,000 - 109,000; Full time

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

## \"IT Leaning\" RTO Settlements Analyst (Mid - Sr) | COMMERCIAL OPERATIONS (SQL, VBA)Apply: Columbus, OH: Full time: Posted Today: End Date: October 14, 2026 (6 days left to apply): R16801**Job Posting End Date**10-14-2026Please 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