Analyst

Analyst Intern – BNC National Bank, Golden Valley, MN

Job Summary 

Intern role will provide technical and analytical support to VP-Investment Officer and Chief Investment Officer in the areas of interest rate risk modeling, budgeting and forecasting, liquidity risk measurement and reporting, preparation of Asset/Liability Management Committee agenda materials and presentations, wholesale funding and investment portfolio management.  Successful individual will also serve as a knowledgeable, trained back up, in support of VP-Investment Officer for modeling and Asset/Liability management reporting functions.

Major Responsibilities

1. Liquidity Risk Measurement and Reporting:            
   • Prepare reports that aid in measuring/monitoring liquidity risk position and modeling of potential strategy impacts
   • Measure and communicate collateral arrangements
   • Track and analyze key customer relationships
   • Work with members of Senior Management to track funding sources/uses
2. Interest Rate Risk Modeling
   • Compile cash flow data of various investment securities
   • Assist in internal liability pricing strategies and analysis
   • Draft detailed narratives as it pertains to liquidity risk monitoring, earnings-at-risk, and model back testing
3. Budgeting and Forecasting
   • Analyze internal financial reports and metrics with comparable peer groups
   • Serve as trained support/backup in processing of models
   • Create board presentations using PowerPoint
   • Aid in internal valuation and peer study comparisons
4. Asset/Liability Management Committee:
   • Provide support and technical analysis with respect to asset/liability modeling
     • Interest rate risk, economic value of equity, total return analysis
     • Stress testing
     • Historical comparisons and benchmarking
   • Track funding strategy analysis and execution
   • Assure compliance with both internal and external policies and standards
   • Complete various statistical studies that serve in validating/determining asset/liability modeling assumptions and strategies
5. Other Responsibilities may include:
   • Complete various ad hoc projects for C-suite executives 
   • Compile source data for profitability measurement
   • Maintain internal loan pricing model/methodology
   • Provide support to wealth management division
     • Executing client investment strategies
     • Analyzing market metrics
     • Complete various ad hoc reports and presentations
   • Conduct market and peer group research
   • Assist in credit loss measurement and modeling
   • Effectively communicate with various third-party vendors
   • Due diligence report on vendor relationships

Qualifications

• Two years of college coursework in one or more of the following disciplines: finance, accounting, investments
• Proficiency in Microsoft Word, Excel, and Outlook
• Strong mathematical aptitude
• Strong aptitude for mastering software applications
• Effective communication with internal and external customers
• Maintains a high degree of confidentiality
• Detail oriented, self-starter who proactively follows up to confirm and meet expectations