Truist

Business Data Analyst II – CCAR Y14 Reporting, Data Solutions

Truist

full-time

Posted on:

Location Type: Office

Location: Winston-Salem • North Carolina • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

OracleSQLVBA

About the role

  • Support 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.
  • Play a pivotal role in ensuring the accuracy, consistency, traceability, and regulatory alignment of CCAR Y14 data used in internal and external reporting.
  • Design and enhance 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.
  • Identify and resolve design limitations, data quality issues, and reporting logic gaps.
  • 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.
Benefits
  • medical
  • dental
  • vision
  • life insurance
  • disability
  • accidental death and dismemberment
  • tax-preferred savings accounts
  • 401k plan
  • 10 days of vacation
  • 10 sick days
  • paid holidays
  • defined benefit pension plan
  • restricted stock units
  • deferred compensation plan
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SASSQLNetezzaOracleDB2ExcelVBAreport developmentdata qualitytechnical reporting requirements
Soft Skills
verbal communicationwritten communicationpresentation skillsproblem-solvingleadershipintegrityintellectual claritypassion for excellence
Certifications
Bachelor’s degree in AccountingBachelor’s degree in FinanceBachelor’s degree in Business AdministrationBachelor’s degree in Economics