Corporate Advance Reconciliation Analyst

TWO; Fort Mill (SC); On-site; USD 75,000 - 110,000; Full time

Job summary

RoundPoint Mortgage Servicing LLC is seeking a Corporate Advance Control Analyst to enhance controls and provide actionable insights into servicing advances. You will analyze financial data, refine processes, and support liquidity planning, reporting to senior leadership and coordinating with Finance and Loan Administration teams.

The role emphasizes SQL reporting, data-driven decision making, and collaboration across mortgage servicing operations to improve profitability and controls.

Qualifications

• Bachelor's degree in Finance/Accounting or Computer Science.
• Experience with SQL programming language preferred.
• Strong analytical and Excel skills required.

Responsibilities

• Sustain reporting of servicing advances using SQL.
• Perform quantitative and qualitative analysis of advances.
• Identify opportunities to increase income and reduce costs.
• Provide regular reporting on advances, recoveries and trends.

Skills

SQL

Excel

Financial analysis

Data analysis

Report development

Education

Bachelor's degree in Finance/Accounting or Computer Science

Tools

Black Knight MSP

Job description

The Corporate Advance Control Analyst will be an integral part in the enhancement of controls, visibility and oversight of RoundPoint’s servicing advance assets. This position will be responsible for the analysis of financial data and mortgage servicing activity to cultivate correct accounting treatment, identify opportunities to reduce losses, and provide visibility and insight to RoundPoint’s leadership teams. The Corporate Advance Control Analyst will play a key role in refining existing processes along with designing, implementing and creating procedures for new processes.

Working Relationships:

The Corporate Advance Control Analyst will report to the Corporate Advance Control Manager and will partner with the key stakeholders across the entire company including the Finance department, Loan Administration, Investor Reporting, Default Servicing, and Claims Management.

Responsibilities:

• Sustaining reporting of all servicing advances, primarily through SQL
• Conduct quantitative analysis of advances over multiple population levels
• Identify opportunities to increase income, lower expenses, and recover receivables
• Perform qualitative reviews of servicing advance expenditures and claim fund receipts
• Evaluate and enhance quantitative analysis of advances across multiple loan populations
• Analysis of Unclaimed Funds, including timely reporting and remittance of Escheatable items
• Provides daily, weekly and monthly reporting on advances, recoveries and incentives, including loan level details and consulting of servicing advance trends and opportunities as they arise
• Aid in the securitization and funding of our servicing advances through debt facilities
• Aid in the delivery of monthly liquidity planning and forecasting on servicing advances
• Assist in the governance of transaction methodology and allocation mapping between Servicing and Accounting
• Assist with initiatives and projects as it relates to the goals of the team and leadership
• Provide line of business level review and consulting of servicing advance trends and opportunities as they arise
• Provide ad-hoc reporting and analysis services as required to meet business needs

Requirements:

• Minimum of two years of recent experience as a data analyst, report developer, or another related title in a financial services environment
• Bachelor’s degree, preferably with emphasis in Finance/Accounting or Computer Science
• Experience with SQL programming language is preferred
• Experience with Black Knight Financial Services MSP is preferred
• Strong “big picture” understanding of servicing operations, internal controls and accounting
• Strong proficiency with the Microsoft Office Suite with an emphasis in Excel as a critical requirement
• Strong technical aptitude for learning new software and systems
• Independent ability to uniquely identify, collect, and assess data to create analytical solutions to complex business problems
• Excellent organizational and time management skills
• Demonstrated ability to effectively communicate with both internal and external customers, peers, and management
• Must be a self-starting individual flexible to change and able to manage in a fast paced environment
• Good organizational and problem solving skills with ability to handle multiple tasks
• Expansive experience with collaborative project oversight across all facets of mortgage servicing

Physical Demands & Working Conditions

• 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