Data Reporting Officer

The Data Reporting Officer leads the end-to-end preparation, validation, review, and submission of CCAR FR Y-14 M/Q reports for assigned schedules. This role oversees the design, development, and execution of regulatory reporting processes to ensure data accuracy, integrity, consistency, and timeliness. As a subject matter expert, the officer partners with Lines of Business (LOBs) to support reporting changes, ensure regulatory compliance, and strengthen data governance., 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. Guide planning, development and 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 Regulatory Reporting Schedule processes.
3. Support relationship management with Treasury and Lines of Business, as applicable, and the development of the design, testing, and implementation of reporting changes.
4. Coordinate with lines of business SMEs and risk management to solidify their understanding of the report requirements for Regulatory Reporting and the need for information about system or other process changes as well as the data integrity requirements for the data
5. Provide thought leadership and creation of adequate testing and process controls to improve the integrity and accuracy of the reports from the source through report. This includes the development of proprietary data checking routines. Mentor and provide guidance to junior analysts on processes, data interpretation, and regulatory concepts.
6. Escalate data quality issues to management and LOBs, and actively track root cause analysis and issue remediation. Drive continuous improvement across reporting processes, automation, data quality, and controls.
7. Assist the Sr Data Reporting Officer in providing thought leadership on process improvements, detailed reviews and package preparation process.
8. Develop, present and review Code Changes Requests (CCR) and impact analyses with Sr Data Reporting Officer for approval prior and assist Sr Data Reporting Officer in providing effective challenge and review
9. Lead the daily, monthly, and/or quarterly preparation, review, and submission of regulatory reports. Serve as the SME for reporting rules, ensuring adherence to reporting instructions and supervisory guidance. Lead variance analysis and root cause review for anomalies or unexpected reporting trends.

Success in this position requires strong technical expertise in enterprise databases, SAS/SQL, and reporting tools, along with the ability to translate complex business requirements into effective technical solutions. Strong analytical, leadership, and communication skills are essential to collaborate across stakeholders and deliver high-quality reporting outcomes., 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. Ten years of work experience in access enterprise databases (Netezza, Oracle, DB2) and report development
3. Ten years of experience in SAS and/or SQL programming
4. Demonstrated 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. Experience in regulatory or SEC reporting with extensive experience in CCAR reporting
7. Experience with SAP, Hyperion Reporting and GL Master Data
8. Advanced Excel / VBA skills
9. Excellent verbal, written and presentation skills, with the ability to define problems and persuasively present conclusions
10. 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. Supervisory experience