Walker & Dunlop
Data Analyst
Walker & Dunlop, Los Angeles, California, United States,
DepartmentAffordable Housing | Equity - AdministrationWe 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 OverviewWDTech
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 HaveThe Data Analyst will be responsible for assisting with database management. Working with the Database Manager, the individual will interact with users to gather business requirements and build dimensional data models.Primary ResponsibilitiesImplement database requirements in FileMaker and integrations between multiple systems.Assist 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 ExperienceBachelor’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 AbilitiesSuperior 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 OfferThe opportunity to join one of Fortune Magazine’s Great Places to Work winners from 2015-2023Comprehensive 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 deductionsCompetitive dental and vision benefits401(k) + matchPre-tax transit and commuting benefitsA robust health and wellness program – earn cash rewards and gain access to resources that promote health, engagement, and balancePaid maternity and parental leave, as well as other family paid leave programsCompany-paid life, short and long-term disability insuranceHealth Savings Account and Healthcare and Dependent Care Flexible SpendingCommitment to diversity, equity, and inclusion, with employee resource groups organizing activities and providing a space for open communicationCareer development opportunitiesEmpowerment and encouragement to give back – volunteer hours and donation matchingEligibility may vary based on average number of hours workedEEO StatementWe 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.SPAMPlease 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 HiringBackground 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.
#J-18808-Ljbffr
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 HaveThe Data Analyst will be responsible for assisting with database management. Working with the Database Manager, the individual will interact with users to gather business requirements and build dimensional data models.Primary ResponsibilitiesImplement database requirements in FileMaker and integrations between multiple systems.Assist 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 ExperienceBachelor’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 AbilitiesSuperior 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 OfferThe opportunity to join one of Fortune Magazine’s Great Places to Work winners from 2015-2023Comprehensive 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 deductionsCompetitive dental and vision benefits401(k) + matchPre-tax transit and commuting benefitsA robust health and wellness program – earn cash rewards and gain access to resources that promote health, engagement, and balancePaid maternity and parental leave, as well as other family paid leave programsCompany-paid life, short and long-term disability insuranceHealth Savings Account and Healthcare and Dependent Care Flexible SpendingCommitment to diversity, equity, and inclusion, with employee resource groups organizing activities and providing a space for open communicationCareer development opportunitiesEmpowerment and encouragement to give back – volunteer hours and donation matchingEligibility may vary based on average number of hours workedEEO StatementWe 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.SPAMPlease 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 HiringBackground 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.
#J-18808-Ljbffr