Analyst, Debt Operations Analytics
Walker & Dunlop
Provide data analysis, reporting, and system support for debt operations.
16 days ago ago
$60,000 - $70,000
Expert & Leadership (13+ years), Intermediate (4-7 years), Experienced (8-12 years)
Full Time
Bethesda, MD
Office Full-Time
Company Size
1,300 Employees
Service Specialisms
Loan administration
Insurance compliance
Asset management
Investor reporting
Capital markets
Consulting
Valuation
Loan servicing
Sector Specialisms
Multifamily
Hospitality
Industrial
Commercial Real Estate
Loan Servicing
Investment Management
Valuation
Advisory Services
Role
What you would be doing
model updates
excel vba
data visualization
power bi
data validation
uat
- Collaborate with Underwriting, Closing, Compliance (Loan Quality), Technology, and Servicing to prioritize fixes, align definitions, and communicate concise updates.
- Support underwriting model updates in Excel/VBA; maintain change logs; validate calculations against sample loans; and publish release notes.
- Maintain documentation such as change logs, field dictionaries, release notes, submission checklists, and quick-reference guides; support training on new features, reports, and models.
- Aggregate data from multiple systems, create clear visualizations, and prepare executive-ready PowerPoint decks.
- Build 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.
- Coordinate and execute user acceptance testing (UAT) for systems used by Debt Operations; log and track issues to closure; validate production releases.
What you bring
power bi
power query
advanced excel
sql
powerpoint
bachelor's
- Expertise in Power BI and Power Query (M), including data modeling, DAX, transformations, and performance tuning; ability to build reliable, production-grade dashboards.
- Bachelor’s degree in Finance, Accounting, Business Administration, or related field required (or equivalent relevant work experience).
- Technology-focused mindset with aptitude for learning new tools and systems.
- Clear communicator with strong organizational skills and deadline reliability.
- 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.
- Demonstrated proficiency in data analysis and systems support; commercial real estate or financial services exposure preferred.
- 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.
- Empowerment and encouragement to give back – volunteer hours and donation matching
- The opportunity to join one of Fortune Magazine’s Great Places to Work winners from 2015-2023
- Comprehensive benefit options* that have earned Walker & Dunlop the silver level of the 2022 Cigna Healthy Workforce Designation™, some of which include:
- Career development opportunities
- Paid maternity and parental leave, as well as other family paid leave programs
- Up to 83% subsidized medical payroll deductions
- Pre-tax transit and commuting benefits
- Company-paid life, short and long-term disability insurance
- A robust health and wellness program – earn cash rewards and gain access to resources that
- 401(k) + match
- Health Savings Account and Healthcare and Dependent Care Flexible Spending
- Competitive dental and vision benefits
Information not given or found
Interview process
Information not given or found
Visa SponsorshipInformation not given or found
Security clearance- background checks occur after a conditional offer; arrest and conviction records are reviewed per applicable laws.
People also searched
Data Analyst Jobs in Silver Spring United StatesBusiness Analyst Jobs in Silver Spring United StatesData Analytics Jobs in Silver Spring United StatesOperations Analyst Jobs in Silver Spring United StatesBI Analyst Jobs in Silver Spring United StatesBusiness Analytics Jobs in Silver Spring United StatesBI Developer Jobs in Silver Spring United StatesData Analyst Jobs in Arlington United States
Company
Overview
1937 Founded
Year Established
The company was established in 1937, marking the beginning of its journey as a leading commercial real estate financial firm.
- 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.
- Driven – We aspire to excellence, never content with just checking the box. We constantly strive to meet the ambitious goals we set for ourselves and take pride in being a passionate team of self‑starters who make a real difference.
- Caring – We cultivate a welcoming culture that empowers and supports individuals to always be the best version of themselves. This spirit extends beyond our employees to encompass our clients, partners, communities, and environment.
- Collaborative – We excel in many disciplines, but we are one team. With the right combination of talent and expertise, we create something bigger than ourselves that serves the needs of our clients and builds lasting relationships.
- Insightful – We value the insights our seasoned team brings to the table because we know the future depends on varying thoughts and creative solutions.
- Tenacious – We never give up in our quest to go the extra mile for our clients. We strive to understand their goals and work with them at every step of the way. We always do what it takes to get the job done well and with integrity.
50% Emission Reduction
Target per employee since 2019
Aiming to reduce greenhouse gas emissions by 50% per employee from 2019 levels.
33.5B in Affordable Housing
Financed over four years
Total amount financed in affordable housing properties over the past four years.
1.6M Donation
Part of annual giving
Charitable donation amount, representing 1.21% of the company's operating income in 2024.
- Participation in Fannie Mae Green Rewards and Freddie Mac Green Advantage programs to support energy and water reduction in financed properties.
- Measured corporate carbon footprint using third-party consultant based on the Greenhouse Gas Protocol.
- Implemented green office practices: compostable coffee cups, reusable water bottles, default double-sided printing.
- Encouraged green commuting: flexible telecommuting policy, pre-tax public transit, Waze Carpool partnership, commuting contests.
- Governance oversight by CEO, General Counsel, and ESG committee; supported by employee-led Green Task Force focused on resource and emissions reduction.
28% Management Roles
Women in Leadership
Highlighting the representation of women in management positions within the organization.
14% Management Roles
Underrepresented Groups
Showcasing the inclusion of under-represented racial/ethnic groups in management positions.
$1 Million Investment
DE&I Partnerships
Highlighting the financial commitment to organizations advancing diversity, equity, and inclusion initiatives.
#13 Diversity Index
Corporate Recognition
Recognized for diversity efforts in the Washington Business Journal Corporate Diversity Index 2021.
- Recognized in Bloomberg's 2022 Gender Equality Index.
- Received Mortgage Bankers Association's Commercial/Multifamily DEI Leadership Award for Market & Community Outreach Strategies in 2023.
- 25% of employees participated in one or more Employee Resource Groups in 2023.
- Striving to increase minorities in management positions to 25%.
Kablio AIIf you're someone who helps build and power the world (or dreams to), Kablio AI is your pocket-sized recruiter that gets you hired.
Copyright © 2025 Kablio