Business Systems Consultant

Job Description 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. This role is for AVP level candidates. 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 Unit ("GBU"), Americas Division" and "Global Markets Unit ("GMU"), Americas Division" which performs business functions. Acting as back office to the Branch’s Global Banking Unit, Loan Operations Department ("LOP") is responsible for performing operational and administrative duties for booking and maintaining a wide range of credit-based products upon closing and throughout the life of transactions. Your Role Overview: The Business Analyst works in a dynamic team environment and supports the LOP team by providing enhanced accuracy, stability, and efficiency in processing workflows. You will be responsible for assisting with the day-to-day operations of the LOP team by initiating and/or participating in all systems related projects within the LOP Department. You will be responsible for providing maintenance and enhancement of End User Computing Applications ("EUC") and for acting as a liaison between the LOP and ITD departments. LOP is looking for someone who is detail-oriented with a strong technical background and experience with project management. Your Duties and Responsibilities: Evaluate business processes, anticipate requirements, uncover areas for improvement, and develop and implement solutions. Analyze existing software applications to understand and document functionality. Translate business needs and requirements into technical specifications. Periodically participate in day-to-day LOP operations to better understand the workflows within the department in order to perform assessments, write specifications, create test scenarios, and testing. Responsible for development, maintenance, automation, and enhancement of workflows related to LOP. Facilitate the development, design, and maintenance of Excel and Access templates as well as SQL queries, utilizing SQL programming languages. Coordinate and liaison on behalf of LOP with IT Department ("ITD"), and other departments, when necessary, for revisions, developments, and enhancements of new and existing software applications. Maintain documentation regarding various projects, processes, and operations. Achieve departmental cost savings through the prudent use of resources. Prevent potential liabilities by adhering to procedures and regulations. Support changes in system permissions for new hires, resignations, and other instances where a change is required. Assist the Head of LOP in conducting periodic reviews and other system risk activities. Participate in the Loan IQ Project when the Bank implements Loan IQ by revisiting processes and workflows, creating and testing scenarios, providing training, updating manuals, etc. Perform other duties and responsibilities as assigned by management. Your Qualifications: Bachelor’s degree in computer science or its equivalent, with 5+ years of relevant work experience in a financial institution. Strong proficiency in Microsoft Office applications including Excel, Access, SharePoint, Teams, SQL and Visual Basic for Applications (VBA). Intermediate programming skills and experience with Excel and Access. Business Analyst and Project Management (Waterfall and Agile) experience are required. Loan operations experience is preferred, but at a minimum, basic knowledge and understanding of the workflow of bilateral / syndicated / agency loans is essential. Experience with Loan IQ (version 6 or later) is highly desirable. Demonstrates critical thinking skills and a strong ability of working with others. Ability to effectively communicate and influence key stakeholders to support proposed strategies and process improvements. Resourceful and ability to develop creative solutions to problems. Experience in testing and mapping various business processes and protocols. Experience with Robotic Process Automation (RPA) is a plus. Excellent time management skills. 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 through 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. See our LinkedIn for our employee experience: 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 process, please let us know when the Human Resources staff reaches out to you for an interview. The anticipated salary range for this role is listed above. The specific salary offered to an employment applicant is based on the individual’s qualifications, experiences, the job responsibilities, an analysis of the current compensation paid for similar roles in the local geographic area, and key distinctions of the job as compared to current jobs in the Branch. The role may also be eligible for an annual discretionary bonus. Sumitomo Mitsui Trust Bank, Limited New York Branch is a branch of Sumitomo Mitsui Trust Holding Group. Learn more about the company, the values, and vision at #J-18808-Ljbffr 6AM City