Business Data Analyst II – CCAR Y14 Reporting & Data Solutions

Truist Bank • Winston-Salem, NC

1d

About The Position

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.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees