Financial Data Analyst

Job Summary

The Member Credit Analyst performs critical job tasks that support the company’s loan participation program and lending activities.

The role encompasses duties of traditional lending combined with analytics and elements of investment activities.

The ideal person will have previous analytical experience working with relational databases, business intelligence platforms, and / or predictive modeling software.

The Analyst is responsible for compiling data from clients for analysis, and decision making.

Responsibilities include ingesting and validating unstructured data from a variety of sources to standardized outputs, which drive credit and valuation models.

Must possess proficiency with SQL and data transformation (ETL) tools.

• For the Loan Participation Program, the position is responsible for evaluating credit quality, leverage, and other risk metrics of consumer loans to be packaged into a portfolio for potential sale.
• The analysis requires knowledge of credit underwriting principles, market interest rates and credit spreads for pricing portfolios for sale.

After the sale transaction has settled, the Analyst manages the outstanding participation, compiles monthly investor reporting and portfolio performance statistics from seller data files.

• For the organization’s lending activities, the position will be responsible for managing the credit model used to evaluate and risk rate’ and monitor financial institutions that have been extended credit.
• Utilizing knowledge of financial institution analysis and independent judgment the Analyst evaluates counterparty risk and recommends whether adjustments regarding disposition of the members’ lines of credit are warranted.
• The position also requires a strategic mindset with the ability to assess work functions for opportunities to automate and improve the efficiency of the department.

Innovation and the concept of continuous improvement are underlying foundations of the job.

• Individually and in collaboration with other team members, critical thinking skills and the ability to visualize, develop and articulate a proposed solution lead to successful outcomes.
• The position serves as back-up to the Manager Loan Participations and Credit

Essential Duties and Responsibilities :

Transform unstructured data sets to desired outputs to analyze prospective LP client loan portfolios for packaging into a loan participation to be sold to other credit unions.

The selection criteria for loans in the portfolios include a variety of credit and risk related factors including analyst’s independent judgement of generally acceptable lending criteria and marketability.

• Compile, review and analyze LP due diligence documentation packages for completeness and accuracy and resolve any omissions or discrepancies.
• Manage constant changing data received from clients and build accurate and reliable workflows as needed.
• As an administrator to the loan participation website, coordinate with the Manager Loan Participations and Credit to manage user accounts and LP sales activity processed through the site.
• Manage the LP Remittance and Reporting functions. Onboard new clients and utilize ETL processes to convert client data to required structure for processing, analysis and reporting.
• Manage UCC financing statements to ensure that collateral supporting the client's extensions of credit are properly perfected and maintained.
• Support department operations by responding to client inquiries regarding loan participations, lines of credit and term loans, provide loan processing support and other functions as needed or requested by the Manager Member Loan Participations and Credit.
• Assist the Manager Loan Participations and Credit or to the Vice President - Member Credit for certain actions related to members’ lines of credit.

Compile internal and external data to complete credit reviews and assess counterparty risk.

• Adhere to the organization wide service objectives, the Member Credit
• Department’s Service Standards, and he company’s behaviors of trust.
• Comply with all provisions of the company’s Member Credit Policy and the Member Credit Department’s Procedures Manual.

Non-Essential Duties and Responsibilities :

• Assure the due diligence documents and other information pertaining to loan participation pools is properly Content Typed and Attributed in SharePoint.
• Purge old due diligence documents, loan files and financial information from the files that is beyond required retention timeframes.
• Provide loan processing support (initiating loan process resulting from a member inquiry and / or sending and obtaining all required executed loan documents from member) and other related functions as may be assigned by the Manager Loan Participations and Credit.
• Assisting the Member Credit team members in the preparation of credit reviews on credit unions on the company’s Watch List or Surveillance List and contacting members via telephone.
• Assist in completing credit inquiry and audit confirmation forms.

Qualifications

Education / Training Requirements

Essential Requirements :

• BS / BA in Computer Science, Information Systems, Finance, Mathematics or related field
• Experience designing and developing ETL workflows and datasets
• Analytical and problem-solving skills
• Understanding of Fixed Income Analysis / Valuation and / or Financial Analysis
• Advanced skills in Microsoft Excel (Macro, VBA)
• Strong communication skills both written and verbal
• Ability to work well in a fast-paced team environment
• Detail oriented, deadline-conscious with ability to coordinate multiple projects simultaneously
• Experience in credit analysis and loan / credit administration a plus.

Preferred Requirements :

• Proficient in Microsoft Power Suite of Applications
• Strong analytical skills; comprehensive understanding of loan underwriting processes and proficiency in calculating balance sheet and income statement ratios.
• At least three years lending institution experience with a background in all aspects of consumer or institutional lending.
• Strong proficiency in calculating key ratios and other mathematical indicators from a financial institution’s balance sheet, income statement or other financial data, inclusive of understanding how to interpret an apply such ratios and calculations.

Work Conditions and Environment :

• Office environment, some business travel may be required from time-to-time
21 hours ago