Business Data Analyst II – CCAR Y14 Reporting & Data Solutions

Truist Bank • Winston-Salem, NC

2d

About The Position

For this opportunity, Truist will not sponsor an applicant for work visa status or employment authorization, nor will we offer any immigration-related support for this position (including, but not limited to H-1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN-1 or TN-2, E-3, O-1, or future sponsorship for U.S. lawful permanent residence status.)

This role supports the development, enhancement, and maintenance of an automated SAS/SQL-based CCAR (Comprehensive Capital Analysis and Review) Y14 M/Q reporting solution within the Finance organization. The position plays a pivotal role in ensuring the accuracy, consistency, traceability, and regulatory alignment of CCAR Y14 data used in internal and external reporting.

The role is responsible for designing and enhancing reporting and data solutions that balance maintainability, usability, scalability, and availability within the enterprise data environment. Solutions must be clearly traceable to documented business and regulatory requirements and aligned with internal controls and governance standards.

This analytical and technical support role requires a proactive approach to identifying and resolving design limitations, data quality issues, and reporting logic gaps, as well as reactive support to address issues identified by business partners, reporting analysts, audit, or regulatory reviews.

Areas of Focus:
• CCAR Y14 M/Q Support: Review business and regulatory requirements; design, develop, test, and enhance SAS/SQL code supporting the CCAR Y14 reporting application.
• Data Analysis: Perform in-depth data analysis to identify trends, anomalies, and data quality issues within CCAR Y14 submissions.
• Documentation: Create and maintain comprehensive documentation for reporting logic, data mappings, assumptions, and process changes.
• Process Improvement: Identify and implement opportunities to enhance automation, improve efficiency, and strengthen controls through process and software improvements.
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

Requirements

• Bachelor’s degree in Accounting, Finance, Business Administration, Economics, or equivalent education and related training
• 3 years of work experience with enterprise databases (Netezza, Oracle, DB2) and report development
• 3 years of experience in SAS and/or SQL programming
• Develop proficiency in reading, interpreting and writing detailed SAS/SQL statements
• Proven experience writing detailed technical reporting requirements and communicating with developers and business users
• Excel / VBA skills
• Excellent verbal, written and presentation skills, with the ability to define problems and persuasively present conclusions
• Intelligent, strong and decisive leadership within an organization as a result of high integrity, intellectual clarity and a passion for excellence

Nice To Haves

• Master’s degree in Finance, Accounting, Business Administration, or a related field
• Experience supporting CCAR Y14 regulatory reporting or other large-scale financial regulatory reporting frameworks
• 5 or more years of relevant experience in financial data analysis, reporting, or data/application support within a regulated environment
• Experience working with automated reporting or data processing applications and supporting ongoing enhancements
• Familiarity with data governance, controls, audit support, or regulatory examination processes

Responsibilities

• Implementation of processes, including report creation for schedules, edit checks and reasonability checks to continually improve the quality of the schedule data.
• Adhere to consistency requirements across the CCAR Schedule processes and actively participate in the Y-14Q/M Schedule review process.
• Support relationship management with Lines of Business, and the development of broad based knowledge of supported LOB’s financial statements and metrics (e.g., net interest income, yields, securities, FSIs, etc.)
• Coordinate with lines of business SMEs and risk management to solidify their understanding of the report requirements for CCAR and the need for information about system or other process changes as well as the data integrity requirements for the data
• Lead data analysis and research activities necessary to support the day-to-day operation of multiple business units.
• Perform code changes that align with the business requirements, coding standards and support the end-to-end life cycle of the report production processes.
• Validate feasibility of the business requirements by profiling existing data sources, or partner with Data Office to acquire new data sources to meet business needs.
• Build testing to ensure data integrity and accuracy of the data in all internal and external reporting processes.
• Prepare additional data for audit purposes and/or other regulatory reports.
• Escalate data quality issues to management and LOBs, and actively track root cause analysis and issue remediation.
• Develop, present and review Code Changes Requests (CCR) and impact analyses in providing effective challenge and review

Benefits

• All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division of Truist offering the position.
• Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax-preferred savings accounts, and a 401k plan to teammates.
• Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays.
• For more details on Truist’s generous benefit plans, please visit our Benefits site.
• Depending on the position and division, this job may also be eligible for Truist’s defined benefit pension plan, restricted stock units, and/or a deferred compensation plan.
• As you advance through the hiring process, you will also learn more about the specific benefits available for any non-temporary position for which you apply, based on full-time or part-time status, position, and division of work.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level