MSR Valuation & Analytics Analyst

situsamc; United States; Hybrid; USD 60,000 - 85,000; Full time

Benefits offered by this job

PTO & holidays

Medical, dental, vision

401K plan

Job summary

SitusAMC is seeking a motivated data analyst to manage, process and validate mortgage servicing data as part of our MSR pricing and analytics framework. You will ensure data integrity, explain methodologies to clients, and collaborate across teams to drive improvements in data workflows and reporting.

The role combines hands-on data work with analytics and client-facing communication, requiring proficiency in SQL, Excel and ETL concepts.

Qualifications

• Bachelor's Degree in Business or Finance, or related field or combination of education and experience.
• 0-2 years of industry and/or relevant experience, typically at an Analyst level role or external equivalent.
• Zero to three years of relevant experience in a data or analytics role.
• Proficiency in SQL and Excel required.
• Alteryx or similar ETL software experience strongly preferred.
• Knowledge of relational databases and data warehousing concepts.
• Familiarity with ETL processes and data pipeline management.
• Strong problem-solving skills and ability to work with large and varied datasets.
• Experience in financial services or mortgage industry preferred.

Responsibilities

• Manage, process and validate mortgage servicing data as part of the overall MSR pricing process.
• Interfaces with clients and/or related stakeholders to explain methodologies and resolve data issues.
• Responsible for ensuring accuracy of data via client communication.
• Works with leadership to develop and implement strategic initiatives and new systems.
• Build and support data visualization and reporting tools.
• Support data automation efforts to improve processing efficiency.
• Maintain client relationships and communication with a high standard of client service.
• Manage client workload to ensure timely delivery of reporting.
• Assist in ad hoc data processing and analytics projects to support sales and transaction team.
• Collaborate with valuation team as part of the MSR pricing process.

Skills

SQL

Excel

Alteryx

Data pipelines

Education

Bachelor's Degree in Business or Finance

Tools

Alteryx

Job description

SitusAMC is seeking a motivated data analyst to manage, process and validate mortgage servicing data as part of our MSR pricing and analytics framework. You will ensure data integrity, explain methodologies to clients, and collaborate across teams to drive improvements in data workflows and reporting.

The role combines hands-on data work with analytics and client-facing communication, requiring proficiency in SQL, Excel and ETL concepts.