GBM - Loan Management Data Analytics – Analyst - Bengaluru

ABOUT GOLDMAN SACHS

The Goldman Sachs Group is a bank holding company and a leading global investment banking, securities and investment management firm. Goldman Sachs provides a wide range of services worldwide to a substantial and diversified client base that includes corporations, financial institutions, governments and high net worth individuals. Founded in 1869, the firm is headquartered in New York and maintains offices in London, Frankfurt, Tokyo, Hong Kong and other major financial centers around the world.

BUSINESS UNIT OVERVIEW

Goldman Sachs Services Private Limited in Bengaluru is seeking an analyst to support the Loan Management function within the Global Banking & Markets (GBM) Public Division. The Loan Management function supports the Mortgages and Structured Products business for GBM Public that transacts in loans, derivatives, and securities across various mortgage related products. The Data Analytics team in Loan Management is responsible for standardizing and controlling all data flows with respect to mortgage trading and lending products owned by the firm.

RESPONSIBILIITES:

• Management and oversight of trading and lending data for Mortgages and Structured Products, including data setup, database management, ETL, data validation and quality control
• Drive process automation by identifying redundancies, reducing manual interventions and improving process efficiency for the trading and lending platforms
• Develop strategic reporting for trading desks and asset management across relevant products and/or asset classes
• Ensure the flow, accuracy, and completeness of data by partnering with Asset Management, Engineering and Strats to understand business requirements and define strategic data models and systems
• Liaise with Controllers, Compliance, Risk and other divisions for regulatory and business important reporting through automated toolkits
• Translate business requirements into tangible solution specifications and high quality, on time deliverables
• Manage project timelines and completions for committed analytics, automation and reporting
• Manage data dictionaries and large data stores
• Reconcile data discrepancies and perform data reconciliations between external vendors and internal databases through analytics and research
• Fulfill ad hoc data requests

SKILLS / EXPERIENCE:

• 1-3 years of experience in data analysis, data modeling, RDBMS databases and ETL
• Strong academic background - 4 year related engineering background with a minimum 3.0 GPA equivalent.
• Proficient in SQL and / or interacting with structured data
• Understanding of in industry standard data transformation and reporting tools such as Tableau, Alteryx, or ability to create/build reports and data visualizations
• Solid analytical/logical mindset and attention to detail
• Strong communication skills (clear, concise, and confident) with the ability to manage internal and external relationships.
• Team-oriented with a strong sense of ownership and accountability
• Must know or be able to learn Excel to an advanced level
• Ability to prioritize workload, and work with Technology to help drive data smart solutions

GOOD TO HAVE:

• Experience in Python programming preferred
• Understanding of databases, data models, and Extraction Transformation Load (ETL) processes preferred.
• Mortgage banking or other financial industry experience
• Understanding of structured finance, collateralized lending, fixed income, or related finance modeling concepts