Analyst, Debt Operations Analytics at Walker & Dunlop in Needham, MA | USD60,000-70,000 | Kablio

Role

Description

excel vba

power bi

uat execution

data validation

documentation

stakeholder coordination

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.
Build and maintain self-serve reports and dashboards (Power BI/Excel); perform ad-hoc analyses to surface risks and opportunities.
Coordinate and execute user acceptance testing (UAT) for systems used by Debt Operations; log and track issues to closure; validate production releases.
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.
Maintain documentation such as change logs, field dictionaries, release notes, submission checklists, and quick-reference guides; support training on new features, reports, and models.

Requirements

advanced excel

vba

sql

power bi

power query

bachelor's

Ability to show ownership of your work, take on challenges and acknowledge growth opportunities, and demonstrate patience when learning new processes.
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.
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.
Expertise in Power BI and Power Query (M), including data modeling, DAX, transformations, and performance tuning; ability to build reliable, production-grade dashboards.
Technology-focused mindset with aptitude for learning new tools and systems.
Bachelor’s degree in Finance, Accounting, Business Administration, or related field required (or equivalent relevant work experience).
Courtesy, respect, and thoughtfulness in teaming with colleagues and other stakeholders.
Demonstrated proficiency in data analysis and systems support; commercial real estate or financial services exposure preferred.

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

background checks will be conducted after a conditional offer; fair chance hiring policy applies.

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.

Culture + Values

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.

Environment + Sustainability

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.

Inclusion & Diversity

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%.

Articles

Careers

Culture – Diversity, Equity & Inclusion

Women in leadership

Role

Description

excel vba

power bi

uat execution

data validation

documentation

stakeholder coordination

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.
Build and maintain self-serve reports and dashboards (Power BI/Excel); perform ad-hoc analyses to surface risks and opportunities.
Coordinate and execute user acceptance testing (UAT) for systems used by Debt Operations; log and track issues to closure; validate production releases.
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.
Maintain documentation such as change logs, field dictionaries, release notes, submission checklists, and quick-reference guides; support training on new features, reports, and models.

Requirements

advanced excel

vba

sql

power bi

power query

bachelor's

Ability to show ownership of your work, take on challenges and acknowledge growth opportunities, and demonstrate patience when learning new processes.
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.
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.
Expertise in Power BI and Power Query (M), including data modeling, DAX, transformations, and performance tuning; ability to build reliable, production-grade dashboards.
Technology-focused mindset with aptitude for learning new tools and systems.
Bachelor’s degree in Finance, Accounting, Business Administration, or related field required (or equivalent relevant work experience).
Courtesy, respect, and thoughtfulness in teaming with colleagues and other stakeholders.
Demonstrated proficiency in data analysis and systems support; commercial real estate or financial services exposure preferred.

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

background checks will be conducted after a conditional offer; fair chance hiring policy applies.

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.

Culture + Values

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.

Environment + Sustainability

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.

Inclusion & Diversity

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%.

Articles

Careers

Culture – Diversity, Equity & Inclusion

Women in leadership