LinkedIn and 3rd parties use essential and non-essential cookies to provide, secure, analyze and improve our Services, and to show you relevant ads (including professional and job ads) on and off LinkedIn. Learn more in our Cookie Policy.
Select Accept to consent or Reject to decline non-essential cookies for this use. You can update your choices at any time in your settings.
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.
WD Affordable Equity is a leading tax credit firm focused on tax credit syndication for the development and financing of affordable multifamily rental housing. This position would support the WD Affordable Equity Team.
The Impact You Will Have
The Data Analyst will be responsible for assisting with database management. Working with the Database Manger, the individual will interact with users to gather business requirements and build dimensional data models.
Primary Responsibilities
Implement database requirements in FileMaker and integrations between multiple systems.
Assists with database design and maintenance based on the organization’s needs and implements appropriate solutions to meet needs and comply with departmental standards.
Develop packages for extracting, cleaning, transforming, and loading data into the database from various sources (SQL, Excel, Access, flat files)
Develop packages to push data from the database to front end applications.
Create MS SQL Server views, indexes, stored procedures, functions, and triggers.
Conduct performance tuning and query optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Documents processes and procedures relating to the management of the data warehouse.
Assist with development and scheduling of reports.
This is a hybrid role with 2-3 days in office.
Education And Experience
Bachelor’s degree in information technology, computer science, or related field or equivalent technical or professional experience required.
Experience with vlookups and pivot tables in Excel.
Prior experience with Filemaker is a plus.
Experience with SQL Server Management Studio (SSMS) and SQL Server Analysis Services (SSAS) is a plus.
Knowledge, Skills And Abilities
Superior written and oral communication skills.
Strong analytical skills and effective interpersonal skills.
Ability to manage multiple tasks with varying priorities.
Detail oriented and ability to take ownership of a task or project to successful outcome.
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.
This position has an estimated base salary of $70,000-75,000 plus discretionary bonus.
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.
Seniority level
Entry level
Employment type
Full-time
Job function
Information Technology
Industries
Financial Services
Referrals increase your chances of interviewing at Walker & Dunlop by 2x