Job Summary:
We are seeking a skilled Data Analyst with strong experience in the Mortgage domain to join our team. The ideal candidate will be responsible for analyzing mortgage-related data, supporting decision-making, generating business insights, and contributing to ongoing data integration and reporting initiatives.
Key Responsibilities:
Analyze mortgage loan data, origination, servicing, delinquency, and default trends.
Collaborate with business stakeholders to gather data requirements and translate them into actionable insights.
Develop dashboards and reports using tools such as Power BI or Tableau.
Write complex SQL queries to extract, manipulate, and validate data from relational databases.
Work with ETL pipelines to clean, transform, and load data for reporting.
Document business rules, data definitions, and report specifications.
Provide data-driven insights for process improvements and risk analysis in mortgage operations.
Ensure data quality and consistency across systems and processes.
Required Skills:
Strong knowledge of SQL (must-have)
Hands-on experience with Power BI / Tableau / Looker
Experience working with Excel, Python (Pandas/Numpy optional), and ETL tools
Familiarity with data modeling and data warehouse concepts
Good understanding of mortgage lifecycle – Origination, Underwriting, Servicing, Foreclosure, etc.
Experience working with large datasets and relational databases
Preferred Qualifications:
Bachelor’s or Master’s degree in Computer Science, Information Systems, Finance, or related field
Experience working in Agile/Scrum environments
Knowledge of US mortgage regulations and investor guidelines (e.g., Fannie Mae, Freddie Mac) is a plus
Exposure to cloud platforms (AWS/Azure/GCP) is desirable