.jpg)
.jpeg)
.jpeg)
.jpeg)
Walker & Dunlop
is hiring
Data Analyst
About Our Company
Walker & Dunlop is one of the largest commercial real estate finance and advisory services firms in the United States. Our ideas and capital create communities where people live, work, shop, and play. The diversity of our people, breadth of our brand, and technological capabilities make us one of the most insightful and client-focused firms in the commercial real estate industry.
Job Description & Responsibilities
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.
Requirements
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.
What we offer
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
