Data Analytics - Associate

Lensa partners with DirectEmployers to promote this job for SMBC.

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 $97,000.00 and $156,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

Deliver key insights from corporate data sources to support planning and operations of the Sourcing, Procurement, and Third Party Risk teams, which sits within the Finance organization. Develop reports and dashboard tools to visualize data for rapid and clear understanding and communication. Work with business partners to understand data requirements and implement processes for ensuring data integrity.

Role Objectives

• Create effective data visualizations / dashboards utilizing Power BI
• Employ understanding of statistical modeling and analysis frameworks to gain key insights from collected data and support development of predictive data models
• Perform initial clean-up and classification of datasets, apply transformations to ensure compliance with data dictionaries, source missing data, and trace origin of any data quality issues.
• Maintain and run queries against corporate data sets to answer key business questions.
• Support exploratory analysis of existing data to uncover new trends and insights.
• Troubleshoot issues with reports and dashboards to enable continuous monitoring of important business performance metrics and support effective visualization of data.
• Work with Sourcing, Procurement, and Risk leadership and other business teams to develop key data questions and performance metrics.
• Establish position as a resource to colleagues for advice on all aspects of data utilization, including capture, analysis, reporting, and prediction.
• Assist in delivering advice to business partners on data capture requirements for analysis and on the creation of metrics to capture performance insights.
• Provide support to business teams on utilizing reporting tools and application of data observations.
• Demonstrate communication and presentation ability to capably illustrate complex data results to a wide audience of stakeholders.
• Support Database Administrators with the management of data dictionaries, monitoring of data resource performance, and running processes for data cleaning and error checking.
• Work with Data Governance team to ensure that all data is captured and utilized in ways that meet security standards and regulatory requirements.
  
  

Qualifications And Skills

• Experienced developer of Power BI visualizations / dashboards (experience building from the beginning, as well as maintaining and enhancing)
• Possess basic knowledge of SQL, Python, and/or other data and query programming languages a plus
• Experience establishing data feeds and integrations into Power BI from various sources through middleware solutions
• Familiarity integrating with and utilizing Coupa, specifically Coupa CRA (Risk)
• Proven track record of creating, driving, and delivering data analytics results
• Self-starter with ability to work independently to initiate and complete tasks
• Highly results-oriented with a record of successful accomplishments
• Strong interpersonal, written, and verbal communication skills
• Flexibility to respond to evolving requirements and dynamic priorities in a fast-paced project environment
• Ability to successfully work on multiple tasks simultaneously while interacting professionally with a diverse group of executives, managers, and subject matter experts
• Keen attention to detail, including ability to quality check own work and the work of others
• Fluency working with Microsoft Office applications (Excel, PowerPoint, Word)
• Recommended years of experience: 5
  
  

Additional Requirements

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 [email protected].

If you have questions about this posting, please contact [email protected]