Data Analyst - Loan Boarding

Two Harbors Investment•Coppell, TX

2d•Onsite

About The Position

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.

Requirements

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

Nice To Haves

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

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.