Job Description:

• Systems analyst for mortgage loan application and closing domain (UCD – Uniform Closing Data) and its related operation and analytics.

• Support enhancing the Closing data mart as per business requirements. Development, Testing and Validation.

• Design and build the dashboards, analytics related to Closing data
• Perform regular and ad-hoc analytics for client's Affordable housing goal tactics including Equitable Housing, Special Purpose Credit Program (SPCP), FHFA reporting mandates and closing cost initiatives around borrower’s cost savings on total closing cost, various settlement fees etc.
• Collaborate with multiple business teams to gather requirements and develop code for model data, reporting and analytics.
• Monitor data quality and consistency across Loan Closing Loan Advisor (LCLA) and associated Prime Market Loan application (PML App) and Loan Advisor applications (loan application and funded data) and ensure all data controls are working.
• Develop and maintain all required documentation.

• SQL
• Tableau
• Python
• Databases (Sybase, Oracle or UDB)
• MS Office tools (Access, Excel, Power Point, Word)
• Strong communication and writing skills