Servicing Credit Risk Data Analyst

Western Alliance Bank•Westlake Village, CA

6d•$84,045 - $103,000

About The Position

As a Servicing Credit Risk Data Analyst you'll be responsible for researching, collecting, and analyzing data in collaboration with the Servicing Quality Control Team. You'll collaborate with the line-of-business and technology teams (Development Team, Business Intelligence, external vendors’ technology teams). Your primary responsibilities include gathering requirements from the servicing teams and the quality control team to assist with change requirements for the technology and engineering teams. Once requirements are built by engineering, you'll conduct UAT testing when needed and ensure specifications and requirements are met. Additionally, you’ll be responsible for weekly, monthly, quarterly and ad hoc reports as required by the Servicing QC team. Work with the Servicing Quality Control team to identify and document data, reporting, and potential system enhancement requirements, assisting in implementation of requirements as needed. Analyze raw mortgage loan servicing related data to identify trends, data anomalies, and opportunity areas. Perform ad hoc data analysis and data studies for Servicing and Servicing Quality Control utilizing SQL, Excel, and other tools. Build Salesforce Objects and Reports. Develop business requirements for recurring reports, scorecards, and control reports. Work with Enterprise Residential Mortgage Compliance to identify Servicing Quality Control data requirements as needed for GRC related reporting. Develop and maintain process controls for Servicing Quality Control to mitigate risk and to improve efficiency. Develop ETL processes with the central technology team. Design process workflows using Lucid or Visio. Manage projects using PMI principles. Assist in the preparation of effective PowerPoint presentations to share reporting, observations, and recommendations with senior management.

Requirements

2+ years of related experience
Bachelor's degree in related field required
Entry level to intermediate knowledge of residential mortgage industry in Correspondent or Retail Lending, including sales, operations, capital markets and/or other residential mortgage products and services
Intermediate experience using Microsoft Office suite of products or similar products
Entry level experience using SQL and C #
Intermediate speaking and writing communication skills

Responsibilities

Researching, collecting, and analyzing data in collaboration with the Servicing Quality Control Team
Collaborating with the line-of-business and technology teams (Development Team, Business Intelligence, external vendors’ technology teams)
Gathering requirements from the servicing teams and the quality control team to assist with change requirements for the technology and engineering teams
Conducting UAT testing when needed and ensure specifications and requirements are met
Responsible for weekly, monthly, quarterly and ad hoc reports as required by the Servicing QC team
Work with the Servicing Quality Control team to identify and document data, reporting, and potential system enhancement requirements, assisting in implementation of requirements as needed
Analyze raw mortgage loan servicing related data to identify trends, data anomalies, and opportunity areas
Perform ad hoc data analysis and data studies for Servicing and Servicing Quality Control utilizing SQL, Excel, and other tools
Build Salesforce Objects and Reports
Develop business requirements for recurring reports, scorecards, and control reports
Work with Enterprise Residential Mortgage Compliance to identify Servicing Quality Control data requirements as needed for GRC related reporting
Develop and maintain process controls for Servicing Quality Control to mitigate risk and to improve efficiency
Develop ETL processes with the central technology team
Design process workflows using Lucid or Visio
Manage projects using PMI principles
Assist in the preparation of effective PowerPoint presentations to share reporting, observations, and recommendations with senior management