Sign upLog in

Mortgage Domian SME

Artech LLC

Westlake Village, CA,, CA

Apply
JOB DETAILS
SALARY
$70–$75 Per Hour
SKILLS
Best Practices, Credit Risk, Data Analysis, Data Entry, Data Modeling, Data Quality, Data Sets, Dimensional Modeling, Documentation, Documentation Models, Identify Issues, JSON, LifeTime Value (LTV), Loan Origination, Metrics, Model Validation, Mortgage, Mortgage Lending, Past Due Accounts, Performance Modeling, Performance Tuning/Optimization, Regulatory Requirements, Risk, Risk Modeling, SQL (Structured Query Language), Secondary Markets, Snowflake Schema, Star Schema, Trend Analysis, Underwriting, Use Cases, XML (EXtensible Markup Language)
LOCATION
Westlake Village, CA,, CA
POSTED
27 days ago
Request ID: 90987-1
Title: Mortgage Domian SME
Locations: 100% Onsite: Westlake Village, CA,
Duration: 6+ Months with Possible Extension.
Salary Range: $60- $75/Hour on W2/C2C (All inclusive)
Fully Onsite from Day 1:
 
Job Descriptions:
  • 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
  • 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, Snowflake, MySQL, Retail Mortgages, Data Concepts & Data Modelling, Mortgage – Underwriting, Data Architecture and Modeling
Experience Required: 8-10
 
Location:
1st Preference: Westlake Village, CA
2nd Preference: Carrolton, TX
3rd Preference: Cary, NC
 
Company Benefits & Culture
  • Inclusive and diverse work environment
  • Opportunities for professional growth and development
  • Comprehensive health and wellness benefits

Appreciate your quick response and please feel free to reach me out for any query you may have.

Thanks
 

About the Company

A

Artech LLC

Resume Resources

Free Resume TemplatesFree Resume Builder