Structured Products Group Database - Analyst

  • JPMorgan Chase Bank, N.A.
  • 60 Lispenard St, New York, NY 10013, USA
  • Nov 09, 2020
[Information Technology]

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.RESPONSIBILITIESMaintain the Transaction Database.Databases are Excel and Access basedAutomate 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 Preparing or "cracking" raw mortgage-related data into normalized data fields to produce usable information that can be analyzed economically and qualitativelyQualifications Bachelor's degree or advanced education with quantitative, computer science or finance background2-4 years relevant professional experience with mortgage collateral, pricing and/or structuringMust have experience with Excel, Access, SQL and VBA. Experience running financial models and manipulating data. Ability to create PowerPoint presentations. Knowledge of residential mortgage loans, mortgage credit and mortgage servicingunderstanding of industry terms and fields that constitute relevant mortgage dataExcellent communication skills and strict attention to detail, must have an eye to spot data and patterns that do not conform to what would be expected for a given data set or reportAbility to work under competitive pressure, multi-task, prioritize and manage timelines, relationships and deliverablesJPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.Equal Opportunity Employer/Disability/Veterans
Associated topics: chief program officer, cpo, manage, manager, management, monitor, product manager, project manager, relationship manager, task