Mortgage Servicing Analyst

Role: Mortgage Servicing Business Analyst – Sales & AcquisitionsLocation: 800 S Jordan Creek Parkway, West Des Moines, IADuration: 12 Months (Extension will be evaluated closer to the end date)Work Schedule: Hybrid – 3 Days Onsite / 2 Days Remote (Flexible)Interview Process: 1 Round – 30-Minute Teams Video Panel InterviewBusiness Unit: Home Lending – Mortgage ServicingJob SummaryWe are seeking an experienced Mortgage Servicing Business Analyst to support Home Lending operations, with a primary focus on mortgage servicing sales, acquisitions, loan transfers, data analysis, and process improvements.The ideal candidate will have strong mortgage servicing domain knowledge, hands-on experience with MSP (Mortgage Servicing Platform), and advanced Excel skills, including VLOOKUPs and Pivot Tables.This role involves analyzing mortgage servicing data, supporting loan transfer activities, resolving data discrepancies, coordinating with internal and external stakeholders, and implementing operational process improvements.Key ResponsibilitiesSupport mortgage servicing sales, acquisitions, and loan transfer activities within Home Lending.Analyze, compare, validate, and reconcile mortgage servicing data using MSP and advanced Excel.Assist with implementing process changes related to loan transfers and servicing acquisitions.Work with internal teams, external partners, vendors, and counterparties to identify and resolve data discrepancies.Perform data mapping, formatting, translation, conversion, and validation to support servicing transfer processes.Analyze MSP data to identify inconsistencies, operational gaps, and opportunities for process improvement.Support project management activities, including planning, coordination, tracking deliverables, and implementing business initiatives.Investigate and resolve escalated operational issues through detailed analysis and collaboration.Develop and maintain process documentation, training materials, and operational procedures.Coordinate with cross-functional teams to ensure accurate data transfers and successful implementation of process changes.Support business initiatives by identifying operational risks, recommending solutions, and improving workflow efficiency.Maintain effective communication with stakeholders and ensure timely resolution of outstanding issues.Required QualificationsStrong experience in Mortgage Servicing, particularly within Home Lending operations.Knowledge of mortgage servicing sales, acquisitions, and loan transfer processes.Working knowledge of MSP (Mortgage Servicing Platform) and mortgage servicing data.Advanced Microsoft Excel skills, including VLOOKUPs and Pivot Tables.Experience with data analysis, comparison, reconciliation, and discrepancy resolution.Understanding of data structures, formatting, mapping, translation, and conversion.Experience coordinating projects, implementing process changes, and supporting operational initiatives.Strong analytical, problem-solving, and critical-thinking skills.Excellent written and verbal communication skills.Ability to collaborate effectively with internal teams, external partners, vendors, and counterparties.Strong organizational skills, attention to detail, and ability to manage multiple priorities.Top 3 Must-Have SkillsMortgage Servicing: Experience in Home Lending, servicing sales/acquisitions, and loan transfer operations.MSP: Working knowledge of MSP data, servicing processes, and data reconciliation.Advanced Excel: Strong experience with VLOOKUPs, Pivot Tables, and data comparison/analysis.