Data Modeler – MISMO & Mortgage Servicing

2T Consulting

Westlake Village, CA/Cary, NC/Carrollton, TX

Posted On: Jun 08, 2026

Posted On: Jun 08, 2026

Job Overview

Job Type

Full-time

Experience

6 - 10 Years

Salary

Depends on Experience

Work Arrangement

On-Site

Travel Requirement

0%

Required Skills

  • Mortgage Insurance
  • Mortgage Servicing
  • MISMO standards
  • Active Servicing
Job Description
Required Skills
  • Strong experience in Mortgage Insurance and Mortgage Servicing domains.
  • Mandatory expertise in Active Servicing, Default Servicing, and Secondary Market processes.
  • Hands-on experience with MISMO standards, including LDD, XML schemas, servicing data mappings, and data exchange frameworks.
  • Experience designing enterprise data models for modern data platforms, preferably Snowflake.
  • Advanced SQL skills for data transformation, validation, and analysis.
  • Experience working with semi-structured data formats such as JSON.
Primary Responsibilities
  • Design, develop, and maintain conceptual, logical, and physical data models for enterprise data platforms.
  • Develop and optimize data models for Snowflake data warehouse environments.
  • Create complex SQL queries for data integration, transformation, and reporting.
  • Ingest, parse, and transform semi-structured data (JSON) and MISMO-compliant datasets.
  • Collaborate with Product Owners, Data Engineers, Analysts, and business stakeholders to translate mortgage servicing requirements into scalable data solutions.
  • Implement data modeling standards, governance practices, naming conventions, and documentation.
  • Optimize data structures for performance, scalability, and accessibility.
  • Maintain data lineage, metadata, and enterprise data documentation.
Preferred
  • MISMO certification or certification-track experience is preferred; however, strong hands-on expertise in MISMO standards and servicing data models is essential.

Job ID: 2C321442


Posted By

Shayne

Sr. Recruiter