Analyst, Mortgage Servicing Rights Valuation & Analytics

SitusAMC; Denver (CO); Hybrid; USD 60,000 - 85,000; Full time

Benefits offered by this job

PTO and paid holidays

Medical, dental, vision, life, and 401

Job summary

SitusAMC is seeking a results-driven data analyst to manage, validate and optimize mortgage servicing data within the MSR pricing framework. You will collaborate with clients, support data visualization, and help implement new data workflows.

The role emphasizes SQL/Excel proficiency, ETL familiarity, and comfort with large datasets in a financial services context. Denver-based hybrid work with occasional travel.

Qualifications

• Bachelor's Degree in Business or Finance or related field or combination of education and experience
• 0–2 years of industry/relevant experience, Analyst level or external equivalent
• 0–3 years of relevant data/analytics experience
• Proficiency in SQL and Excel is 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 datasets
• Experience in financial services or mortgage industry preferred
• Hybrid role: 2 days in office in Denver, remote acceptable, travel to Denver twice a year

Responsibilities

• Manage, process and validate mortgage servicing data as part of the MSR pricing process
• Interface with clients to explain methodologies and resolve data issues
• Ensure data accuracy via client communications
• Assist in developing strategic initiatives and new systems
• Build and support data visualization and reporting tools
• Support data automation to improve processing efficiency
• Maintain client relationships with high service standards
• Manage client workload to ensure timely reporting
• Assist in ad hoc data processing and analytics projects
• Collaborate with valuation team as part of MSR pricing

Skills

Problem solving

Data analysis

Education

Bachelor's Degree in Business or Finance

Tools

SQL

Excel

Alteryx

Job description

SitusAMC is where the best and most passionate people come to transform our client's businesses and their own careers. Whether you're a real estate veteran, a passionate technologist, or looking to get your start, join us as we work together to realize opportunities for everyone, we proudly serve.

At SitusAMC, we are looking to match your unique experience with one of our amazing careers, so that we can help you realize your potential and career growth within the Real Estate Industry. If you are someone who can be yourself, advocate for others, stay nimble, dream big, own every outcome, and think global but act local - come join our team!

This role is responsible for managing, processing, and validating mortgage servicing data that supports the firm's MSR pricing and analytics framework. This position plays a critical part in ensuring data integrity across the valuation process by maintaining close communication with clients, resolving data issues, and clearly explaining methodologies and assumptions. This role will contribute to the implementation of strategic initiatives, new systems, and enhanced data workflows. The ideal candidate brings a strong analytical foundation, and proficiency in SQL, Excel, Alteryx, and data pipeline concepts, and ideally experience in a financial services or mortgage background.

Essential Job Functions:

• 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

• Other activities may be assigned by your manager

Qualifications/ Requirements:

• Bachelor's Degree in Business or Finance, or related field or combination of education and experience

• Entry level professional with 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

• Hybrid role (2 days in office) based out of Denver office preferred but will consider remote employee

• Employee must be able to travel to Denver office twice a year for in person team meetings

Note:

This job description is not intended to be all inclusive or exclusive. At any time, employees may perform other related duties as required to meet the ongoing needs of the organization and participate in additional trainings. SitusAMC does not accept unsolicited resumes from staffing agencies, search firms or any third parties. Any unsolicited resume submitted to SitusAMC in any manner will be considered SitusAMC property, and SitusAMC will not pay a fee for any placement resulting from the receipt of an unsolicited resume.

The annual full time base salary range for this role is

$60,000.00 - $85,000.00

Specific compensation is determined through interviews and a review of relevant education, experience, training, skills, geographic location and alignment with market data. Additionally, certain positions may be eligible to receive a discretionary bonus as determined by bonus program guidelines, position eligibility and SitusAMC Senior Management approval. SitusAMC offers PTO and paid holidays, the terms of which are set forth in the program policies. All full time employees also are eligible to participate in various benefit plans, including medical, dental, vision, life, disability insurance and 401K; in each case in accordance with the terms of the applicable plans.

Pay Transparency Nondiscrimination Provision (https://go.situsamc.com/rs/962-QMP-613/images/pay-transp_English_formattedESQA508c.pdf?version=0)

SitusAMC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

Know Your Rights, Workplace Discrimination is Illegal (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf)