Join the External Reporting Team, to play a key role analyzing large loan level dataset to meet external regulatory reporting requirements. Reporting critical data for Consumer and Community Banking is a challenging, ever-changing and rewarding experience with communication with various lines of business and levels of management.  

As an External Reporting Associate, in the External Reporting Team within Consumer & Community Banking, you will be responsible for analyzing large sets of loan level data, evaluating and translating reporting instructions into sound and quality data, improving analytical review process, maintaining documentations on change control procedures.  This position is primarily responsible for gathering, interpreting, and managing reporting requirements for external regulatory institutions (FDIC, FRB, OCC, etc.). This is a hands-on role with a great potential for career growth. We are looking for an individual with unique combination of strong technical (SQL) and interpersonal skills to drive the continuous data improvement. This role will work collaboratively with both internal team members and a wide range of partners from Home Lending Business, Technology, MIS and Risk.

Job Responsibilities

Analyze (Deep dive) the data to ensure accuracy of reporting Utilize the home lending servicing systems and practices to ensure accurate and sound reporting  Analyze large data sets and conduct root cause analysis to understand and remediate reporting anomalies Account for detailed documentation of Requirements/Requirement interpretation Conduct data research to triage issues, identify root cause and recommend solutions to fix data defects Work with other teams  (IT, CCB Data Management & Risk etc.) to identify data issues and improve data quality for CCAR files and to effectively update logic during system conversions / decommissions as well as new acquisitions Prepare various reporting metrics for inclusion in presentations to Steering Committee and Management

Required qualifications, capabilities and skills 

Bachelor’s degree in Computer Science, MIS, Finance, Accounting, Mathematics or related area Direct experience with Home Lending servicing system (MSP) to perform loan level review to determine RCA to assist in the remediation of Reporting discrepancies Experience with delivering solutions through agile methodologies and new technologies Advanced analytical and quantitative skills Strong oral and written communication skills Strong organizational and multi-tasking skills are critical Works well collaboratively and independently in an ever-changing business environment

Preferred Qualifications, capabilities and skills

Strong working knowledge of MS Excel and advanced data manipulation functions (Pivot Tables, VLOOKUP, ODBC, VBA) is preferred Strong SQL skills exposure to Python, Tableau and Alteryx is a plus Minimum 3 years of Mortgage/Banking/finance analytical support experience preferred