Analyst, Debt Operations Analytics

Overview

Analyze data, build dashboards, and support systems for CRE debt operations.

Key Responsibilities

• model updates
• exception checks
• uat coordination
• report building
• data visualization
• documentation

Tasks

-Maintain documentation such as change logs, field dictionaries, release notes, submission checklists, and quick-reference guides; support training on new features, reports, and models. -Support underwriting model updates in Excel/VBA; maintain change logs; validate calculations against sample loans; and publish release notes. -Implement exception checks for critical data elements across loan handoffs; run pre-submission validations for lender systems/portals; reconcile error files; document rules/thresholds; and partner with business units on root-cause remediation. -Coordinate and execute user acceptance testing (UAT) for systems used by Debt Operations; log and track issues to closure; validate production releases. -Build and maintain self-serve reports and dashboards (Power BI/Excel); perform ad-hoc analyses to surface risks and opportunities. -Aggregate data from multiple systems, create clear visualizations, and prepare executive-ready PowerPoint decks. -Collaborate with Underwriting, Closing, Compliance (Loan Quality), Technology, and Servicing to prioritize fixes, align definitions, and communicate concise updates.

Requirements

• power bi
• power query
• excel
• vba
• sql
• powerpoint

What You Bring

-Technology-focused mindset with aptitude for learning new tools and systems. -Expertise in Power BI and Power Query (M), including data modeling, DAX, transformations, and performance tuning; ability to build reliable, production-grade dashboards. -Advanced Excel with strong VBA/macro skills; experience debugging complex workbooks, auditing formulas, and versioning; working knowledge of SQL (or willingness to learn quickly). -Attendance is generally required from 8:30 am – 5:30 pm local time, Tuesday through Thursday, with the option to work remotely on Mondays and Fridays. -Courtesy, respect, and thoughtfulness in teaming with colleagues and other stakeholders. -Ability to show ownership of your work, take on challenges and acknowledge growth opportunities, and demonstrate patience when learning new processes. -Demonstrated proficiency in data analysis and systems support; commercial real estate or financial services exposure preferred. -Clear communicator with strong organizational skills and deadline reliability. -Bachelor’s degree in Finance, Accounting, Business Administration, or related field required (or equivalent relevant work experience). -Strong PowerPoint skills for data storytelling and senior-level presentations.

People Also Searched For

Benefits

-The opportunity to join one of Fortune Magazine’s Great Places to Work winners from 2015-2023 -Career development opportunities -401(k) + match -Company-paid life, short and long-term disability insurance -Health Savings Account and Healthcare and Dependent Care Flexible Spending -Competitive dental and vision benefits -A robust health and wellness program – earn cash rewards and gain access to resources that -Pre-tax transit and commuting benefits -Up to 83% subsidized medical payroll deductions -Comprehensive benefit options* that have earned Walker & Dunlop the silver level of the 2022 Cigna Healthy Workforce Designation™, some of which include: -Empowerment and encouragement to give back – volunteer hours and donation matching -Paid maternity and parental leave, as well as other family paid leave programs

About Walker & Dunlop

-Provides capital solutions for commercial real estate transactions across multiple sectors. -Diverse portfolio includes financing for residential, industrial, commercial, and mixed-use projects. -Offers capital markets, loan servicing, investment sales, and agency lending services. -Notable projects include financing for major office buildings, residential complexes, and large-scale industrial facilities. -Continuously innovates with technology to enhance financial solutions.

Sector Specialisms

Security Clearance

-background checks are performed after a conditional offer is accepted and may include questions about arrests or convictions, in accordance with federal, state, and local laws.