Back to all jobs
 Data Analyst at Walker & Dunlop

Data Analyst

@

Walker & Dunlop

Key information

Apply now
Posted on: 
September 30, 2024
Status: 
Expired
Views:
327

Summary of the Data Analyst job at Walker & Dunlop

Walker & Dunlop is hiring a Data Analyst with 0 - 3 years of experience. Based in United States - Irvine, CA and with Hybrid ways of working. The expected salary range for this role is $70,000 - $75,000
About Walker & Dunlop

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.

Data Analyst job description

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.
Data Analyst job 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 at Walker & Dunlop

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

Please mention “I found this job at DataAnalyst.com!” in your application, it will help us offer you more opportunities

insertpageurl
Thank you for reporting
Oops! Something went wrong while submitting the form.

What about the salary?

Average data analyst salary in the Financial industry is $109,304.
Salary Guide

Apply now

Please mention: “I found this job at DataAnalyst.com” in your application, it will help us offer you more opportunities.

Apply now

Looking for a career change?

Apply to Business Analyst jobs, at our network site.
BusinessAnalyst
.com
Walker & Dunlop

Walker & Dunlop

is hiring

Data Analyst

Website:
Posted on: 
October 11, 2024

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

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.

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

Apply now
Back to all jobs

Featured data analyst jobs

All jobs