Whole Loan Analyst
Phoenix Group is a leading advisory firm to the mortgage banking industry, seeking a qualified Whole Loan Analyst to join their Whole Loan Analytics team. The analyst will review and cleanse residential and commercial whole loan data, work with account executives, and perform detailed pricing analyses on live whole loan offerings.
Responsibilities
- Become an expert in understanding and analyzing residential and commercial loan characteristics
- Learn the CAS software (Collateral Analysis System from the Carlisle Group). Become an expert in importing/exporting data, scripting, data integrity, and reporting
- Further develop and refine PHOENIX’s existing whole loan data ingestion process (create and manage data edits, create buyer specific import templates, etc.). Analyst will utilize Excel, CAS, Snowflake, SQL, and Sigma
- Process loan data (from Excel files) for PHOENIX’s market distribution and produce reporting of missing data points necessary to obtain bids
- Tracking and organization of all bid pricing received on trades out to market
- Produce reporting for all weekly/monthly/quarterly market trading activity for account executives and trade desk
- Perform pricing analyses for live deals presented for investment consideration
- Perform review of borrower payment histories to reconcile borrower cash remittances and produce payment delinquency string
- Prepare and perform general industry and market analyses (e.g., synthesize complex data, trends, analyses, etc. from a variety of sources and formats into thorough but concise reporting for internal and external purposes)
Skills
- Advanced Excel experience required
- Analyst should have excellent written and verbal communication skills and keen ability to collaborate with various teams
- Detail oriented with clear ability to connect dots across multiple data sources and market conditions
- Strong analytic abilities, financial aptitude, and attention to detail
- Comfortable with the expectations and opportunities that come with working for a smaller, merit-based, entrepreneurial organization
- Self-starter with the ability to move forward and make decisions absent complete information
- Understanding of the loan origination process, interest rates, and general financial market conditions preferred
- Undergraduate and/or advanced degree in Finance, Financial Modeling, MIS, Accounting, or a related field preferred
- 0-2+ years of mortgage industry experience
- Experience with CAS, Snowflake, and scripting highly valued
- Experience with Whole Loan Trading, MSR Trading, and discounted cashflow modeling preferred
Benefits
- Competitive salary
- Discretionary bonus
- 401(k) including match and discretionary profit sharing
- Health insurance
- Dental insurance
- Vision insurance
- Employee assistance program
- Flexible schedule
- Paid time off
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible schedule
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Profit sharing
- Vision insurance
Company Overview