Credit Portfolios & Systems Analyst

Job Type: Location Type: Hybrid

 

This role is located in New York City and will require a hybrid work schedule of at least 2 days in office per week.

This role is for Officer level candidates.

About the Bank:

Sumitomo Mitsui Trust Bank, Limited was established through the merger of The Sumitomo Trust and Banking Co., Ltd with Chuo Mitsui Trust and Banking, Ltd. on April 1, 2012. We are one of the largest asset managers in Asia and number one among Japanese financial institutions by AUM, with approximately $850 Billion USD in AUM. The Bank provides an assortment of financial solutions and manages a broad spectrum of financial products across its global branches.

Department Overview

The Americas Division (“AD”) was established in the Sumitomo Mitsui Trust Bank, Limited, New York Branch) (“SMTBNY”) to perform corporate functions and supervise U.S. entities. Established under the AD are the “Global Banking Uni (“GBU”), Americas Division” and “Global Markets Unit (“GMU”), Americas Division” which performs business functions. The Credit Investment Management Department (“CIM”) is responsible for the booking and administering of (i) leveraged loan assets and (ii) structured product assets including CLOs (note investments and warehousing facilities) and MML Senior Financing through maturity or refinancing in accordance with the Branch’s lending policy.

Your Role Overview

This role supports credit and structured investment & operation workflows, automates portfolio data analytics via VBA and SQL, and serves as the primary business liaison for system enhancements and UAT.

Your Duties and Responsibilities

1. Portfolio & Operation Support

• Develop a working understanding of loan and CLO structures, cash flows, covenants, ratings, and risk metrics to effectively support front-office and operation needs.
• Actively support day-to-day leveraged loan and/or structured credit investment and operational activities, including investment workflows, portfolio monitoring, reporting processes, and closing procedures.
• Participate in ongoing portfolio and operational reviews to identify data, process, and system improvement opportunities.

1. EUC Ownership & Maintenance

• Own the development, maintenance, documentation, and enhancement of End-User Computing (EUC) applications.
• Design, maintain, and automate Excel-based tools, templates, and models using Excel, VBA, Power Query, and SQL, ensuring appropriate controls, versioning, and documentation.
• Translate evolving investment and operational requirements into scalable EUCs and identify opportunities to migrate mature EUCs into formal systems.

1. Portfolio Management Systems Support
   • Serve as the primary business liaison between Internal Investment & Operation Teams and ITD for system initiatives related to the department’s portfolio management systems.
   • Gather, analyze, and fully understand business requirements, translating them into clear, complete, and actionable functional specifications for IT development.
   • Support user acceptance testing (UAT), validation, and implementation of system enhancements to ensure alignment with business workflows.
2. Data Analysis and Reporting Support
   • Perform ad hoc and recurring portfolio data extraction, validation, and analysis to support investment, risk, and management reporting.
   • Assist with troubleshooting data issues and reconciling discrepancies across systems, EUCs, and reports.
3. User Support and Access Controls
   • Assist end users in understanding the design, functionality, and appropriate use of business applications, EUCs, and reporting tools. Establish and maintain user system access controls, monitoring, and documentation in coordination with IT and compliance requirements

Your Qualifications:

1. Bachelor’s degree in Finance, Computer Science, Data Analytics, or a related discipline.
2. 3+ years of relevant experience in a financial institution, preferably supporting credit, loan operations, portfolio management, or risk functions.
3. Strong proficiency in Excel (advanced), VBA, and SQL; experience with data extraction and manipulation from enterprise systems.
4. Demonstrated ability to understand and support complex business workflows and translate them into technical or system requirements.
5. Strong written and verbal communication skills, with the ability to interact effectively with investment professionals, operations staff, and IT developers.

Preferred Qualifications

1. Exposure to leveraged loans, structured products, or fixed income portfolios.
2. Experience working with portfolio management, credit monitoring, or risk systems.
3. Interest and aptitude for developing both business and technical expertise in credit markets.

Why you should join SuMi Trust:

SuMi Trust embraces flexible ways of working when the business and role permits. We provide employees with a hybrid working model, allowing for in-office work and work from home. Our diverse and inclusive environment along with our global presence enables us to collaborate and communicate to meet our business needs. We believe that efficient teams need truth, loyalty, and a strong sense of purpose to balance risk and their targets. We make sustainable business decisions to improve our society and the world. We believe that each person brings a unique value that drives the business though their creativity and passion.

• The Employee Benefits package includes: Paid Time Off, medical, HSA, vision, dental, FSA, 401(k), profit sharing, legal plan, cancer indemnity plan, disability insurance, life insurance, employee assistance program, commuter benefits, business travel accident, paid volunteer day, paid memberships, paid seminars, and tuition assistance.
• We offer many socialization opportunities for wellness, financial wellbeing, runs/walks, team building, happy hours, and activities to support the Sustainable Developmental Goals.

Check out our LinkedIn for our employee experience: https://www.linkedin.com/company/smtbny

We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law. SuMi Trust provides reasonable accommodations for employees and applicants with disabilities consistent with applicable law. If you need a reasonable accommodation during the application