Prepare for and practice interview questions from Shellpoint Mortgage Servicing.

Shellpoint Mortgage Servicing Interview Questions

Shellpoint Mortgage Servicing Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Shellpoint Mortgage Servicing Salaries by Position

Who We Are

Shellpoint Mortgage Servicing (SMS) is one of America’s top-five non-bank mortgage-servicing companies. Our clients are businesses that own mortgage loans (such as banks and real estate investment firms). On their behalf, we manage (or “service”) their loan portfolios, which means that we collect homeowners’ mortgage payments, pay their tax and insurance bills, and help homeowners in default to get current.
Primary Function

The Business Analyst - Default Systems & Support will play a key role in the support of various departments in default, including Foreclosure, Bankruptcy, Property Preservation, and Post-Foreclosure. The primary objective is to optimize the utilization of key business workflow software such as Black Knight LoanSphere, Tableau, and other various workflow systems. This role will analyze system configuration and existing business rules, gather requirements from the business unit, and design and help implement solutions including workflow changes and automation. Strong organizational and problem-solving skills, along with the ability to clearly communicate technical items with both technical and non-technical team members, are essential.
Direct Reports

N/A
Principal Duties
Collaborate with the business unit, IT business partners, other internal departments, and external firms to optimize system utilization.
Create reports and assist the business units with ad hoc data.
Proactively analyze and identify system enhancements to streamline workflow processes and improve efficiencies.
Manage a project list, analyze appropriate prioritization based on cost-benefit analysis, and conduct prioritization meetings with the business unit management team.
Create and clearly communicate detailed technical requirements to IT partners as well as to non-technical team members and management.
Develop process flows, job aids, and procedures relative to foreclosure, bankruptcy, property preservation, and post-foreclosure processes.
Act as a subject matter expert for system troubleshooting and creating oversight reporting as well as implementing system enhancements.
Create, manage, and oversee ongoing enhancements of automation relative to default workflows systems.
Perform related duties as assigned by management.
Education And Experience Requirements
Bachelor’s Degree in technical, quantitative, or analytical discipline preferred.
1+ years’ experience in mortgage or default servicing preferred.
Knowledge, Skill, and Ability Requirements
Demonstrated analytical and business communication skills.
Strong attention to detail and an ability to multi-task, respond well to pressure and deadlines, and work well individually and in a collaborative environment.
Strong skills in Excel (charts, formulas, pivots) or other data manipulation software.
1+ years of experience with Microsoft SQL.
Fast learner – able to assimilate new ideas and thrive in a fast-paced environment.
Experience with Tableau is a plus.
Prior work experience with Black Knight LoanSphere is a plus.
Python programming experience preferred.
Visio and process documentation experience preferred.
Company Perks
15 Paid Time Off (PTO) days and 18 after 1st anniversary!
9 Paid Holidays
Employee Engagement Activities
Company Benefits
Medical (including Health Savings Account & Flexible Savings Account)
Dental, RX, Vision, Life, Disability Insurance, 401(k) Plan with company match, Employee Assistance Plan
Performance-based Incentives
Pet Insurance
Advancement Opportunities
Equal Employment Opportunity

We're proud to be an equal opportunity employer and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. Different makes us better.

#J-18808-Ljbffr

Who We Are

Shellpoint Mortgage Servicing (SMS) is one of America’s top-five non-bank mortgage-servicing companies. What is mortgage servicing? Our clients are businesses that own mortgage loans (such as banks and real estate investment firms). On their behalf, we manage (or “service”) their loan portfolios, which means that we collect homeowners’ mortgage payments, pay their tax and insurance bills, and help homeowners in default to get current.

Primary Function

The Business Analyst - Default Systems & Support will play a key role in the support of various department in default, including Foreclosure, Bankruptcy, Property Preservation, and Post-Foreclosure. The Business Analyst- Default Systems & Support’s primary objective is to optimize the utilization of key business workflow software such as Black Knight LoanSphere, Tableau, and other various workflow systems. The Business Analyst- Default Systems & Support will analyze system configuration and existing business rules, gather requirements from the business unit, and design and help implement solutions including workflow changes and automation. They will have strong organizational and problem-solving skills as well as the ability to clearly communicate technical items with both technical and non-technical team members.

Direct Reports

N/A

Principal Duties

Collaborate with the business unit, IT business partners, other internal departments, and external firms to optimize system utilization.
Create reports and assist the business units with ad hoc data.
Proactively analyze and identify system enhancements to streamline workflow processes and improve efficiencies.
Manage a project list, analyze appropriate prioritization based on cost benefit analysis, and conduct prioritization meetings with business unit management team.
Create and clearly communicate detailed technical requirements to IT partners as well as to non-technical team members and management.
Development of process flows, job aids, and procedures relative to foreclosure, bankruptcy, property preservation, and post-foreclosure processes.
Act as a subject matter expert for system troubleshooting and running and creating oversight reporting as well as implementing system enhancements Performs additional projects and duties as assigned by supervisor.
Create, manage, and oversee ongoing enhancements of automation relative to default workflows systems.
Performs related duties as assigned by management.

Education And Experience Requirements

Bachelor’s Degree in technical, quantitative, or analytical discipline preferred.
1+ years’ experience in mortgage or default servicing preferred.

Knowledge, Skill, and Ability Requirements

Demonstrated analytical and business communication skills.
Strong attention to detail and an ability to multi-task, respond well to pressure and deadlines, and work well individually and in a collaborative environment.
Strong skills in Excel (charts, formulas, pivots) or other data manipulation software
1+ years of experience with Microsoft SQL
Fast learner – able to assimilate new ideas and thrive in a fast-paced environment.
Experience with Tableau is a plus.
Prior work experience with BlackKnight LoanSphere is a plus.
Python programming experience preferred.
Visio and process documentation experience preferred.

While this description is intended to be an accurate reflection of the position’s requirements, it in no way implies/states that these are the only job responsibilities. Management reserves the right to modify, add or remove duties and request other duties, as necessary.

Company Perks

15 Paid Time Off (PTO) days and 18 after 1st anniversary!
9 Paid Holidays
Employee Engagement Activities

Company Benefits

Medical (including Health Savings Account & Flexible Savings Account)
Dental - RX – Vision – Life, Disability Insurance – 401(k) Plan with company match! – Employee Assistance Plan
Performance-based Incentives
Pet Insurance
Advancement Opportunities

Newrez NOW

Our Corporate Social Responsibility program, Newrez NOW, empowers employees to become leaders in their communities through a robust program that includes volunteering, philanthropy, nonprofit grants, and more
1 Volunteer Time Off (VTO) day, company-paid volunteer day where all eligible employees may participate in a volunteer event with a nonprofit of their choice
Employee Matching Gifts Program: We will match monetary employee donations to eligible non-profit organizations, dollar-for-dollar, up to $1,000 per employee
Newrez Grants Program: Newrez hosts a giving portal where we provide employees an abundance of resources to search for an opportunity to donate their time or monetary contributions

Equal Employment Opportunity

We're proud to be an equal opportunity employer- and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. Different makes us better.

CA Privacy Policy

CA Notice at Collection

#J-18808-Ljbffr

Who we are Shellpoint Mortgage Servicing (SMS) is one of America's top-five non-bank mortgage-servicing companies. What is mortgage servicing? Our clients are businesses that own mortgage loans (such as banks and real estate investment firms). On their behalf, we manage (or "service") their loan portfolios, which means that we collect homeowners' mortgage payments, pay their tax and insurance bills, and help homeowners in default to get current. Primary Function The Business Analyst - Default Systems & Support will play a key role in the support of various department in default, including Foreclosure, Bankruptcy, Property Preservation, and Post-Foreclosure. The Business Analyst- Default Systems & Support's primary objective is to optimize the utilization of key business workflow software such as Black Knight LoanSphere, Tableau, and other various workflow systems. The Business Analyst- Default Systems & Support will analyze system configuration and existing business rules, gather requirements from the business unit, and design and help implement solutions including workflow changes and automation. They will have strong organizational and problem-solving skills as well as the ability to clearly communicate technical items with both technical and non-technical team members. Direct Reports <ul><li> N/A </li></ul>Principal Duties <ul><li>Collaborate with the business unit, IT business partners, other internal departments, and external firms to optimize system utilization. </li><li>Create reports and assist the business units with ad hoc data. </li> <li>Proactively analyze and identify system enhancements to streamline workflow processes and improve efficiencies. </li> <li>Manage a project list, analyze appropriate prioritization based on cost benefit analysis, and conduct prioritization meetings with business unit management team. </li><li>Create and clearly communicate detailed technical requirements to IT partners as well as to non-technical team members and management. </li> <li>Development of process flows, job aids, and procedures relative to foreclosure, bankruptcy, property preservation, and post-foreclosure processes. </li> <li>Act as a subject matter expert for system troubleshooting and running and creating oversight reporting as well as implementing system enhancements Performs additional projects and duties as assigned by supervisor. </li><li>Create, manage, and oversee ongoing enhancements of automation relative to default workflows systems. </li><li>Performs related duties as assigned by management. </li></ul>Education and Experience Requirements <ul> <li>Bachelor's Degree in technical, quantitative, or analytical discipline preferred. </li><li>1+ years' experience in mortgage or default servicing preferred. </li></ul>Knowledge, Skill, and Ability Requirements <ul> <li>Demonstrated analytical and business communication skills. </li> <li>Strong attention to detail and an ability to multi-task, respond well to pressure and deadlines, and work well individually and in a collaborative environment. </li><li>Strong skills in Excel (charts, formulas, pivots) or other data manipulation software </li><li>1+ years of experience with Microsoft SQL </li> <li>Fast learner - able to assimilate new ideas and thrive in a fast-paced environment. </li><li>Experience with Tableau is a plus. </li><li>Prior work experience with BlackKnight LoanSphere is a plus. </li><li>Python programming experience preferred. </li> <li>Visio and process documentation experience preferred. </li></ul> While this description is intended to be an accurate reflection of the position's requirements, it in no way implies/states that these are the only job responsibilities. Management reserves the right to modify, add or remove duties and request other duties, as necessary. Company Perks: •15 Paid Time Off (PTO) days and 18 after 1st anniversary! •9 Paid Holidays •Employee Engagement Activities Company Benefits: •Medical (including Health Savings Account & Flexible Savings Account) •Dental - RX - Vision - Life, Disability Insurance - 401(k) Plan with company match! - Employee Assistance Plan •Performance-based Incentives •Pet Insurance •Advancement Opportunities Newrez NOW: •Our Corporate Social Responsibility program, Newrez NOW, empowers employees to become leaders in their communities through a robust program that includes volunteering, philanthropy, nonprofit grants, and more •1 Volunteer Time Off (VTO) day, company-paid volunteer day where all eligible employees may participate in a volunteer event with a nonprofit of their choice •Employee Matching Gifts Program: We will match monetary employee donations to eligible non-profit organizations, dollar-for-dollar, up to $1,000 per employee •Newrez Grants Program: Newrez hosts a giving portal where we provide employees an abundance of resources to search for an opportunity to donate their time or monetary contributions Equal Employment Opportunity We're proud to be an equal opportunity employer- and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. Different makes us better. CA Privacy Policy CA Notice at Collection

Shellpoint Mortgage Servicing Interview Questions

Shellpoint Mortgage Servicing Interview Guides

Shellpoint Mortgage Servicing Interview Questions

Shellpoint Mortgage Servicing Salaries by Position

Shellpoint Mortgage Servicing Opening Jobs