Beginning on Friday, May 15 at 6:00 p.m. ET/ 11:00 p.m. BST/ May 16 at 3:30 a.m. IST/ 6:00 a.m. HKT and extending through
May 31, the opportunities page will be unavailable to search and apply for jobs as we work to improve your experience.

Apply Now    

CIB – SPG Residential Mortgage Loan Advisory Transaction Management and 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.

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
- 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.
Req #: 160013109
Location: Lewisville, TX US
Job Category: Investment Banking
Employment Type: Full Time
Potential Referral Amount: 0 US Dollar (USD)

Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Join Now

Privacy Statement

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please contact us by calling (US and Canada Only) 1-866-777-4690. Please indicate the specifics of the assistance needed.

Keep in touch

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.