Data Analyst

Job Description

Job Role: Data analyst 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