Build dashboards, run data-quality checks, coordinate UAT, and support underwriting model updates for Walker & Dunlop's commercial real estate lending operations.
Responsibilities
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; 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; publish release notes
Collaborate with Underwriting, Closing, Compliance (Loan Quality), Technology, and Servicing to prioritize fixes and align definitions
Maintain documentation such as change logs, field dictionaries, release notes, submission checklists, and quick-reference guides; support training on new features, reports, and models
Ensure submission-ready data for lender systems and portals and package insights for senior management
Perform other duties as assigned
Requirements
Bachelor’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
Expertise in Power BI and Power Query (M), including data modeling, DAX, transformations, and performance tuning
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 work and patience when learning new processes
Attendance generally required 8:30 am – 5:30 pm local time, Tuesday through Thursday (option to work remotely Mondays and Fridays)
Benefits
The opportunity to join one of Fortune Magazine’s Great Places to Work winners from 2015-2023
Senior Engineer, Cloud Ops ensuring cloud infrastructure operates efficiently for a SaaS provider in renewable energies. Overseeing compliance, security, and collaboration across development teams.
Manager providing operational and strategic support to Executive Vice Presidents. Overseeing divisional programs and projects aligning with BC Energy Regulator's objectives.
Manager, Operations Partner responsible for driving operational excellence across franchise organizations. Supporting franchise leadership teams to optimize performance and uphold brand standards in the restaurant industry.
Operations Partner optimizing franchisee performance in operational excellence and guest experience for Burger King and other brands. Collaborating with teams to uphold brand standards and drive profitability.
Merchandise Processor responsible for organizing merchandise and clerical support. Ensuring accurate inventory and shipping processes in a fast - paced environment.
Overseeing Microsoft operational functions within CDW’s Sales organization. Focused on supporting the sale and maximizing post - sale activities for Microsoft products.
Senior Manager leading program design and operations strategy for Cardiometabolic Solutions at CVS Health. Focusing on patient care programs and cross - functional collaboration.
Retail Operations Specialist responsible for developing policies and procedures for TBK Bank. Collaborating with teams to enhance operational effectiveness and ensure compliance across branches in the United States.
Process Improvement Specialist responsible for managing retail applications at TBK Bank. Collaborating on workflows and application modifications in financial services with a focus on customer impact.
Consultant, Operational Excellence driving operational excellence initiatives at Early Warning. Collaborating with teams to implement improvements in business processes and enhance efficiency.