
Loan Quality and Reporting Analyst
Walker & Dunlop
full-time
Posted on:
Location Type: Hybrid
Location: Walnut Creek • California • Maryland • United States
Visit company websiteExplore more
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