Senior VBA Developer

Department:

We 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. We believe seeking diverse talent and promoting the inclusion of all perspectives are more than moral imperatives – they are critical to our success and ability to innovate and grow.

Department Overview

WDTech is W&D’s in-house technology team – a diverse group of energetic and highly skilled technology professionals, all of whom are leading experts in real estate data, data science, and technology.

WDTech Engineering builds solutions that impact not only our products but also the people and processes across our organization. A commitment to innovation and a passion for disrupting the old-fashioned real estate industry are our highest priorities.

The Impact You Will Have

As a Senior Excel VBA Developer, you’ll be responsible for being technically strong and disciplined in Excel Macros/Visual Basic Applications with a proven ability to deliver quality solutions. You’ll be developing robust and maintainable applications to automate API data pulls, real estate underwriting tasks, and report generation across multiple Excel models.

Primary Responsibilities

• Develop and maintain Excel Macros/VBA Code to efficiently automate real estate financial analysis tasks and generate reports

• Optimize scripts to pull data from the Enodo automated underwriting platform using VBA

• Perform unit testing and end-to-end (e2e) testing to ensure the quality and reliability of tools and scripts

• Ensure smooth delivery and support of new tools delivered

• Maintain technical documentation and ensure that knowledge is shared with other members of the team

• Perform other duties as assigned

Education and Experience

• 8+ years of VBA Development experience (report automation, custom application development, bug/error fixing, migration)

• 8+ years of experience in MS Excel (formulas, pivot tables, macros, modeling)

• Experience and work samples from engagements with real estate or finance companies

• Formal education in Computer Science (e.g., Community College classes on CS101 topics, Code School, or equivalent)

• Knowledge/exposure to other coding languages (Python, C#, Java)
   

Knowledge, Skills and Abilities

• Ability to communicate effectively verbally and in writing

• Strong analytical and problem-solving skills

• Driven self-starter able to work on a small team and take initiative on new tasks with minimal supervision

• Familiarity with JIRA or equivalent product management software and agile development best practices

• 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

The base salary will be between $125,000 - $155,000 plus a discretionary bonus component.

#LI-AA1

#LI-Remote

What We Offer  

• 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:
    - 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 

• Commitment to diversity, equity, and inclusion, with employee resource groups organizing activities and providing a space for open communication 

• 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 Statement

We 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.  We strive to be a safe place to ask questions, build professional relationships, and develop careers.

SPAM
Please be wary of recruitment scams. An indication of a scam might be a request for sensitive or bank information at the time of application or emails coming from a non walkerdunlop.com email address. Please call us at 301.215.5500, if you have any concerns about information requested during or after the application process.

Fair Chance Hiring

Background checks, including any questions related to infractions, arrests, or conviction records, will not be conducted until after a conditional offer of employment has been accepted. We will consider for employment qualified applicants regardless of arrest and conviction records, in accordance with federal, state, and local laws.