Walker & Dunlop

Loan Quality and Reporting Analyst

Walker & Dunlop

full-time

Posted on:

Location Type: Hybrid

Location: Walnut CreekCaliforniaMarylandUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $55,000 - $65,000 per year

Tech Stack

About the role

  • Support loan quality review activities under the direction of Loan Quality leadership, including end-to-end file testing and thematic reviews against internal standards and applicable guides.
  • Document work performed, evidence reviewed, exceptions identified, and conclusions reached in a clear, reproducible manner.
  • Maintain organized workpapers and an evidence library to support internal reviews, audits, and examinations.
  • Support assigned KYC/AML testing activities and escalate exceptions in accordance with established protocols.
  • Maintain control inventory records for Underwriting and Closing, including control objectives, owners, frequency, and evidence location.
  • Support testing of control design and operating effectiveness through assigned evaluation steps and complete documentation.
  • Ensure control evidence is current, complete, and stored in accordance with team standards.
  • Maintain trackers for management action plans, including status updates, due dates, closure evidence, and escalation of overdue items, as well as create reporting/data visualization for management reporting.
  • Coordinate audit and examination request lists by tracking deliverables, gathering supporting materials, and confirming submissions are complete and consistent.
  • Build and maintain recurring reports and dashboards to support Loan Quality leadership and business stakeholders.
  • Perform ad hoc analyses to identify trends, exceptions, risks, and process improvement opportunities.
  • Document validation rules, thresholds, and recurring issues, and partner with business and Technology teams to support root-cause remediation.
  • Maintain procedures, work instructions, field definitions, and reference materials related to Loan Quality activities.

Requirements

  • Bachelors degree required.
  • Experience with Power BI, Power Query, SQL, or similar reporting and analytics tools.
  • Proficiency in Excel, including formulas, filtering, lookups, and pivot tables.
  • Familiarity with commercial real estate or multifamily lending concepts preferred.
  • Familiarity with agency programs such as Fannie Mae DUS and Freddie Mac Optigo preferred.
  • Experience supporting control testing, audit requests, remediation tracking, or user acceptance testing preferred.
  • Exposure to KYC/AML review support or control-related documentation preferred.
Benefits
  • Up to 83% subsidized medical payroll deductions
  • Competitive dental and vision benefits
  • 401(k) + match
  • Pre-tax transit and commuting benefits
  • A robust health and wellness program – earn cash rewards and gain access to resources that promote health, engagement, and balance
  • Paid maternity and parental leave, as well as other family paid leave programs
  • Company-paid life, short and long-term disability insurance
  • Health Savings Account and Healthcare and Dependent Care Flexible Spending
  • Career development opportunities
  • Empowerment and encouragement to give back – volunteer hours and donation matching
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLPower BIPower QueryExcelcontrol testingaudit requestsremediation trackinguser acceptance testingdata visualizationad hoc analysis
Soft Skills
organizational skillscommunication skillsattention to detailanalytical skillsproblem-solving skills