Senior Data Analyst

Carrollton, Texas, United StatesOnsiteContractPosted 1 day agoVisa sponsorship available

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

Ready to apply?

You'll be redirected to VMC Soft Technologies, Inc's application page.