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.
Proven verbal and written communication skills.

Benefits

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development opportunities

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Visual Basic Applications (VBA)Power QueryExceldata transformationdata analysisfinancial analysisworkflow analysisreportingadvanced formulasconditional formatting

Soft Skills

analytical skillsorganizational skillsverbal communicationwritten communication

Certifications

Associate degree