Winston Salem, NC, 27199, USA
13 days ago
Business Data Analyst II
**The position is described below. If you want to apply, click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application, you'll be invited to create a profile, which will let you see your application status and any communications. If you already have a profile with us, you can log in to check status.** Need Help? (https://www.brainshark.com/bbandt/careers-site-faq) _If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (careers@truist.com?subject=Accommodation%20request)_ _(accommodation requests only; other inquiries won't receive a response)._ **Regular or Temporary:** Regular **Language Fluency:** English (Required) **Work Shift:** 1st shift (United States of America) **Please review the following job description:** This role will be responsible for CCAR Y14 Data Submission in our Finance Team. This role is a pivotal part in ensuring the accuracy and timeliness of our CCAR (Comprehensive Capital Analysis and Review) Y14 M/Q reporting processes. This role will design reporting solutions to maximize the tradeoff of maintainability, usability, scalability, and availability of information stored in the data environment. Ensure that solutions can be easily traced to business requirements. This analysis and support role should be able to act proactively to resolve design issues, as well as react to resolve reporting data issues identified by business or reporting analysts. Areas of focus: • CCAR Y14 M/Q Data Submissions: Review business requirements, build and test development of SAS/SQL code, push code to production. • Data Analysis: Conduct thorough data analysis to identify trends, anomalies, and potential issues in the financial data. • Documentation: Create and maintain comprehensive documentation of the changes to the CCAR Y14 M/Q reporting process • Process Improvement: Identify and implement opportunities to automate, increase efficiencies and improve controls with software and process enhancements. 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. 1. Implementation of processes, including report creation for schedules, edit checks and reasonability checks to continually improve the quality of the schedule data. 2. Adhere to consistency requirements across the CCAR Schedule processes and actively participate in the Y-14Q/M Schedule review process. 3. 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.) 4. 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 5. Lead data analysis and research activities necessary to support the day-to-day operation of multiple business units. 6. Perform code changes that align with the business requirements, coding standards and support the end-to-end life cycle of the report production processes. 7. 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. 8. Build testing to ensure data integrity and accuracy of the data in all internal and external reporting processes. 9. Prepare additional data for audit purposes and/or other regulatory reports. 10. Escalate data quality issues to management and LOBs, and actively track root cause analysis and issue remediation. 11. Develop, present and review Code Changes Requests (CCR) and impact analyses in providing effective challenge and review The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 1. Bachelor’s degree in Accounting, Finance, Business Administration, Economics, or equivalent education and related training 2. 3 years of work experience with enterprise databases (Netezza, Oracle, DB2) and report development 3. 3 years of experience in SAS and/or SQL programming 4. Develop proficiency in reading, interpreting and writing detailed SAS/SQL statements 5. Proven experience writing detailed technical reporting requirements and communicating with developers and business users 6. Excel / VBA skills 7. Excellent verbal, written and presentation skills, with the ability to define problems and persuasively present conclusions 8. Intelligent, strong and decisive leadership within an organization as a result of high integrity, intellectual clarity and a passion for excellence **Preferred Qualifications:** 1. Master’s degree in Finance, Accounting or Business Administration 2. 5 or more years of relevant experience **General Description of Available Benefits for Eligible Employees of Truist Financial Corporation:** 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 (https://benefits.truist.com/) . 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. **_Truist supports a diverse workforce and is an Equal Opportunity Employer that does not discriminate against individuals on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law. Truist is a Drug Free Workplace._** EEO is the Law (https://www.eeoc.gov/sites/default/files/2022-10/EEOC\_KnowYourRights\_screen\_reader\_10\_20.pdf) Pay Transparency Nondiscrimination Provision (https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp\_%20English\_formattedESQA508c.pdf) E-Verify (https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify\_Participation\_Poster\_ES.pdf)
Confirm your E-mail: Send Email