Realty Management Division, Data Management and Reporting, Associate- Dallas

Location(s) US-TX-Irving
Job ID
2017-24619
Schedule Type
Full Time
Level
Analyst
Function(s)
Real Estate
Region
Americas
Division
Realty Management Division
Business Unit
Resi Mortgage Asset Mgmt
Employment Type
Employee

MORE ABOUT THIS JOB

Realty Management

 

The Realty Management Division (RMD) plays an integral role in supporting the firm’s real estate investing strategy by providing investment and asset management services globally in the real estate market, partnering with other divisions in the firm to deliver results wherever Goldman Sachs has an interest. RMD serves as an extension to revenue divisions by providing services such as sourcing, acquisition, underwriting and due diligence of distressed and performing real estate and loan assets, asset management, portfolio management and disposition across various property types including office, multi-family, retail and hotel. Our division also manages residential loan portfolios and warehouse repo lines across auto, student, and consumer asset classes while providing structure, pricing and collateral analysis support. We look for individuals who are passionate about real estate and finance, have strong problem solving and analytical skills, and are great communicators who are eager to make an impact.

 

 

Role Overview

 

Goldman Sachs & Co, located in Irving TX, is seeking an Associate/Vice President to support the Data Management & Reporting (DMR) group. DMR engages in (1) implementing consistent and secured data transfer methods working with vendors and internal data providers; (2) serve as a liaison between business and technology platforms delivering standardized data models; (3) oversight of data quality controls through data validation, business process and consumer oversight checks; (4) applying governance designing, developing and maintaining the report inventory and key performance indicator (KPI) library, ensuring visibility and transparency to strategic objectives; and (5) collaborating with Technology to bring efficiencies in business process through the appropriate adoption and integration of technological solutions / tools and corporate-wide solutions.

A successful candidate will be responsible for the evolution and ongoing development of delivering relevant, comprehensive, and accurate information that meets the needs of the Realty Management Division. This position will report to the Data Management and Reporting Team coordinating data related projects.

RESPONSIBILITIES AND QUALIFICATIONS

Job Responsibilities

  • Collaborate with Loan Trading, Due Diligence and Asset Management groups to develop and cultivate a reporting portfolio that accurately evaluates the due diligence results and reflect the operational performance of the portfolio.
  • Assist in creation of detailed Operational Reporting solutions and Executive Dashboards to portray, for example, profit/loss, rate of return, cash flow, and performance of residential mortgage loans across multiple portfolios.
  • Design, develop and maintain the Key Performance Indicator (KPI) library, ensuring visibility and transparency to strategic objectives of the Assets Management group.
  • Assist to evaluate and understand the evolving reporting needs of the underlying business functions being supported.
  • Assist in ensuring data consumption needs are standardized across various sources, and that a complete and accurate Key Business Element (KBE) data lineage exists in accordance with data management best practices and standards.
  • Safeguard the integrity and accuracy of the BI model though strong governance routines, data exception and drift analysis.
  • Creation and maintenance of the Reporting Portfolio. Ensure reporting solutions are delivered timely and accurately, in accordance with established SLAs.
  • Collaborate with Technology to bring efficiencies in business process through the appropriate adoption and integration of technological solution / tools and corporate-wide solutions.

Qualifications

  • Strong academic background - 4 year related business, informational systems, math, or accounting degree with a minimum 3.0 GPA
  • Experience in a data, analytics and / or reporting role.
  • Mortgage banking, Real Estate or other financial industry experience preferred.
  • Strong communication skills (clear, concise, and confident) with the ability to manage internal and external relationships.
  • Proficient in SQL and relational databases.
  • Advanced knowledge of SQL concepts and ETL tools preferred (e.g. creation of stored procedures and SSIS).
  • Experience developing in Tableau, Cognos or SSRS. 
  • Proficient in Microsoft Excel.
  • Experience working with large datasets (big data) is a plus.
  • Experience developing analysis and reporting on loan portfolios.
  • Solid analytical / logical mindset and attention to detail.
  • Able to work under tight time constraints and extended hours as required.
  • Maintains composure and attentiveness under pressure, tight deadlines and increased workflow.
  • Familiar with Project Management concepts and / or has excellent time management and organizational skills.
  • Strong and concise communication techniques, with the ability to translate between Technology and Business, while managing internal and external relationships.
  • Ability to see work through to completion, manage expectations and provide timely updates.
  • Team player

ABOUT GOLDMAN SACHS

The Goldman Sachs Group, Inc. is a leading global investment banking, securities and investment management firm that provides a wide range of financial services to a substantial and diversified client base that includes corporations, financial institutions, governments and individuals. Founded in 1869, the firm is headquartered in New York and maintains offices in all major financial centers around the world.

© The Goldman Sachs Group, Inc., 2018. All rights reserved Goldman Sachs is an equal employment/affirmative action employer Female/Minority/Disability/Vet.