Senior / Principal Regulatory Affairs Modeling Analyst

Senior / Principal Regulatory Affairs Modeling Analyst

Supports regulatory affairs by providing economic and financial modeling, revenue requirement, pricing, and power-cost projections for corporate and regulatory projects and/or functions. May include conducting analyses of competitors, operational effectiveness and capacity utilization. Manages corporate and/or site budgets, generates forecasts, analyzes utilization and serves as internal consultant on financial matters for the organization. Creates financial models of scenarios for future business planning decisions.

Economic Analysis

• Develops economic analyses for significant and complex corporate projects and/or functions, including examining economics/costs under uncertainty
• Directs the activities of at least one other team member in completing the analysis

Financial Models

• Develops longer-term financial models within UI Planner software with complex assumptions or relationships (e.g., models that will receive a high level of scrutiny internally and by regulatory groups)
• Coordinates with other departments to ensure model assumptions/outputs align across the organization

Reporting

• Develops end-to-end load-forecasting models with complex algorithm and presents to management and internal stakeholders
• Identifies, designs and implements process improvements of the load-forecasting models

Internal Consulting

• Develops reports documenting complex analyses
• May be responsible for preparing annual budgets and/or strategy reports including metrics and measurements

External Interaction

• Presents analysis and work products to clients and senior management
• May direct external consultants to complete projects

Education/Experience/Certifications

• Requires a bachelor’s degree in finance, business, economics or other related field or equivalent experience
• Typically, five or more years in related field
• Experience with UI Planner

Competencies (Knowledge, Skills, Abilities)

• Functional Competencies:
  • Intermediate knowledge of fundamental economic, business and accounting principles
  • Advanced knowledge of macroeconomics and microeconomics, pricing theory, finance, accounting and financial analysis
  • Advanced financial modeling skills and experience using Microsoft Excel
  • Intermediate knowledge of regulated utility operations, revenue requirements, utility accounting principles (e.g., rate-base return standard, AFUDC), wholesale power market and the basics of power plant and transmission system operation and market fundamentals
  • Intermediate mathematical skills, including calculus, ordinary and partial differential equations, linear algebra, probability and multivariate statistics
• General Competencies:
  • Intermediate business acumen
  • Intermediate problem-solving skills
  • Advanced written and oral communication skills
  • Intermediate analytical thinking skills
  • Intermediate organization and prioritization skills

Senior AND Principal Levels

• Key Responsibilities:
  • Economic Analysis: Leads the development of economic analyses for significant and complex corporate projects and/or functions; provides QA of models developed by other team members
  • Financial Models: Leads the development of longer-term financial models with complex assumptions or relationships (e.g., models that will receive a high level of scrutiny internally and by regulatory groups); develops plans/schedules and leads efforts to ensure schedules are met
  • Reporting: Leads the development of load-forecasting models, adding functionality and flexibility to the model for increased accuracy and more flexibility; presents the results to internal and external stakeholders; participates in the data gathering, system designs and business processes across silos to feed the load-forecast model
  • Internal Consulting: Develops standards/guidelines for reports documenting analyses; develops and maintains business rules and data hierarchies
  • External Interaction: Leads effort to provide other departments with comprehensive responses to all planning inquiries; delegate or redirect questions as appropriate
• Education/Experience/Certifications:
  • Requires a bachelor’s degree in finance, business, economics or other related field or equivalent experience
  • Typically, eight or more years in related field
  • Experience with UI Planner
• Competencies (Knowledge, Skills, Abilities):
  • Functional Competencies:
    • Advanced knowledge of fundamental economic, business and accounting principles
    • Advanced knowledge of macroeconomics and microeconomics, pricing theory, finance, accounting and financial analysis
    • Advanced financial modeling skills and experience using Microsoft Excel
    • Expert knowledge of regulated utility operations, revenue requirements, utility accounting principles (e.g., rate-base return standard, AFUDC), wholesale power market and the basics of power plant and transmission system operation and market fundamentals
    • Advanced mathematical skills, including calculus, ordinary and partial differential equations, linear algebra, probability and multivariate statistics
  • General Competencies:
    • Intermediate knowledge of enterprise/business awareness
    • Advanced decision-making skills
    • Advanced negotiation skills
    • Advanced diplomacy skills
    • Advanced organization and prioritization skills

Physical and Cognitive Demands

• Cognitive Level: Intermediate
• Schedule/Attendance: Daily within service territory - Frequently (at least once a week or more)
• Computer use: Use computer regularly for entire work shift
• Environment: Indoor Office – hybrid – 3 days per week in office

Total Compensation

Actual total compensation, including a performance based incentive bonus, is commensurate with experience, skills, qualifications, education, training, and internal equity. PGE believes in rewarding dedicated performance. We provide a total rewards package that is designed to reward your contributions to the company, and, at the same time, support your well-being and professional development, both now and into the future. To find out more, click here.