Data Modeler – MISMO & Mortgage Servicing

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.

Posted By