Senior Analyst, Residential Real Estate Shared Services

Essential Job Functions

• 1+year prior US mortgage experience
• Manipulate data using intermediate excel skills such as using XLOOKUP, VLOOKUP, HLOOKUP, Pivot tables, concatenations, comparisons, and additional functions as needed
• Analyze, research, and identify discrepancies in the data files used for reconciliation
• Demonstrate knowledge of the post-close documents and their status of completeness, able to review and verify chain of assignments/endorsements.
• Complete reconciliation analysis to generate collateral related tasks
• Compare and reconcile CAM tasks to custodial exceptions
• Review imaged documents, identify, and perform data input of relevant document data points for purposes of document identification.
• Assist with performing quality control checks on input data to ensure accuracy.
• Submit mortgage related documents to custodians for check in as needed.
• Participate in special projects as assigned.
• Promote and support positive team dynamics and professionalism among all staffing levels and throughout the company
  

Special Requirements

• Ability to work overtime including weekends as necessary to support and fulfill client timeline requirements.
  

Qualifications/ Requirements

• Any bachelor’s degree
• Expertise in Microsoft Excel including but not limited to Lookups (XLOOKUP, VLOOKUP, HLOOKUP), Pivots, Nested Ifs & Power Pivots.
• Strong written and verbal communication skills to effectively communicate with all the stakeholders.
• Work both independently and in a team environment on complex quantitative projects across an organization and with external clients with limited supervision
  

Working Conditions

• This is a work-from-office role with frequent computer, mouse, and keyboard us
• This role will require flexible US Day/India Night hours to coordinate with stakeholders from multiple geographies
  

The annual full time base salary range for this role is