Data Modeler – MISMO & Mortgage Servicing

Veriipro; Westlake Village (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

Veriipro is seeking a qualified data modeler located in Westlake Village, California. The ideal candidate will design and maintain data models for enterprise data platforms, particularly in the mortgage insurance sector. Strong experience with MISMO standards and advanced SQL skills are essential for success in this role.

The position involves collaboration with various stakeholders to translate complex mortgage servicing requirements into effective data solutions while optimizing models specifically for Snowflake environments.

Qualifications

• 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, and data exchange frameworks.

Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise data platforms.
• Develop and optimize data models for Snowflake environments.
• Create complex SQL queries for data integration and reporting.

Skills

Mortgage Insurance expertise

Active Servicing knowledge

Default Servicing experience

Secondary Market processes

MISMO standards

SQL skills

Experience with JSON

Tools

Snowflake

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.