Analytics Consultant 3

Wells Fargo''s Consumer Lending Group (CLG) is an industry leader in supporting homeowners and consumers. We put customers at the center of all that we do. We make every decision - and design every product and service - with our customers in mind.
It starts with you. We must attract, develop, retain and motivate the most talented people - those who care and who work together as partners across business units and functions. We value and promote diversity and inclusion in every aspect of our business and at every level of our organization.
The CLG team includes Home Lending, Consumer Credit Card, Personal Loans and Lines, Direct Auto, Dealer Services, Commercial Auto, Retail Services and Education Financial Services including the professional services teams that partner with these businesses - Human Resources, Finance, Credit Risk, and Compliance & Operational Risk.
Our Capital Markets Finance team is responsible for valuation and risk management process for mortgage loans in the pipeline, warehouse and servicing asset. Overview: Servicing Portfolio Management (SPM) is responsible for the valuation and analysis of Wells Fargo''s Mortgage Servicing Rights (current outstanding principal balance of over $1 trillion).
This includes forecasting the expected current value of the portfolio in current and changing interest rate environments. The single largest assumption within the portfolio valuation is the customer’s prepayment probability (borrowers refinancing, moving or otherwise paying off their loan prior to maturity). A second driver of the portfolio valuation is defaults. Prepayment and default model accuracy are therefore critical to the valuation process.
The position is integral to the reporting, analysis and monitoring of prepayment and default behavior for the WFHL portfolio. The Analytics Consultant will be responsible for understanding the key drivers for prepayment and default behavior, monitoring and tracking model performance and making recommendations for model improvements to Executive Management.
The position involves partnering with SPM Data and Financial Engineering Teams to ensure the data and tools meet the requirements to support the analytical process.

Specific job functions include:
- Completing monthly prepayment and default reporting on a timely and accurate basis, including total portfolio views, channel specific analysis, views by loan level attributes such as FICO, LTV, loan size and other prepayment and default-based drivers
- Analyzing prepayment, default and buyout results to identify trends or environmental changes affecting these valuation drivers
- Evaluating channel performance and behavior to determine identifying unexplained performance or behavior and communicating to Executive Management
- Preparing market performance analytics based on external and internal data
- Completing ad-hoc research requests around customer behavior or model performance, such as prepayment and default behavior by payment type, marketing programs or environmental influences such as house price appreciation
- Providing analysis to the pricing team to evaluate whether current prepayment and default model performance supports current pricing levels
- Understanding how the loan level prepayment and default models function
- Developing executive friendly reporting which includes data gathering, report design, analysis and final communication
- Contributing to the on-going monitoring of prepayment and default model performance by preparing monitoring reports, identifying performance threshold breaches, highlighting emerging trends and communicating issues for resolution to modeling partners.

- Partnering with the Data Team to develop/test new data fields partnering with the Financial Engineering Team to develop analytical/presentation tools supporting reporting and analytics
BASIC:
6+ years reporting and analytical experience or a minimum of a Masters degree in programs such as applied mathematics, statistics, engineering, physics, accounting, finance, economics or computer sciences with 3+ years directly applicable work experience.
MINIMUM:
- Very strong analytical, technical, and communication skills are required.
- Much of the work involves using data querying tools to understand prepay and default risks.
- We work with over 7M observations across 70+ months of data. It is imperative that the candidate is comfor learning new tools, summarizing large amount of data and communicating results succinctly for management.
- Bachelors in Finance, Economics, Engineering, Mathematics or Accounting or equivalent
- Experience with relational databases and data querying tools
- Strong MS-Excel skills
- Self-starter able to understand complex concepts/processes related to finance and future cashflow valuation models
- Able to multi-task and work in a constantly changing, fast-paced environment
- Excellent written and verbal communication skills
PREFERRED:
- Experience in mortgage or related industry
- SQL / SAS experience
- Exposure to financial and statistical modeling concepts
- Minor or double major in Computer Science or MIS helpful for demonstrating technical skills