Principal Financial Data Analyst

At PGE, our work involves dreaming about, planning for, and realizing a smarter, cleaner, more enduring Oregon neighborhood. Its core to our DNA and we haven’t stopped since we started in 1888. We energize lives, strengthen communities and drive advancements in energy that promote social, economic and environmental progress. We’re always on the lookout for people passionate about leading and being a part of teams that are advancing innovative clean energy solutions that are also affordable and accessible to all.

SUMMARY

As a Principal Financial/Data Analyst, you will have the unique opportunity to develop economic analyses for significant and complex projects, shaping Trojan’s financial strategy in accordance with the Trojan’s commitment to the Federal government. You will create sophisticated long-term financial models with complex assumptions, ensuring accuracy and flexibility in load forecasting and data to drive informed business decisions. You’ll be managing daily requisitions, invoices, purchase orders, inventory management, work order data, and all site labor costs associated with ISFSI Operations, interfacing with government regulators and external financial legal firms that assist PGE in the costs associated with the Trojan Decommissioning Fund.  A successful candidate will have advanced knowledge of macroeconomics, microeconomics, databases, statistics, regulated utility operations, data analytics, contract negotiations, coupled with expert financial modeling skills, and advanced decision-making abilities. This role offers the chance to directly impact Trojan’s license commitment to maintain the decommissioning fund which is PGE’s requirement to the Federal government through strategic financial planning, data analyses, tracking and trending, and to present critical insights to both internal/external stakeholders, regulatory bodies, and Trojan Co-Owners.

KEY RESPONSIBILITIES

Economic Analysis - Leads the development of economic analyses for significant and complex corporate projects and/or functions; provides QA of models and data

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 with project and program teams

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; leads in the data gathering, system designs and business processes across silos to feed the load-forecast model

Internal Consulting - Develops standards/procedures 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. Represent PGE/Trojan when consulting with external financial firms and government agencies

Financial Systems - Presents information and provides advice guidance on complex or escalated information requests for presentation to Department of Energy and the Nuclear Regulatory Commission.

EDUCATION/EXPERIENCE/CERTIFICATIONS

Education

• Requires a bachelor's degree in finance, business, economics or other related field or equivalent experience.

Experience

• Typically eight or more years in related field.

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 knowledge of databases and data collection systems and implementation

• Advanced ability to work with management on critical metrics and KPIs

• Advanced financial modeling skills and experience using Microsoft Excel

• Advanced knowledge of Office 365 programs, i.e. SharePoint

• Advanced knowledge of DevonWay system

• Expert knowledge of regulated utility operations, Nuclear Decommissioning Trust Funds, 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

• Advanced knowledge of fundamental economic, statistics, data visualization, business and accounting principles

General Competencies

• Intermediate knowledge of enterprise/business awareness

• Expert ability to identify, analyze, and interpret trends and pattern in complex data sets

• Advanced communication and presentation skills

• Advanced decision-making and critical thinking skills

• Advanced negotiation and business acumen skills

• Advanced diplomacy skills

• Advanced organization and prioritization skills

PHYSICAL, COGNITIVE DEMANDS AND SCHEDULE/ATTENDANCE

Physical

• Does the job require a valid driver's license? - No

• Driving/travel/commute: Daily within service territory - Occasionally (one to two times a month or less)

• Computer use (use computer regularly for entire work shift)

Cognitive Demands

• Ability to adhere to set response times, deadlines and time-sensitive tasks

• Ability to follow accuracy standards and procedures

• Ability to follow through on decision-making tasks

• Ability to interact effectively and collaboratively within a team environment

• Ability to communicate and problem solve when under stress

• Ability to respond and adapt to frequent change

• Ability to accept and demonstrate self-awareness when provided constructive feedback

• Ability to discern feedback and acknowledge ownership of areas of improvement

• Ability to avoid future mistakes by applying reasonable skills to new but similar work situations or tasks

• Ability to successfully collaborate with peers, managers and others within the organization

• Demonstrates sound memory

• Ability to process new information to be applied consistently to work tasks

Schedule/Attendance

• Ability to work long hours [typically for exempt positions; if included in nonexempt positions, overtime applies]

• Ability to work a variable schedule

• Ability to report to work and perform work during periods of severe inclement weather

• Ability to consistently meet attendance standards for regular, reliable, predictable, full-time attendance [for part-time positions, change to part-time attendance]

Environment

• Office environment

• Plant environment

Compensation Range:

$107,025.00 - $178,375.00

Actual total compensation, including a performance based incentive bonus, is commensurate with experience, skills, qualifications, education, training, and internal equity. While we anticipate the selected candidate for this position will fall towards the middle or entry point of the compensation range, the decision will be made on a case-by-case basis.

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.

Join us today and power your potential!

Assisting with storms or other Company emergencies is a part of all positions at Portland General Electric.

PGE is committed to diversity and inclusion in the workplace and is an equal opportunity employer. PGE will not discriminate against any employee or applicant for employment based on race, color, national origin, gender, gender identity, sexual orientation, age, religion, disability, protected veteran status, or other characteristics protected by law.

PGE does not discriminate on the basis of disability. We recognize individuals have a variety of abilities to offer and we believe there is much to value and celebrate by incorporating different abilities into the work we do. One very important way we live this out is in our application and interview process. We work hard to support individuals who may need an accommodation to fully participate in these processes. If you feel you may need an accommodation, or would like to request one, please notify the Talent Acquisition Specialist (Recruiter) associated with the job posting. You may also make this request by contacting [email protected] or by calling 503-464-7250. The Recruiter will provide information and next steps for the accommodation process.  Our Diversity, Equity & Inclusion (DEI) team is also available for support.  You can contact them at [email protected].

To be considered for this position, please complete the following employment application by the posting close date.  Posting closes at midnight (Pacific Time) on the closing date below. If no date is listed, job is open until filled.