|
Database Analyst – Real Estate
BlackRock Real Estate: Manages over $23 billion in private real estate debt and equity in the U.S., Europe, Australia and Asia. Real estate investments span a wide range of strategies, including core, value-add and opportunistic equity and high-yield debt for a premier list of institutional and private investors.
Summary: The Database Analyst is responsible for maintaining the Research and Risk Analytics data warehouse used to support the firm in its investment strategies, acquisitions, portfolio, property management, and property sales programs. A key function of this role is creating analytical reports from data stored in the data warehouse. Additional responsibilities include data loading and normalization, and assisting in building Excel models and macros used to create the various Research and Risk Analytics tools.
Qualifications: Must have a minimum of one year of relevant experience. Must have a BS/BA degree in Computer Science, Mathematics, or related field. Skilled at creative problem solving and deductive reasoning. Must possess exceptional computer and math skills, including SQL database, spreadsheet, and report writing, also a knowledge of Visual Basic for Applications macro language is a plus. Must possess excellent verbal and written communication as well as analytical skills.
Essential Functions: Create analytical reports Work with team to manage and maintain Data Warehouse Responsible for data conversion, update, organization, maintenance, and information gathering Develop Excel macros, functions and programs to standardize core projects and assist team. Generate ad hoc reports from the data warehouse as needed.
Ideal Candidate: Excellent creative, analytical, math and computer skills. Programming skills (T-SQL, VBA/Visual Basic, Data Warehousing, ETL, report writing, business intelligence/data mining tools). Outstanding academic achievement and work experience. Possesses excellent communication skills. Works well as part of a team. High attention to detail.
|
