Urgent Job opening- Mortgage Domain SME (Data & Analytics) - Westlake Villa at Cystems Logic Inc

Westlake Village, California, United States -

Full Time

Start Date

Immediate

Expiry Date

21 Jul, 26

Salary

0.0

Posted On

22 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Mortgage Domain, Data Modeling, Snowflake, SQL, MISMO Standards, Data Analytics, Dimensional Modeling, Data Quality, Risk Analytics, Performance Tuning, XML, JSON, Data Mapping, Loan Lifecycle, Regulatory Compliance

Industry

Human Resources Services

Description

Job Description Hi, Job Title: Mortgage Domain SME (Data & Analytics) Location : Fully Onsite - 1st Preference: Westlake Village, CA 2nd Preference: Carrolton, TX 3rd Preference: Cary, NC Duration : 6 months Contract We have below longterm job opening. If you are interested , Please send your updated resume with below details. Your current location: Visa status: Availability: Expected rate all inc on c2c ( 6% VMS and Payment terms Net 60 ) : Job Summary: Mortgage Domain SME responsible for analyzing mortgage data across the full loan lifecycle and aligning enterprise data with MISMO standards. The role focuses on building scalable analytical data models optimizing SQL performance and supporting risk and analytics use cases using Snowflake and enterprise data platforms. Role Descriptions: Analyze mortgage data across the full loan lifecycle including origination underwriting closing servicing and secondary market Align 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 and snowflake schemas) in Snowflake Translate complex MISMO XML JSON structures into analytics ready relational data models Develop optimize and review advanced SQL for large scale mortgage datasets ensuring performance and maintainability Leverage Snowflake capabilities such as clustering secure views CTEs and performance tuning for scalable analytics Perform exploratory data analysis to identify data quality issues trends and risks Develop and curate mortgage specific metrics and features such as LTV DTI and delinquency indicators Support credit risk prepayment and performance models by validating data inputs and ensuring readiness Define and implement data quality controls aligned with MISMO business rules investor requirements and regulatory expectations Document data models definitions and SQL logic for governance auditability and reuse Required Skills & Qualifications: Strong knowledge of 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 including data modeling and performance tuning Experience supporting analytics and modeling use cases such as risk performance or credit Strong focus on data quality governance and documentation. Skills: Mortgage - Servicing Digital : Snowflake MySQL Retail Mortgages Thanks & Regards, Girish Kumar Additional Information All your information will be kept confidential according to EEO guidelines.

Responsibilities

The Mortgage Domain SME will analyze mortgage data across the loan lifecycle and align enterprise data with MISMO standards. They are responsible for designing scalable analytical data models in Snowflake and optimizing SQL performance for risk and analytics use cases.