Senior Data Design Analyst

SMBC•Charlotte, NC

6d•Hybrid

About The Position

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.

Requirements

Comprehensive understanding of database standards such as SQL, Oracle and Hadoop, as well as different database and data warehouse structures.
Knowledge of data exchange interfaces, APIs, data mining tools, data standardization and cleaning processes, and application interfaces.
Expertise with database maintenance tools, back-up and testing policies, security and access polices, error correction and validation utilities, and performance monitoring tools.
Ability to analyze database performance and develop improvements to database code to improve scalability and performance.

Responsibilities

Design, develop, implement and maintain data resources.
Design and develop database structures for applications and systems, determine relational schema and set security policies.
Determine hardware needs for database requirements, including server hardware and storage resources.
Review reports and perform analysis of database growth and function for future resource planning.
Set back-up policies and schedules, and conduct testing of back-up and restore system.
Develop database code to improve performance and minimize storage and resource utilization.
Implement fixes for any bugs identified by users.
Conduct testing for data errors, structure and consistency.
Work with business unit leads to determine database requirements and retention polices, advise on performance goals, and develop capacity need and growth projections.
Partner with IT system administrators to install and configure server and storage hardware, perform maintenance and upgrades, update security lists, and troubleshoot performance and hardware issues.
Collaborate with application development team to determine capacity and resource requirements, build and maintain data exchange and API structures, and create automated jobs and tools.
Engage with network administrators to develop and maintain telecommunication structures, network security policy and access lists, and troubleshoot and manage any connectivity issues.