Leads and/or participates in projects within one or more functional areas of Default Servicing (internally known as Customer Asset Management – CAM)
Represents these areas in cross-functional, high-visibility projects.
Serve as resource in a defined area of CAM and represent business practices and interests in various projects with internal and external stakeholders.
Interact with business partners across Residential Mortgage platforms to leverage technology, system enhancements and projects.
Develop and produce non-routine departmental reports and spreadsheets, including project or product strategy analyses, historical reporting, workflow analyses and financial analyses for one or more functional areas of CAM.
Conduct non-routine analysis and judgment-based work over a single or closely related disciplines to support CAM decisions.
Conduct non-routine data review, research, and/or reconciliation for assigned areas of CAM.
Build and maintain queries for data transformation and reporting, ensuring efficiency and scalability.
Draft and/or edit procedures related to one or more functional areas of CAM to maintain their currency.
Support departmental audits, user certifications and compliance testing for CAM.
Lead and participate in planning, testing and implementing new projects, systems, products and regulatory changes impacting assigned CAM team(s).
Requirements
Associate degree and a minimum of 3 years’ related experience, or in lieu of a degree, a combined minimum of 5 years’ higher education and/or work experience, including a minimum of 3 years’ related experience
Experience in collections and/or default servicing
Experience with Visual Basic Applications (VBA)
Experience with Power Query
Proven analytical skills
Strong organizational skills
Expert level Excel skills
Write advanced formulas. Use array formulas, named ranges, and advanced conditional formatting. Serve as an internal resource for Excel troubleshooting and guidance.