Senior Data Mapping Analyst, Servicing Transaction Management

Onity Group INC; Bengaluru; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

Onity Group INC is seeking a Data Mapping Analyst to support loan boarding/deboarding, data transformation, and tooling across the Servicing Transaction Management team.

You will analyze boarding files, map data from prior servicers, test systems like LLB and MSP, and work with SharePoint and Excel to automate processes. 5+ years in mortgage servicing is preferred, with strong data and communication skills.

Qualifications

• Significant mortgage servicing knowledge and ability to interpret servicing data.
• Experience with multiple loan programs (ARM, HELOC, buydowns, Commercial).
• Bachelor’s Degree preferred or 5+ years mortgage servicing experience.
• SQL experience is preferred.
• 4+ years working with LoanSphere Loan Boarding (LLB).
• MSP servicing system experience required.
• Proficient with Excel, Access, SharePoint and related tools.
• Ability to analyze complex data, identify issues, and propose solutions.
• Strong communication with internal/external partners and auditors.

Responsibilities

• Incorporate new loan programs into the boarding process.
• Analyze error messages, determine root causes, and remediate issues.
• Create edit checks to catch errors prior to boarding.
• Develop and configure Loan Boarding System and related tools.
• Perform testing, review error reports, and communicate issues.
• Define requirements for tools to improve data quality and visibility.
• Coordinate with business units and prior servicers to ensure accurate data transformation.
• Update procedures and optimize the boarding process including tool enhancements.
• Ensure compliance with regulatory requirements (RESPA, USAP, Sarbanes-Oxley).
• Produce control reports and meet project milestones.
• Communicate expectations with clients and document meetings.
• Identify automation opportunities and set up data controls.

Skills

Mortgage servicing knowledge

ARM/HELOC experience

SQL experience

LoanSphere Loan Boarding (LLB)

MSP servicing system

Excel & Access

SharePoint

Documentation & QA

Data mapping & ETL

Analytics & problem solving

Education

Bachelor’s Degree

Tools

Empower

Encompass

SharePoint

Monarch

Adobe

Job description

Position Summary:

The Servicing Transaction Management department is responsible for the loan boarding and deboarding process. This role relates to converting other servicers data to upload into Onitys loan servicing system and subsequently validating the data uploaded versus the data and/or documents received for all newly boarded loans. This position is responsible for developing projects in the loan boarding and related applications for bulk and flow transfers. The Data Mapping Analyst will analyze and program boarding files, as well as participate in data mapping, researching issues and testing the application and data loads. This position requires strong analytical skills and technical knowledge to support the Loansphere Loan Boarding System (LLB) as well as the Onity proprietary Loan Boarding Tool. The Data Analyst will work closely with various parties including their immediate team, business units, prior servicers and other technical teams to coordinate data transformation. This role will also be responsible for implementing tools to support transfer efficiency, as well as keeping documentation updated and communicating changes to processes, procedures and tools.

JOB FUNCTIONS AND RESPONSIBILITIES:

• Ensures that new loan programs or changes are incorporated into the boarding process.
• Analyzes boarding error messages to determine root cause and remediates issues.
• Creates edit checks within the Loan Baording System to recognize errors prior to boarding.
• Develop and configure the Loan Boarding System, as well as supporting toolsets such as SharePoint to support boarding data management. This includes mapping of seller/prior servicer data, create and update tables and define and implement solutions for converting the data.
• Perform testing to support trials and production. Review error reports and document/communicate issues found. Determine solutions for issues.
• Define requirements for and implement tools and processes to improve data quality and visibility.
• Work closely via meetings and conference calls with Business Unit Leads and prior servicers to ensure data transformation is accurate and clearly communicated.
• Update/create procedures and continue to enhance and optimize the boarding process, including tool enhancements as required.
• Ensure compliance with all regulatory requirements (i.e. RESPA, USAP, Sarbox, etc.).
• Produce and review required control reporting.
• Meet all established milestones for deboarding/boarding project plans.
• Follow all established procedures regarding boarding/deboarding.
• Ensure all quality steps are completed and documented.
• Escalate any possible deadline misses.
• Communicate boarding/deboarding expectations with internal and external clients regularly.
• Organize meetings with internal and external clients with documented meeting minutes.
• Self-driven, should be able to handle high pressure.
• Must identify ways to automate processes and set up controls when required.
• Willing to work extra hours as per the process requirements/Flexibility to work in accordance with Business requirements.

KEY RESULTS AREA:

• Reduce number of Servicing Transaction Management related customer complaints by a designated management percentage year over year.
• Maintain quality at 100%.
• Meet all milestones related to the loan boarding process.
• Timely responses to servicers and internal parties.

QUALIFICATIONS:

• This position requires a significant amount of mortgage servicing knowledge, including but not limited to, the ability to identify and understand various data points utilized within loan servicing systems to successfully service loans and interpret mortgage loan collateral and loan servicing documentation used in conjunction with the data to service loans.
• Experience with different loan programs such as ARM’s, HELOC’s, buydowns, Commercial, etc.
• Bachelor’s Degree preferred, or minimum of five (5) + years’ mortgage servicing experience.
• SQL experience preferred
• Minimum of 4 years’ experience working with LoanSphere Loan Boarding (LLB).
• MSP servicing system experience required.
• Advanced PC skills: Microsoft applications, including Excel and Access Database, Monarch, Adobe, SharePoint and LoanSphere Loan Boarding (LLB).
• Ability to deal with complex difficult problems involving multiple facets and variables in non-standardized situations.
• Ability to set up controls and being able to speak to auditors/QA teams regarding process
• Ability to identify inconsistencies or issues in data and help come up with solutions
• Set up organized structure for incoming mapping changes and tracking for all internal and external partners.
• Ability to work independently, meet established deadlines, be very detail orientated, and have excellent organizational skills.
• Organizational skillset able to handle multiple transactions at the same time
• Ability to easily adapt to changes in processes, procedures and priorities.
• Proven strength in interpreting business requirements and implementing them in application or operational tools.
• Ability to communicate effectively with both internal and external clients to determine requirements
• Excellent written and verbal communication skills.
• Experience with Empower or Encompass origination system a plus.
• Strong analytical and problem-solving skills and attention to detail and accuracy.