Job Description Securities Division / 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 Securities Division. The Loan Management function supports the Mortgages business for the Securities Division 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 related products owned by the firm.
RESPONSIBILIITES:
• Management and oversight of mortgage data, including data setup, database management, ETL and data validation.
• Ensure the flow of data underneath all of the analytics is accurate and correct. Working with mortgage strategies, technology, and cash operations to that aim
• Project management for the initiatives driven by the team
• Reconcile data discrepancies and perform data reconciliations between external vendors and internal databases through analytics and research
• Coordinate with Technology and internal departments to develop new GUI data interfaces, create new vendor data feeds, and add enhancements to internal databases
• Facilitate communication between internal departments for shared use of data and definition
• Manage data dictionaries and large data stores
• Manage and create data related quality control checks for internal databases and provide resolution through analytic research
• Fulfill ad hoc data requests
• Develop regulatory and business important reporting through automated reporting toolkits
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.
• Solid analytical/logical mindset and attention to detail
• Experience with SQL and RDBMS required (SQL Server or Sybase IQ preferred)
• Strong communication skills (clear, concise, and confident) with the ability to manage internal and external relationships.
• Technical skills required include creating/building Reports & Data Visualizations
• 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
• Experience in industry standard tools such as Tableau or Alteryx preferred
• Understanding of databases, data models, and Extraction Transformation Load (ETL) processes preferred.
• Mortgage banking or other financial industry experience preferred
• Commercial understanding of cash flow modelling and related concepts