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
Truck Driver delivering agricultural products to customers at CHS providing reliable service and maintaining safety measures. Responsible for loading, unloading, and ensuring timely deliveries to clients.
Truck Driver/Operations Specialist responsible for hauling agricultural products and daily operations for CHS in New Salem, ND. Ensuring safe deliveries, compliance, and excellent customer service.
Loan Operations Commercial Loan Closer at a financial services institution managing closing processes for commercial loans. Collaborating with various partners to ensure timely loan document preparation and compliance.
Data Operations Analyst in Green Street’s IJGlobal Data Operations team ensuring the accuracy and reliability of financial data. Managing data input, analysis and reporting on market trends.
Operations Technician ensuring maintenance of facility equipment and successful pipeline operations at Williams. Demonstrating technical expertise while adhering to safety protocols and operational standards.
Operations Technician Senior ensuring facility equipment maintenance and successful pipeline operations for clean energy at Williams. Demonstrating technical expertise and analyzing data to resolve operational problems.
Technology Operations Lead at JLL providing strategic business intelligence for decision - making. Involves operations strategy and complex data storytelling for executive presentations.
Operations Work Coordinator managing daily work plans for crews at Xcel Energy, focusing on safety and efficiency while ensuring customer satisfaction and regulatory compliance.
Director of Operations responsible for all operational functions including supply chain and logistics. Leading development of new operational capabilities aligned with company strategy.
Coordenador de Planejamento e Operações no Brasil para a Capco, coordenando recursos e garantindo eficiência em processos operacionais em ambiente híbrido.