Associate, Structuring and Analytics

SMBC Group; New York (NY); Hybrid; USD 119,000 - 175,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

SMBC Group is seeking a finance professional to develop and maintain cash flow models for ABS assets, using Excel, VBA, and Python. You will convert complex documentation into robust model logic, apply rating agency methods, and prepare materials for reviews.

You will support transactions from pre‑mandate to closing while driving automation to improve efficiency. You will collaborate with multiple teams to align analytics with deal execution and stay informed on market trends and ratings

Qualifications

• Master’s degree in finance, mathematics, mathematics of finance, or a related field plus 2 years of experience.
• Experience must include cash flow modeling in Excel; data processing and automation using Python and VBA; interpretation and application of rating agency methodologies; analysis and translation of deal documentation; and collateral analytics and pool selection.

Responsibilities

• Develop and maintain cash flow models for assets and liabilities across multiple ABS asset classes using Excel and VBA.
• Convert transaction documentation into robust model logic, incorporating waterfalls, triggers, eligibility criteria, and structural protections.
• Apply rating agency methodologies and required stresses and prepare analytical materials for rating agency review.
• Produce analytical deliverables including pool selection memoranda, model outputs, stress results, and execution exhibits for internal committees and external stakeholders.
• Support transactions from pre‑mandate through closing, including scenario analysis, syndicate analytics, and cross‑functional coordination.
• Enhance team efficiency through automation and process standardization using Excel, VBA, and Python.

Skills

Cash flow modeling

Python automation

VBA automation

Rating agency methodologies

Collateral analytics

Education

Master’s degree in finance or related field

Tools

Excel

Intex

Python

VBA

Job description

SMBC Group is a top-tier global financial group. Headquartered in Tokyo and with a 400-year history, SMBC Group offers a diverse range of financial services, including banking, leasing, securities, credit cards, and consumer finance. The Group has more than 130 offices and 80,000 employees worldwide in nearly 40 countries. Sumitomo Mitsui Financial Group, Inc. (SMFG) is the holding company of SMBC Group, which is one of the three largest banking groups in Japan. SMFG’s shares trade on the Tokyo, Nagoya, and New York (NYSE: SMFG) stock exchanges.

In the Americas, SMBC Group has a presence in the US, Canada, Mexico, Brazil, Chile, Colombia, and Peru. Backed by the capital strength of SMBC Group and the value of its relationships in Asia, the Group offers a range of commercial and investment banking services to its corporate, institutional, and municipal clients. It connects a diverse client base to local markets and the organization’s extensive global network. The Group’s operating companies in the Americas include Sumitomo Mitsui Banking Corp. (SMBC), SMBC Nikko Securities America, Inc., SMBC Capital Markets, Inc., SMBC MANUBANK, JRI America, Inc., SMBC Leasing and Finance, Inc., Banco Sumitomo Mitsui Brasileiro S.A., and Sumitomo Mitsui Finance and Leasing Co., Ltd.

The anticipated salary range for this role is between $119,000.00 and $175,000.00. The specific salary offered to an applicant will be based on their individual qualifications, experiences, and an analysis of the current compensation paid in their geography and the market for similar roles at the time of hire. The role may also be eligible for an annual discretionary incentive award. In addition to cash compensation, SMBC offers a competitive portfolio of benefits to its employees.

Role Description

• Develop and maintain cash flow models for assets and liabilities across multiple ABS asset classes using Excel and VBA.
• Convert transaction documentation into robust model logic, incorporating waterfalls, triggers, eligibility criteria, and structural protections.
• Apply rating agency methodologies and required stresses and prepare analytical materials for rating agency review. Perform pool selection analysis, collateral eligibility and concentration testing, and portfolio sensitivity analyses. Leverage Intex (Dealmaker, Intex Calc, CAS) to validate structures, map collateral data, and reconcile internal models with market standards.
• Produce analytical deliverables including pool selection memoranda, model outputs, stress results, and execution exhibits for internal committees and external stakeholders.
• Support transactions from pre‑mandate through closing, including scenario analysis, syndicate analytics, and cross‑functional coordination.
• Enhance team efficiency through automation and process standardization using Excel, VBA, and Python. Partner with Capital Solutions, Lending, Structuring, Legal, and Syndicate teams to align analytics with execution.
• Clearly communicate modeling results, structural considerations, and analytical insights, while staying current on market trends, comparable transactions, and rating agency developments.

Role Objectives

• Help support new products and custom solutions to enhance yield, hedge or isolate specific exposures, identify tax or other liabilities, and/or offer new and unique ways to increase leverage that meet legal and regulatory constraints.
• Gather financial statements / levers / drivers, prepare and/or review project and corporate financial models to help originators advise clients on capital and deal structure.
• Develop an understanding of the company's constraints, and financial, economic, fiduciary, legal and tax environments.
• Organize and collect data and feedback from clients (i.e., fees and structure) to contribute to improved creations and/or customized products (i.e., tax deferrals, unique leverage opportunities, etc.) for clients. Collect and prepare market intelligence for product pricing, prepare analysis on potential deal pricing, dilution impacts, timing and potential market acceptance.
• Partner with the broader origination team to streamline internal processes (i.e., information sharing for new securities, private transaction and customized offerings). Create product presentation materials (i.e., pitch books, product highlights, etc.), provide relevant background information on client relationships, and prepare data / info to support client cross‑selling meetings.

Qualifications and Skills

• Master’s degree in finance, mathematics, mathematics of finance, or a related field plus 2 years of experience.
• Experience must include the following: cash flow modeling in Excel; data processing and automation using Python and VBA; interpretation and application of rating agency methodologies; analysis and translation of deal documentation; and collateral analytics and pool selection.
• The required skills do not need to be maintained over the full term of required experience.

SMBC’s employees participate in a Hybrid workforce model that provides employees with an opportunity to work from home, as well as, from an SMBC office. SMBC requires that employees live within a reasonable commuting distance of their office location. Prospective candidates will learn more about their specific hybrid work schedule during their interview process. Hybrid work may not be permitted for certain roles, including, for example, certain FINRA‑registered roles for which in‑office attendance for the entire workweek is required.

SMBC provides reasonable accommodations during candidacy for applicants with disabilities consistent with applicable federal, state, and local law. If you need a reasonable accommodation during the application process, please let us know at [e-mail].