Senior Data Analyst

Data Analyst with Mortgage Experience Westlake Village, CA / Carrolton, TX / Cary, NC Experience: 10+ years Mortgage Domain Experience is Mandatory 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" " • 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" Technical Recruiter VMC Soft Technologies inc. EMail: recruiterbang@vmcsofttech.com Ph No: : 480-750-7071 Ext: 241