Energy Risk Data Analyst Associate

AEP Service Corporation; United States; On-site; USD 64,000 - 79,000; Full time

Benefits offered by this job

Discretionary incentives

401(k)

Pension

Health insurance

Vacation

Educational assistance

Job summary

American Electric Power (AEP) is seeking a risk/analytic professional to support contract data updates, monitor volumetric risk, and study market trends to improve pricing and forecasting for its booked electric business.

The role emphasizes data integrity, reporting, and regulatory compliance, with opportunities to develop SQL/VBA skills and analytics within an on-site environment in the United States.

Qualifications

• Bachelor’s Degree required in business discipline such as Finance, Accounting, Economics, Math, etc.
• 1 year energy experience is a plus but not required.
• Intermediate Excel skills (pivot tables, lookups, complex spreadsheet design) are needed.

Responsibilities

• Perform daily maintenance of risk positions and market deal valuations.
• Research market changes and regulatory filings.
• Ad hoc analysis of customer usage behavior and pricing impacts.
• Coordinate with Pricing and Usage Data Management to implement usage profiles in Risk database.
• Recommend and test enhancements to Risk systems and processes.
• Execute SOX and business controls for volumetric tracking across Risk, Pricing, and Billing systems.
• Audit contract data for data integrity and forecasting accuracy.
• Create custom reports from the risk database.
• Coordinate filing of Renewable Portfolio Standard and Green-E requirements.
• Ensure compliance with EIA and other reporting requirements.

Skills

Excel

Problem-solving

Analytical thinking

Energy industry interest

SQL

VBA

Education

Bachelor’s degree in business/finance/economics/math

Tools

SQL

VBA

Job description

American Electric Power (AEP) is seeking a risk/analytic professional to support contract data updates, monitor volumetric risk, and study market trends to improve pricing and forecasting for its booked electric business.

The role emphasizes data integrity, reporting, and regulatory compliance, with opportunities to develop SQL/VBA skills and analytics within an on-site environment in the United States.