Job Posting End Date

09-17-2024

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

Commercial Reporting Analyst Sr

Job Description

Commercial Reporting Analyst Sr

Location: 1 Riverside Plaza, Columbus, OH 43215

Job Duties:

Perform special studies to provide financial and data analysis supporting Commercial Operations, Generation, and Accounting/Finance. Report and provide analysis on various weekly, monthly, and quarterly results involving fossil generation, renewable energy operations and RTO settlements, including market congestion and curtailment events. Perform budget to actual comparisons of various financial and commercial services operational results, including RTO market settlements, LMPs and renewable energy management, and provide analysis of the results. Develop and analyze data sets to support reported or new SEC and/or regulatory filings. Participate in problem solving in a collaborative environment to address all opportunities and risks with innovative, creative, optimized, safety minded solutions. Maintain knowledge and understanding of accounting and operational changes impacting reporting requirements. Respond to ad-hoc requests to support Commercial Operations, Regulatory, audits, and renewable studies with minimal supervision. Facilitate meetings and manage small initiatives to completion with minimal supervision. Support the Risk Management processes and reporting including hedging valuation analysis, maintaining SOX controls and evidence archiving. Additional responsibilities include deep-dive studies of financial or operation results and FERQ EQR reporting. Develop and implement process improvements with reporting and database queries. Hybrid work from home policy may apply.

Salary range: $83,413 to $104,267.50

Requirements:

Master’s degree in Business, Economics, Engineering, Mathematics, or a related quantitative field and 4 years of experience in the energy industry as follows:

• Developing analytical models to predict operational behavior from historical energy usage and conducting statistical analysis.

• Managing report storage, retrieval, and aggregation of financial and operational data primarily through databases, Excel, and industry applications using VBA, SQL, and Python/R.

• Building analytical models using Excel and VBA.

• Analyzing RTO market curtailments and renewable energy management results.

• Building and enhancing automations using tools such as Power BI, SharePoint, SQL, VBA or other industry applications.

• Reviewing and analyzing renewable utility / industry engineering designs and one-line drawings.

• Renewable energy project assessments, performance testing and post-commissioning activities.

• Reviewing and analyzing utility and generation rates, LMPs and arbitrage scenarios.

• Developing tools to optimize power demands.

Alternatively, a Bachelor’s degree and 6 years of experience as specified above are acceptable.

Candidates will be considered based on their qualifications and the candidate’s ability to work from an approved work location. Although the location is flexible, AEP does not have a presence in all states and localities. The following locations are NOT currently approved for this position: AK, CO, CT, DE, HI, IA, ID, KS, MA, ME, MS, MT, ND, NH, NJ, NM, NV, NY, OR, RI, SD, UT, VT, WY, US Territories or international work locations. AEP will consider qualified candidates who are willing to relocate to an approved work location, at the candidate’s expense, provided the relocation can be completed within a timeframe that meets AEP’s staffing needs. NOTE: All remote work locations require vetting and final approval prior to offer and/or start date. Any work locations listed as preferred or unapproved relate specifically to the requirements for this position and are not necessarily applicable to other posted positions.

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 aspects 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, age, national origin, ethnicity, ancestry, veteran or military status, disability, genetic information, sexual orientation, gender identity, or any other basis prohibited by applicable law. When required by law, we must record certain information to be made part of an Affirmative Action Plan. Applicants for employment may also be invited to participate in the Affirmative Action Program by self-identifying their Race or Ethnic Identity.