MSP Conversion Data Analyst @Consolidated Analytics
Data and Analytics
Salary 60-100 per hour
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type full-time
Posted YDay

[Hiring] MSP Conversion Data Analyst @Consolidated Analytics

YDay - Consolidated Analytics is hiring a remote MSP Conversion Data Analyst. πŸ’Έ Salary: 60-100 per hour πŸ“Location: USA

Role Description

Consolidated Analytics seeks a technical BA with extensive, expert-level knowledge of the inner workings of the ICE MSP residential mortgage servicing system, including its functions, operational workflows, and modules, for a forthcoming system conversion. This BA role will be more of a "technical" BA, less of an "operational" BA, and must be fully capable of working on the technical side of an MSP mortgage servicing system implementation and conversion, focusing on data mapping, data validation, and UAT testing, interacting and working with other technical BAs, DevOps leaders and teams, MSP coders, technical workflow teams, UAT, SIT, etc.

Responsibilities

  • Find and pull all loan, escrow, and accounting data needed for conversion from the client’s source systems.
  • Clean up source data so problems are fixed before they reach MSP.
  • Prepare conversion data files and deliver them to the ICE MSP team on time, for each remaining trial and the final conversion.
  • Check converted data from a data angle: record counts, field mapping, completeness, and consistency.
  • Check converted data from a financial angle, especially detailed escrow and accounting balances matching between the source systems and MSP.
  • Review conversion messages and exceptions, and work with the business groups and ICE until each is fixed or formally accepted.
  • Maintain and run the validation SQL scripts, keeping the turnaround to about 7 days per trial.
  • Support Trial 3 testing, the go-live event, and checking that balances still match after the conversion.
  • Be available outside normal hours around trial deadlines and data handoffs to ICE.
  • Learn the terms and processes of both the mortgage and chattel businesses.
  • Understand how each business group works and map each group’s processes to the core data it relies on.
  • Act as the link between the business groups, the technical team, and ICE, putting business needs into data terms and back again.
  • Review and fill any training gaps for GSE (Fannie, Freddie, and Ginnie Mae) investor reporting requirements and provide hands-on training for best-practice portfolio reconciliations and how exceptions are fixed in MSP.
  • Set up process for USDA and VA monthly reporting.
  • Review current process for Default and Delinquency reporting (FHA, FNMA, USDA, VA, Freddie).

Qualifications

  • 5+ years of technical MSP mortgage servicing system implementation and conversion experience, with expertise in data mapping and data validation.
  • 5+ years of technical MSP mortgage servicing system project management experience and User Acceptance Testing (UAT).
  • Expert user of Microsoft Project software and project status tracking systems.
  • Analytical, able to identify and communicate gaps in processes.
  • Skilled at testing processes and methodologies.
  • Problem-solving and analytical skills.
  • Excellent oral and written communication skills.
  • Ability to successfully facilitate meetings and other collaborative discussion forums with all levels of operations and management team members.

Benefits

  • Medical Insurance
  • Dental Insurance
  • Vision Insurance
  • Life & Disability Insurances
Before You Apply
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
MSP Conversion Data Analyst @Consolidated Analytics
Data and Analytics
Salary 60-100 per hour
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type full-time
Posted YDay
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 140,000+ Remote Jobs
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 140,000+ Remote Jobs
Γ—
Apply to the best remote jobs
before everyone else

Access 140,000+ vetted remote jobs and get daily alerts.

4.9 β˜…β˜…β˜…β˜…β˜… from 500+ reviews

⚑ 141,367+ remote jobs, refreshed hourly

πŸ”” Real-time alerts: Apply first, direct to employer

πŸ›‘οΈ Vetted companies, no scams, true remote only

Unlock All Jobs Now

Maybe later