Prepare for and practice interview questions from Portland General Electric.

Portland General Electric Interview Questions

Portland General Electric Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Statistics

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

A/B Testing & Experimentation

<div><h2>Settlements Analyst</h2>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.The Settlements Analyst will be responsible for settling commodity transactions for various Counterparties which involves resolving data issues. Provide support in the settlement of all revenue agreements and power purchase agreements including resolution of disputes, interacting with the contracts team to obtain consensus of contractual interpretations, establishing recommendations and conclusions based on analysis of complex data and monitoring and providing technical direction to aid in settling disputes. Assist with analyzing and improving the settlements process, including designing metrics for measuring group performance.Develops and implements process controls and cost-effective approaches to minimize the organization's financial risks. Working and communicating with various customers and internal key groups to compile and analyze data. Manages the approval and maintenance of vendor/counterparty settlements agreements and invoicing activities.Career Level SummaryIntermediate: Requires expanded professional-level knowledge and experience in own area; incumbents continue to acquire higher-level knowledge and skills<ul><li>Expands on high-level knowledge of the company, processes and customers</li><li>Solves a range of more complex problems</li><li>Analyzes possible solutions using advanced knowledge and applying protocols</li><li>Operates independently and receives only a moderate level of guidance and direction</li><li>May support data requests</li><li>May support and participate cross departmental collaboration or process improvements</li></ul>Career: Requires in-depth knowledge and experience<ul><li>Uses best practices and knowledge of internal or external business issues to improve products or services</li><li>Solves complex problems; takes a new perspective using existing solutions</li><li>Works independently; receives minimal guidance</li><li>Acts as a liaison lead/or consulting resource for Settlements middle office operations</li><li>Lead and facilitate complex cross departmental collaboration or process improvements and demonstrate ability to lead multiple special projects and/or activities designed to resolve pain points</li></ul>Key ResponsibilitiesFinancial Risk Analyst, Settlements:<ul><li>Billing: Generating Counterparty invoices/remittances for bilateral power, financial swaps, renewable energy credits, transmission, and fuel in accordance with contractual terms. Contacting counterparties to timely resolve billing discrepancies or follow up with past due accounts receivables. Researches, analyzes, and resolves transaction data corrections.</li><li>Risk Analysis: Conducts analyses and develops reports; provides data and supports the review and validation of financial risk analysis decisions.</li><li>Regulatory Analysis: Provides data and reporting for various regulatory analyses and compliance requirements; advises other departments of risk management policies and regulations.</li><li>Data Management Tools: Ensures the integrity of data in systems used. Notifies appropriate parties of data and software issues encountered.</li><li>Contracts Administration: Identify and translate contractual agreement between energy buyers and sellers as it relates to the Settlements activities. Provide feedback as needed for project approval summary and system deal testing.</li></ul>Senior Financial Risk Analyst, Settlements:<ul><li>Billing: Generating Counterparty invoices/remittances for bilateral power, financial swaps, renewable energy credits, transmission, and fuel in accordance with contractual terms. Contacting counterparties to timely resolve billing discrepancies or follow up with past due accounts receivables. Researches, analyzes, and resolves transaction data corrections.</li><li>Risk Analysis: Conducts analyses and develops reports; provides data and supports the review and validation of financial risk analysis decisions.</li><li>Regulatory Analyses: Leads reporting efforts for regulatory analyses and compliance requirements; advises senior leadership of risk management</li><li>Data Management Tools: Ensures the integrity of data in systems used. Notifies appropriate parties of data and software issues encountered.</li><li>Contracts Administration: Identify and translate contractual agreement between energy buyers and sellers as it relates to the Settlements activities. Provide feedback as needed for project approval summary and system deal testing.</li><li>Audit Support: Interface with auditors to provide information and support/walkthrough as requested.</li><li>Continuous Process Improvements: Lead the Settlements team in the analysis and measurement of the effectiveness of existing processes and develops business process improvements. Researches and implements best business practices.</li></ul>QualificationsFinancial Risk Analyst<ul><li>Education: Requires a bachelor's degree in accounting, finance, economics or other related field or equivalent experience</li><li>Experience: Typically two or more years in related field</li></ul>Senior Financial Risk Analyst<ul><li>Education: Requires a bachelor's degree in accounting, finance, economics or other related field or equivalent experience</li><li>Experience: Typically five or more years in related field</li></ul>CompetenciesFunctional Competencies<ul><li>Intermediate/Advanced knowledge of risk management concepts including claims, insurance and loss prevention, credit analyses and security interests</li><li>Strong working knowledge of financial analysis and valuation</li><li>Working knowledge of SOX (Sarbanes-Oxley Act) and compliance requirements</li><li>Advanced Excel skills and financial modeling experience</li><li>Proficient on MS Word, Excel, Access, Power Point, etc.</li><li>Intermediate knowledge of relevant software tools and report generator applications</li><li>Working knowledge of electrical system operations</li><li>Intermediate/Advanced financial modeling skills and experience using Microsoft Excel</li></ul>General Competencies<ul><li>Working/Intermediate knowledge of enterprise/business acumen</li><li>Working/Intermediate problem-solving skills</li><li>Intermediate/Advanced written and oral communication skills</li><li>Intermediate organization and prioritization skills</li><li>Working/Intermediate analytical thinking skills</li></ul>Physical, Schedule/Attendance and Cognitive DemandsCognitive Level: Financial Risk Analyst: Intermediate - Consistent use of relevant principles to solve practical problems and to deal with a variety of concrete variables in situations where only limited standardization existsSenior Financial Risk Analyst: Substantial - Consistent use of logic or scientific thinking to define problems, collect information, establish facts, and draw valid conclusionsCognitive: Ability to adhere to set response times, deadlines and time-sensitive tasksAbility to follow accuracy standardsAbility to follow through on decision-making tasksAbility to interact effectively and collaboratively within a team environmentAbility to communicate and problem solve when under stressAbility to respond and adapt to frequent changeAbility to accept and demonstrate self-awareness when provided constructive feedbackAbility to discern feedback and acknowledge ownership of areas of improvementAbility to avoid future mistakes by applying reasonable skills to new but similar work situations or tasksAbility to successfully collaborate with peers, managers and others within the organizationDemonstrates sound memoryAbility to process new information to be applied consistently to work tasksSchedule/Attendance: Ability to work long hoursAbility to work a variable scheduleAbility to report to work and perform work during periods of severe inclement weatherAbility to consistently meet attendance standards for regular, reliable, predictable, full-time attendancePhysical Capabilities: Driving/Travel/Commute Daily within service territory<ul><li>Frequently (one to two times a month or less)</li></ul>Overnight inside/outside the service territory<ul><li>Occasionally (one to two times a month or less)</li></ul>Computer Use<ul><li>Use computer regularly for the entire work shift</li></ul>Environment: Office EnvironmentHybrid 3 days onsite, 2 days WFHCompensation Range:$74,325.00 - $148,625.00Actual</div>

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
Random Bucketing	A/B Testing & Experimentation	Medium	Very High

Portland General Electric Interview Questions

Portland General Electric Interview Guides

Portland General Electric Interview Questions

Portland General Electric Opening Jobs