Mortgage Domain SME (Data & Analytics)

VMC Soft Technologies, Inc; Westlake Village (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

VMC Soft Technologies, Inc is seeking a Mortgage Domain SME to analyze mortgage data across the loan lifecycle while ensuring compliance with MISMO standards. The successful candidate will have strong experience in data modeling using Snowflake and advanced SQL, as well as solid expertise in mortgage data governance. You will be responsible for defining data mappings, developing metrics for analytics, and supporting credit risk and performance models. Interested candidates should email their resumes to [e-mail].

Qualifications

• Strong knowledge of the mortgage loan lifecycle and mortgage data.
• Hands on experience with MISMO standards and data mappings.
• Expertise in dimensional and analytical data modeling.
• Advanced SQL skills for large, complex datasets.
• Proven experience working in Snowflake (data modeling, performance tuning).
• Experience supporting analytics and modeling use cases (risk, performance, or credit).
• Strong focus on data quality, governance, and documentation.

Responsibilities

• Analyze mortgage data across the full loan lifecycle including origination, underwriting, closing, servicing, and secondary market.
• Own alignment of enterprise mortgage data to MISMO standards.
• Define and maintain data mappings from various systems to MISMO compliant structures.
• Design and maintain enterprise scale analytical data models in Snowflake.
• Translate complex MISMO XML/JSON structures into relational data models.
• Develop and optimize advanced SQL for large scale mortgage datasets.
• Leverage Snowflake capabilities to support analytics and modeling workloads.
• Perform exploratory data analysis to identify quality issues and emerging trends.
• Develop mortgage specific metrics for analytics and modeling use cases.
• Support credit risk and performance models by validating data inputs.
• Define data quality controls aligned with MISMO business rules.
• Document data models and SQL logic to support governance.

Skills

Mortgage - Servicing

Snowflake

MySQL

Retail Mortgages

Job description

Contract

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

Role: Mortgage Domian SME

Job Description:

• Analyze mortgage data across the full loan lifecycle (origination, underwriting, closing, servicing, and secondary market)
• Own alignment of enterprise mortgage data to MISMO standards, logical data models, and industry best practices
• Define and maintain data mappings from LOS, servicing, credit, and investor systems to MISMO compliant structures
• Design and maintain enterprise scale analytical and dimensional data models (star/snowflake schemas) in Snowflake
• Translate complex MISMO XML/JSON structures into performant, analytics ready relational data models
• Develop, optimize, and review advanced SQL for large scale mortgage datasets; ensure performance and maintainability
• Leverage Snowflake capabilities (clustering, secure views, CTEs, performance tuning) to support scalable analytics and modeling workloads
• Perform exploratory data analysis to identify data quality issues, emerging portfolio trends, and model impacting risks
• Develop and curate mortgage specific metrics and features (e.g., LTV, DTI, delinquency indicators) for analytics and modeling use cases
• Support credit risk, prepayment, and performance models by validating data inputs and ensuring ongoing data readiness
• Define and implement data quality controls aligned with MISMO business rules, investor requirements, and regulatory expectations
• Document data models, data definitions, and SQL logic to support governance, auditability, and reuse

Qualifications

• Strong knowledge of the mortgage loan lifecycle and mortgage data
• Hands on experience with MISMO standards and data mappings
• Expertise in dimensional and analytical data modeling
• Advanced SQL skills for large, complex datasets
• Proven experience working in Snowflake (data modeling, performance tuning)
• Experience supporting analytics and modeling use cases (risk, performance, or credit)
• Strong focus on data quality, governance, and documentation

Skills: Mortgage - Servicing, Digital : Snowflake, MySQL, Retail Mortgages

Share resume at [e-mail]