Job description
Job DescriptionMinimum QualificationsSome experience intrading, reporting or financial analysisBachelors degreeinfinance,math,computerscience, a related fieldorequivalentexperienceProficiency with Microsoft Excel, including but not limited to, ability to utilize formulas, pivot tables, graphs and charts3-5 years experience of mortgage experience working in a reporting or analytics role.
Knowledge of mortgage cash flow modeling conceptsPreferred Qualifications
Experience with financial analysis and reportingKnowledge of Excel Modeling
Experience with writing basic SQL code to extract and analyze dataJob SummaryThe Portfolio Investments Analyst analyzesbusinessinformation and trends to inform or make strategic and/or trading decisions.
They support the Portfolio Investments by creatingand streamlining reports for both internal and external clients.
ResponsibilitiesResponsible for producing and distributing daily MSR pricing and analytics reports, including daily MSR hedge valuation distributions.
Maintain and update daily OMSR pricing grids and daily Co-Issue pricing grids across multiple channels (SMP, CSR, PIIT, Direct channels) using MIAC valuation application.
Production of sub-servicing recapture reporting, SSID transfer management, and database maintenance.
Manage end-of-month excess spread reporting and wire remittance processing.
Perform custodial bank reconciliationsGenerate MSR financing tapesProvide ongoing custom reporting and analytical support for management.