CIB – SPG Database Analyst/Associate – Texas

Job description

JPMorgan is the investment banking business of JPMorgan Chase, a leading global financial services firm with assets of $713 billion. With 100,000 employees in over 50 countries, we draw on a full range of capabilities to provide integrated financial solutions for institutions and individuals worldwide and our broad range of financial services activities offers an exceptional range of career opportunities. If you are interested in working in an environment where leadership, excellence, initiative and diversity are amongst our core values, then we welcome you to explore the opportunities at JPMorgan.

The SPG Residential Mortgage Loan Advisory Team is responsible for advising clients on the sale of re-performing and non-performing residential mortgage whole loans as well as portfolio optimization.

Analyst/Associate role – support the daily functions of the deal team in the management of transactions and analytics, database creation and manipulation.

RESPONSIBILITIES
Design, implement, and maintain the Transaction Database.
Databases are Excel and Access based and data manipulation is done through SQL scripting and VBA.
Automate manual processes using technology.
Design solutions for passing, collecting, and aggregating data to and from various sources (both electronically and through traditional methods).
Manage the Deal Team's Transaction Database by updating new pools, transaction schedule changes, due diligence results, side letter status, bid information, client information, client coverage, servicer information, servicing transfer results and repurchase claims.
Assist in the pool selection process.
Maintain documentation of various transaction required approvals.
Assist in the loan sale process by assisting with the creation of marketing materials, managing the valuation process and tracking bids and trade color.
Analyze and compare marketing pools to help determine pricing.
Assist with settling the transaction.
Assist with the development and implementation of an asset management and portfolio oversight strategy for different portfolios

Desired profile

- Must have experience with Excel, Access, SQL and VBA.
- Must have experience designing, implementing, and managing databases.
- Experience running financial models and manipulating data.
- Ability to create PowerPoint presentations.
- Knowledge of residential mortgage loans, mortgage credit and mortgage servicing a plus, but not required.