Data Analyst - Loan Boarding

Job Description 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 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 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. #J-18808-Ljbffr