Portfolio Risk Analyst: Advanced Analytics & Reporting

First Interstate Bank; Billings (MT); On-site; USD 79,000 - 126,000; Full time

Benefits offered by this job

PTO and holidays

Student debt repayment

401(k) match

Job summary

First Interstate Bank is seeking a Portfolio Risk Analyst to monitor risk across the loan portfolio and develop risk-related reports. The role involves performing advanced analyses, supporting analytics capabilities, and generating monthly and ad hoc reports for cross-functional teams.

The candidate should have strong SQL, Excel, and data-management skills, plus experience in credit risk and portfolio performance. Regular collaboration with Risk Management and Finance is expected.

Qualifications

• Bachelor's degree required with 7–9 years banking experience.
• Experience with credit risk analytics and reporting.
• Strong analytical and communication skills.

Responsibilities

• Performs enhanced analysis of portfolio trends and loan-level inputs.
• Develops credit risk analytics capabilities and reporting.
• Oversees monthly department performance monitoring and data input tracking.
• Tests and generates industry and portfolio segment reports from LOS data.
• Supports portfolio reviews for risk outlook and appetite monitoring.
• Produces analytical materials for cross-functional discussions.
• Delivers monthly, annual, and ad hoc loan portfolio reports.

Skills

SQL code

Portfolio analysis

Advanced Excel

Risk management

Data management

Education

Bachelor's degree in Business, Finance, Accounting, or related field

Tools

Fiserv

CreditTrack

Primatics

SQL

Job description

First Interstate Bank is seeking a Portfolio Risk Analyst to monitor risk across the loan portfolio and develop risk-related reports. The role involves performing advanced analyses, supporting analytics capabilities, and generating monthly and ad hoc reports for cross-functional teams.

The candidate should have strong SQL, Excel, and data-management skills, plus experience in credit risk and portfolio performance. Regular collaboration with Risk Management and Finance is expected.