JPMorgan Financial Data Analysis 

United States, New Jersey, Jersey City 

693719869

DESCRIPTION:

QUALIFICATIONS:

Minimum education and experience required: Master's degree in Information Technology & Management, Computer Science, Management Information Systems, Engineering or related field of study plus 1 year (12 months) of experience in the job offered or as Financial Data Analysis, Associate Projects, or related occupation.

Skills Required: This position requires experience with the following: troubleshooting data using SQL including identifying and fixing issues with database queries, stored procedures and query optimization; creating stored procedures in SQL to automate manual processes using variables, temp tables, update, inserts, joins, and indexes; creating variance analysis datasets in SQL to identify drivers of differences between two sets of data; developing automation solutions using SSIS, SSRS, and Alteryx to streamline financial workflows and reduce manual errors; implementing and monitoring ETL solutions using SSIS during production cycles to clean, transform and preprocess financial data for analysis and reporting; advanced Excel functions such as vlookup, xlookup, sumifs, countifs, concate, or index-match to handle large volumes of financial data for performing complex calculations involving multiple cells or ranges; creating dynamic pivot tables to summarize and analyze large data sets along with pivot table calculated fields; developing views using advanced charting techniques using data visualization in Tableau to create visually appealing and insightful financial dashboards and incorporating interactive elements and drill-down capabilities for detailed analysis.

Job Location: 575 Washington Blvd, Jersey City, NJ 07310.

Full-Time. Salary: $142,500 - $190,000 per year.