Department: Affordable Housing | Equity - Administration 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.
- Attendance is generally 8:30 am - 5:30 pm Monday through Friday with the ability to work up to 2 of those days remotely.
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. #LI-AA1 #LI-Hybrid
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.###.####, 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.