Data Analyst - Loan Boarding

The Data Analyst – Loan Boarding will be responsible for day-to-day production, maintenance, and development of the loan onboarding process and data solutions at RoundPoint. This role will focus on understanding business processes and data, interpreting client requirements and specifications, and developing meaningful analyses and reports to drive business decisions.  Qualified candidates will have a proven background in performing data mining, analysis, and reporting.   The Data Analyst – Loan Boarding role reports to the AVP of Loan Boarding in the Servicing Transfers department.  This role works closely with members of the Loan Boarding and Servicing Transfers teams and other internal stakeholders to fulfill client and investor inquiries.     Responsibilities: Interpret client requirements into actionable specifications Mine, analyze, and interpret data from multiple sources Create import and export maps from external data sources Develop and/or gain deep understanding of data validation rules to ensure quality data Create SQL tables and basic queries to manage external data Perform tests for validity, reasonableness, and accuracy through standard methods and application of specific subject-area knowledge Troubleshoot data inconsistencies Perform regular maintenance and testing on production reports and dashboards Provide ad-hoc reporting and analysis services as required to meet business needs Other related duties as assigned.     Qualifications:   Required: Bachelor’s Degree At least 2-4 years of related mortgage servicing experience Keen analytic skills with a strong attention to detail and accuracy Experience and confidence in communicating with external parties and management Intermediate to advanced skills in Excel Strong time management skills working autonomously Strong skills in various ETL languages (e.g. SQL or VBA) Excellent verbal and written communication skills, with ability to effectively interface with external clients and internal business partners Desired: At least 1-2 years of related Loan Boarding experience Minimum of 1-2 years of experience with MSP Intermediate to advance experience in Microsoft SharePoint Physical Demands & Working Conditions The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of their role.   Ability to communicate effectively through speech and hearing, both in-person and over the phone. The employee is required to sit for extended periods of time and is occasionally required to stand and walk.  Remaining in a stationary position for extended periods, frequently sitting but occasionally involving standing or walking short distances; the employee may occasionally climb or balance, and stoop, kneel, crouch, or crawl.  Regular use of hands and fingers for tasks like keyboarding, operating office equipment, and filing documents. Ability to lift and move objects weighing up to 10 pounds, and potentially up to 20 pounds occasionally.  Ability to observe details at close range, such as viewing a computer screen, reviewing documents, and performing data analysis. The noise level in the work environment is usually quiet to moderate, and no extreme conditions are present.   About RoundPoint Mortgage Servicing LLC RoundPoint Mortgage Servicing LLC is a fully integrated, non-bank mortgage company, with a subservicing portfolio of approximately 900,000 loans. In 2023, RoundPoint was acquired by Two Harbors Investment Corp. (NYSE: TWO), reaffirming its commitment to MSR as core and essential to our business strategy and our future. A combined Two Harbors and RoundPoint capitalizes on the strengths of both companies, adding significant value for stakeholders through operational and cost efficiencies, as well as the ability to participate more fully in the mortgage finance space as opportunities arise. Founded in 2009, Two Harbors has grown into a leading publicly traded residential mortgage real estate investment trust (mortgage REIT). We leverage our core competencies of understanding and managing interest rate and prepayment risk to invest in our Agency residential mortgage-backed securities (RMBS) and mortgage servicing rights (MSR) portfolio, with the objective of delivering attractive risk-adjusted returns to our stockholders.   Location Fort Mill, SC Coppell, TX   Employee Status Non-Exempt   Travel None