JPMorgan Financial Analysis 

United States, Ohio, Columbus 

870729627

DESCRIPTION:

QUALIFICATIONS:

Minimum education and experience required: Bachelor's degree in Business Administration, Accounting, Finance or related field of study plus 7 years of experience in the job offered or as Financial Analysis, Business Intelligence Analyst, Shared Business Operations & Portfolio Management Specialist, Credit Analyst, or related occupation.

Skills Required: This position requires two (2) years of experience with the following: identifying and documenting financial model gaps or inconsistencies within financial data workflows; collaborating with business, compliance, risk, and IT teams to define UAT testing criteria for financial systems and automation solutions; ensuring Y-14A submission data quality aligns with Federal Reserve's guidance and Dodd-Frank Act Stress Testing (DFAST) regulations including assumptions for baseline, adverse and severely adverse stress scenarios; leading the development and submission of CCAR (Comprehensive Capital Analysis and Review) data pipelines ensuring compliance with appropriate risk controls and regulatory expectations and completing data contributor attestations for the integrity of the results; collaborating with data engineering team to integrate Python-based forecasting software to execute quantitative model runs and create Standard Operating Procedure (SOP) for ETL solutions to ensure consistency and repeatability of forecasting processes and data loaded to EssBase; leveraging advanced statistical models and econometrics to support forecasting efforts; working closely with business units to define forecasting requirements and ensure model predicted outputs align with business expectations; ensuring models are optimized for performance and accuracy through semi-annual back-testing and annual sensitivity analysis; creating dynamic pivot tables to summarize and analyze large data sets along with pivot table calculated fields; collecting and consolidating capital planning and financial projection data from multiple business units using macro-based excel tools and ensuring all relevant metrics are captured accurately; building variance analysis reports using advanced Excel functions such as VLOOKUP, xlookup, sumifs, countifs, concatenate, transpose, sort or index-match, and handle large volumes of financial data for performing complex calculations involving multiple cells or ranges; validate and ensure data integrity across a broad spectrum of reports and analysis, produce reports and ad-hoc data analysis and present to senior management; developing and implementing quality assurance (QA) and quality control (QC) data quality frameworks to test and validate financial data workflows; using Tableau to create interactive and visually appealing data visualizations that allow users to explore key performance metrics; designing and implementing financial dashboards that provide real-time insights and improve decision-making processes and ensure dashboards are designed for scalability, performance, and accessibility.

Job Location: 1111 Polaris Parkway, Columbus, OH 43240.