Reporting Analyst II

Rocket Mortgage•Highlands Ranch, CO

2d•Hybrid

About The Position

Under strict deadlines and within short timeframes, reconciles the most complex reports received from primary servicers in accordance with Agreements and Departmental policy. Completes research as necessary on complex issues relating to servicer reporting, servicer transfers, cash settlement issues and servicer inquiries. Research and correct complex servicing errors or discrepancies and ensure accurate information is sent to the trust and investors. Interface with Third Parties regarding complex verbal and written loan level requests. Build and maintain relationships with high-demand investors and identify ways to address their needs and to satisfy and retain the clients. Lead and execute projects with business partners, IT, vendors, and senior management and implement process improvements. Analyze current processes, identify disconnects and re-engineer processes to gain efficiency. Lead the development of company best practices around data analytics, dashboarding, and reporting. Develop, maintain, and own analytical models and dashboards for internal and external clients. Analyze current processes, identify disconnects and re-engineer processes to gain efficiencies. May perform other related duties or ad hoc projects within the scope of responsibilities.

Requirements

High school diploma or state approved equivalency required.
Typically requires a minimum of 5+ years related work experience.
5 plus years’ experience on SBO 2000 or SBO.NET or comparable knowledge of primary servicing system.
Demonstrate advanced computer and software skills necessary for job function; ability to manipulate data to create specific reports if needed.
Exceptionally skilled in verbal and written form as appropriate for the needs of the audience.
Demonstrated ability to craft written correspondence that conveys messages that cannot be misinterpreted.
Possess objective analytical problem solving skills.
Requires relatively little direction to get the job done.

Nice To Haves

Bachelor's degree preferred.
Mortgage and/or Financial services experience a plus.
Experience with SQL, SSRS and/or Microsoft Power BI is a material plus.

Responsibilities

Generates a variety of daily, weekly, and monthly internal and external reports.
Reconciles the most complex reports received from primary servicers in accordance with Agreements and Departmental policy.
Completes research as necessary on complex issues relating to servicer reporting, servicer transfers, cash settlement issues and servicer inquiries.
Research and correct complex servicing errors or discrepancies and ensure accurate information is sent to the trust and investors.
Interface with Third Parties regarding complex verbal and written loan level requests.
Build and maintain relationships with high-demand investors and identify ways to address their needs and to satisfy and retain the clients.
Lead and execute projects with business partners, IT, vendors, and senior management and implement process improvements.
Analyze current processes, identify disconnects and re-engineer processes to gain efficiency.
Lead the development of company best practices around data analytics, dashboarding, and reporting.
Develop, maintain, and own analytical models and dashboards for internal and external clients.
Analyze current processes, identify disconnects and re-engineer processes to gain efficiencies.
May perform other related duties or ad hoc projects within the scope of responsibilities.