Default Data Program Analyst Details

Default Data Program Analyst

Flagstar Bank - Troy, MI

Employment Type : Full-Time

The Default Data Program Analyst provides reporting and analytics support for all functional areas within DSO. Primary responsibilities include the synthesis of information from multiple data sources into sophisticated BI solutions. Individual may support cross functional projects with multiple stakeholders in order to achieve the desired BI solution. Individual should be proficient in requirements gathering, data modelling, data mining, and BI solution development in support of highly visible, complex, multi-workstream operational processes. Analyst must be able to work in a team and individual setting managing multiple priorities with very little management oversight. Technical proficiency is required in Microsoft Office Applications, Microsoft VBA, Oracle Database, and various web-based Data Visualization tools. Working knowledge of residential mortgage servicing business, specifically default servicing processes and regulations, is preferred. Individual must also have a willingness to learn additional reporting and business intelligence softwares, and be able to utilize other data management and data governance tools as necessary.

Job Responsibilities:

• Designs and maintains reports & Dashboards using SQL, PL/SQL, Visual Basic scripts through Business Intelligence tools such as IBM Cognos, SAP and Tableau. Develops, monitors, delivers and provides clarity and context surrounding daily operational reports to internal support personnel.
• Gathers report writing requirements from business partners to determine scope and scalability behind project deliverables. Communicates with leadership to determine priorities within the default servicing team in support of the default related reporting suite. Creates ad-hoc reporting based on requests from Investors/Insurers, MSR-Owners, Internal Audit, Regulators, and Ratings Agencies.
• Performs initial and ongoing testing to ensure quality standards within reporting solutions to meet all report writing requirements. Compares report output to servicing system of record and/or existing reporting. Solutions with business partners to reconcile all quality data discrepancies.
• Collaborates across multiple business units to assist in the continued development of a best in class servicing operation.
• Ensures compliance with applicable federal, state and local laws and regulations. Completes all required compliance training. Maintains knowledge of and adhere to Flagstar’s internal compliance policies and procedures. Takes responsibility to keep up to date with changing regulations and policies.

Job Requirements:

• Reliable Home High Speed Internet required
• Bachelor’s Degree in Computer Science, Engineering, or Information Technology required
• 3+ years’ experience in reporting development, servicing systems including familiarity with reporting in MSP or Loansphere.
• 2+ years’ experience in developing and implementing enterprise scale reports and dashboards via various BI reporting tools (ie, Cognos, Business Objects, Tableau, or SAP) with mortgage servicing experience preferred.
• Experience in leveraging data in servicing systems (BKFS LoanSphere, MSP, and other Black Knight systems)preferred
• Working knowledge of data warehouse and data governance
• Working understanding of risk, compliance and regulatory & investor requirements
• Advanced technical and analytical skills specifically in Excel, Access, SQL, Cognos, OBIEE, and other database management applications.
• Strong problem solving & strategic thinking skills with the ability to identify problems and recommend solutions
• Exceptional written and oral communication including facilitation & summarization skills to drive action and results
• Must be highly organized and have a strong attention to detail including the ability to create and maintain documentation
• Ability to work with, lead and consult with all levels in the organization up to and including executives
• Have an innate ability to understand very complex processes and systems, immediately and intuitively understanding how they work and how they can be improved
• Adjusts positively to quickly-changing priorities and shifting goals
• Strong ability to work with a sense of urgency in a fast paced environment

• Some travel required - Up to 15% on an as needed basis

Internal Use Only: Job Band G