JPMorgan External Reporting – Business Analyst - Senior Associate 

United States, Ohio, Columbus 

879560564

As a Product Delivery Senior Associate on the External Reporting team 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

• Deep dive analysis of the data to ensure accuracy of reporting
• Analyze large data sets and conducting root cause analysis to understand and remediate reporting anomalies
• Document 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
• 3+ years of Mortgage/Banking/finance analytical support experience
• Strong SQL skills
• Experience with delivering solutions through agile methodologies and new technologies
• Advanced analytical and quantitative skills
• Strong working knowledge of MS Excel and advanced data manipulation functions (Pivot Tables, VLOOKUP, ODBC, VBA)
• Direct experience with Home Lending servicing system (MSP) to perform loan level review to determine RCA to assist in the remediation of Reporting discrepancies

Preferred qualifications, capabilities and skills

• Exposure to Python, Tableau and Alteryx

Required soft 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