Realty Management Division, Residential Mortgage Asset Management, Reporting & Data Analytics, Analyst - Irving

Job description

Job Summary & Responsibilities

The Goldman Sachs Group, Inc. is a leading global financial services firm providing investment banking, securities and investment management services to a substantial and diversified client base that includes corporations, financial institutions, governments and high-net-worth individuals.  The firm is headquartered in New York and maintains offices in London, Frankfurt, Tokyo, Bangalore, Hong Kong and other major financial centers around the world.

Divisional Overview

Residential Mortgages Asset Management (RMAM) is a business unit within the Realty Management Division (RMD) primarily supporting the Securities division’s Mortgage Loan Trading and Investment Banking’s Structured Finance desks.  RMAM is responsible for directing and facilitating due diligence (at both the deal and asset levels) for the acquisitions and sales/securitizations of residential loan portfolios, and ensuring completion of transaction closing requirements.  Post trade RMAM is responsible for the Asset management and facilitation of the portfolio’s strategies and portfolio performance reporting.

Role Overview

Goldman Sachs & Co, located in Irving TX, is seeking an Analyst/Associate to support the Residential Mortgages Asset Management and Securities division’s Mortgage Loan Trading groups.  A successful candidate will be responsible for the evolution and ongoing development of the reporting and informational needs of the Residential Mortgage Asset Management’s group, specifically as it pertains to the distressed loan investments and trading profit/loss portfolio.  

This position will report to Residential Mortgage Asset Management’s Data Analytics & Reporting Team.

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.
• Assist in the ongoing refinement of the underlying Business Intelligence (BI) data model.
• 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.

Basic Qualifications

• Strong academic background - 4 year related business, informational systems, math, finance, or accounting degree with a minimum 3.0 GPA
• 1-3 years’ 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.
• 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.

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