Analyst, Debt Operations Analytics

Department:Servicing - OperationsWe are Walker & Dunlop. We are one of the largest providers of capital to the commercial real estate industry, enabling real estate owners and operators to bring their visions of communities — where people live, work, shop, and play — to life. We are committed to creating meaningful social, environmental, and economic change in our communities. Department OverviewThe Debt Operations department encompasses the Underwriting, Closing, Servicing, and Asset Management teams, which collaborate closely to manage all credit and operational functions within W&D’s GSE lending platform. These teams are dedicated to processing client business with a high degree of efficiency and meticulous attention to detail while ensuring strict adherence to credit policies as well as all lender and investor requirements. The Servicing team is highly rated with its Fitch rating of CPS1- and manages the 10th largest CRE debt portfolio in the United States.Supporting these core functions, the Debt Operations Compliance & Analytics team provides comprehensive risk oversight, ensures process integrity, and delivers data-driven insights across the entire Debt Operations platform. This team plays a critical role in enabling Underwriting, Closing, Servicing, and Asset Management to operate effectively and maintain compliance with regulatory standards.The Impact You Will Have The Analyst provides data, reporting, and systems support across Underwriting, Closing, Servicing, and Asset Management. This role builds and maintains dashboards, runs data-quality checks, coordinates user acceptance testing, and supports underwriting model updates. This role also ensures submission-ready data for lender systems and portals, while packaging insights for senior management through clear analysis, visualizations, and presentation materials.Primary ResponsibilitiesBuild and maintain self-serve reports and dashboards (Power BI/Excel); perform ad-hoc analyses to surface risks and opportunities.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.Aggregate data from multiple systems, create clear visualizations, and prepare executive-ready PowerPoint decks.Coordinate and execute user acceptance testing (UAT) for systems used by Debt Operations; log and track issues to closure; validate production releases.Support underwriting model updates in Excel/VBA; maintain change logs; validate calculations against sample loans; and publish release notes.Collaborate with Underwriting, Closing, Compliance (Loan Quality), Technology, and Servicing to prioritize fixes, align definitions, and communicate concise updates.Maintain documentation such as change logs, field dictionaries, release notes, submission checklists, and quick-reference guides; support training on new features, reports, and models.Perform other duties as assigned.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.Education and ExperienceBachelor’s degree in Finance, Accounting, Business Administration, or related field required (or equivalent relevant work experience).Demonstrated proficiency in data analysis and systems support; commercial real estate or financial services exposure preferred.Knowledge, Skills and AbilitiesExpertise 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).Strong PowerPoint skills for data storytelling and senior-level presentations.Clear communicator with strong organizational skills and deadline reliability.Technology-focused mindset with aptitude for learning new tools and systems.Self-starter with a proactive mindset and eagerness to learn.Ability to show ownership of your work, take on challenges and acknowledge growth opportunities, and demonstrate patience when learning new processes.Courtesy, respect, and thoughtfulness in teaming with colleagues and other stakeholders.This position has an estimated base salary of $60,000 - $70,000 plus discretionary bonus. An employment offer is based on the applicant’s relevant work experience, applicable knowledge, skills, abilities, internal equity, and alignment with market data.#LI-NA1#LI-HybridWhat We OfferThe opportunity to join one of Fortune Magazine’s Great Places to Work winners from 2015-2023Comprehensive benefit options* that have earned Walker & Dunlop the silver level of the 2022 Cigna Healthy Workforce Designation™, some of which include: - 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  *Eligibility may vary based on average number of hours worked EEO StatementWe are committed to equity in all steps of the recruitment and employment experience. We believe in equal access to opportunities in our workplace. We do not tolerate discrimination, including harassment, based on any characteristic protected by applicable law, such as race, color, national origin, religion, gender identity, sexual orientation, sex, age, disability, veteran or military status, and genetic information, or any other characteristic protected by applicable law. We strive to be a safe place to ask questions, build professional relationships, and develop careers.SPAMPlease be wary of recruitment scams.