CCAR Data Analyst, Associate

SMBC; Charlotte (NC); Hybrid; USD 95,000 - 135,000; Full time

Benefits offered by this job

Hybrid work model

Disability accommodations

Job summary

SMBC is seeking a Data Analyst to join the Regulatory Reporting & CCAR Technology Team. The role focuses on analyzing requirements, designing data solutions, and supporting automation for regulatory reporting initiatives.

You will collaborate with stakeholders, map data, and ensure data quality and governance across CCAR and related reports. This is a hybrid role based in the Charlotte, NC area with strong emphasis on data-driven decision-making.

Qualifications

• Bachelor’s degree in a quantitative field or related discipline.
• Experience with regulatory reporting and CCAR-like processes is preferred.
• Strong analytical and communication skills with the ability to convey complex findings to leadership.

Responsibilities

• Collaborate with business stakeholders to gather, analyze, and validate data requirements for CCAR and Regulatory Reporting initiatives.
• Partner with Data Management to source and onboard data for regulatory and stress testing reporting.
• Perform data mapping, lineage analysis, gap assessments, and current vs future state analyses.
• Create and maintain data mapping artifacts, BRDs, and data lineage documentation.
• Translate business requirements into functional specifications with development teams.
• Identify opportunities for process improvements, automation, and efficiency.
• Support QA, UAT, and data quality issue resolution.
• Assist in data governance initiatives and issue resolution.

Skills

SQL

Python

Excel

Tableau

Visio

Jira

Data governance

Data quality

Education

Bachelor’s degree in Accounting, Finance, Business Analytics, Computer Science, Information Systems, or related field

Tools

Databricks

Cloud data platforms

Job description

Select how often (in days) to receive an alert:

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.

Role Description

SMBC is driving a major Digital Transformation initiative across its Americas Division, with a strong focus on modernizing technology platforms, enhancing data-driven decision-making, and supporting business growth. As part of this transformation, we are seeking a talented Data Analyst to join the Regulatory Reporting & CCAR Technology Team.

The Data Analyst will play a critical role in analyzing business and data requirements, designing data solutions, and supporting the implementation of technology initiatives that automate and enhance Regulatory Reporting and CCAR reporting processes.

Key Responsibilties

• Collaborate with business stakeholders to gather, analyze, and validate data requirements for CCAR and Regulatory Reporting initiatives.
• Partner closely with Data Management teams to identify, source, and onboard data required for regulatory and stress testing reporting.
• Perform data mapping, data lineage analysis, gap assessments, and current-state versus future-state analysis.
• Create and maintain functional specification documents, data mapping artifacts, business requirements, and data lineage documentation.
• Work with development teams to translate business requirements into functional and technical specifications and support solution implementation.
• Analyze existing business processes and identify opportunities for process improvements, automation, and operational efficiencies.
• Conduct detailed data analysis and support Unit Testing, Quality Assurance (QA), and User Acceptance Testing (UAT) activities.
• Participate in the resolution of data quality issues and support data governance initiatives.

Qualifications and Skills

• Bachelor’s degree in Accounting, Finance, Business Analytics, Computer Science, Information Systems, or a related field.
• Strong knowledge of Banking and Financial Services, including Regulatory Reporting and CCAR reporting (FR Y-14A, FR Y-14M, and FR Y-14Q).
• Solid understanding of banking products, including Loans, Securities, Deposits, and Derivatives.
• Excellent analytical, problem-solving, and communication skills, with the ability to clearly articulate findings and recommendations to senior management and business stakeholders.
• Experience working with both Agile and Waterfall project delivery methodologies.
• Proficiency in data analysis and reporting tools, including SQL, Python, Microsoft Excel, Tableau, Visio, and Jira.
• Experience with Databricks and modern cloud-based data platforms is preferred.
• Strong understanding of data governance, data quality management, data validation, data reconciliation, and data lineage concepts.
• Familiarity with regulatory reporting controls, audit requirements, and enterprise data management practices.
• Ability to manage multiple priorities in a fast-paced, regulatory-driven environment.

Preferred Qualifications

• 7+ years of experience supporting Regulatory Reporting, CCAR/Stress Testing, Treasury, Finance, or Risk Management initiatives within the banking industry.
• Hands-on experience with large-scale data integration, data warehousing, and regulatory reporting platforms.
• Experience performing data sourcing, data mapping, reconciliations, controls validation, and root cause analysis for reporting and compliance requirements.
• Understanding of end-to-end regulatory reporting processes and associated data governance frameworks.

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].