← Back to jobsJob ID col-cmwp90axd08hnd8ha9p8kbw67

Consolidated AnalyticsPosted 1 day ago

MSP Conversion Data AnalystNew

Full-time
Remote
5+ years
Competitive
Posted 1 day ago

Consolidated Analytics is seeking a technical BA for an ICE MSP residential mortgage servicing system conversion. The role focuses on conversion data mapping, validation, testing, business-to-technical coordination, and investor reporting and reconciliation processes.

Posted
1 day ago
Source
consolidatedanalytics.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

  • extensive, expert-level knowledge of the inner workings of the ICE MSP residential mortgage servicing system, including its functions, operational workflows, and modules
  • fully capable of working on the technical side of an MSP mortgage servicing system implementation and conversion
  • 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

Required skills

Data MappingData ValidationMicrosoft ProjectUser Acceptance Testing (UAT)

Nice to have

Project Management

Full job description

Consolidated Analytics is seeking a technical BA for an ICE MSP residential mortgage servicing system conversion. The role focuses on conversion data mapping, validation, testing, business-to-technical coordination, and investor reporting and reconciliation processes.

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)

Benefits

  • Medical Insurance
  • Dental Insurance
  • Vision Insurance
  • Life & Disability Insurances

Company

  • Mortgage due diligence, valuation, and business process solutions
  • Santa Ana, California, USA
  • http://www.consolidatedanalytics.com/
  • Founded in 1996
  • 501-1000 employees

Qualifications

  • extensive, expert-level knowledge of the inner workings of the ICE MSP residential mortgage servicing system, including its functions, operational workflows, and modules
  • fully capable of working on the technical side of an MSP mortgage servicing system implementation and conversion
  • 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
  • Extensive, expert-level knowledge of the inner workings of the ICE MSP residential mortgage servicing system, including its functions, operational workflows, and modules
  • Fully capable of working on the technical side of an MSP mortgage servicing system implementation and conversion
  • 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).

Required skills

  • Data Mapping, Data Validation, MSP Mortgage Servicing System Implementation and Conversion, Microsoft Project, User Acceptance Testing (UAT)

Preferred skills

  • Project Management

Experience

  • 5+ years

Job details

Employment type

Full-time

Seniority level

5+ years

Date posted

Nov 20, 2026

Work mode

Remote

Job source

consolidatedanalytics.com

Company

Consolidated Analytics

Information Technology & AI

Mortgage due diligence, valuation, and business process solutions

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs

Computercraft Corporation

1d ago

New

Biomedical Data Analyst

Full-timeRemoteUnited States$110K – $135K/yr

Computercraft is hiring a Biomedical Data Analyst to support the National Library of Medicine at the National Institutes of Health.

Why similarSame role

Arkhya Tech Inc.

1d ago

New

Sr. Data Analyst – Data Discovery & Metrics

Full-timeOn-siteAustin, TXCompetitive

Arkhya Tech Inc. is seeking a Senior Data Analyst focused on enterprise data discovery, profiling, availability, and gap analysis.

Why similarSame roleData Mapping

Consulting

1d ago

New

Senior Data Analyst

Full-timeOn-siteMcLean, VACompetitive

Zillion Technologies, Inc. is seeking a Senior Data Analyst to support enterprise application modernization by analyzing legacy data ecosystems and ensuring data integrity through migration.

Why similarSame roleData Mapping

Get new Data Analyst jobs by email

Create job alert

MSP Conversion Data Analyst

Consolidated Analytics · Competitive

Apply on company site