Analyze mortgage-related data, support decision-making, generate business insights, and contribute to ongoing data integration and reporting initiatives.
Requirements
- 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
- Exposure to cloud platforms (AWS/Azure/GCP) is desirable
Responsibilities
- Analyze mortgage loan data, origination, servicing, delinquency, and default trends.
- 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.
Other
- Collaborate with business stakeholders to gather data requirements and translate them into actionable insights.
- Knowledge of US mortgage regulations and investor guidelines (e.g., Fannie Mae, Freddie Mac) is a plus
- Experience working in Agile/Scrum environments
