Apply Now    

Business Systems Analyst II

Req #: 180006208
Location: Columbus, OH, US
Job Category: Operations
Job Description:

JPMorgan Chase & Co. is a leading global financial services firm with assets of $1.1 trillion and operations in more than 50 countries. The firm is a leader in investment banking; financial services for consumers and businesses, financial transaction processing, asset and wealth management, and private equity. Under the JPMorgan Chase & Co. brand, the firm serves millions of consumers in the United States and many of the worlds most prominent corporate, institutional and government clients.

The Business Systems Analyst II is responsible for working with the business to gather reporting and data requirements, perform the functional and technical design, and scope level of effort needed to deliver solutions to business users. The ideal candidate will be involved an agile environment and contribute in various aspects of SDLC. Responsible to design and develop complex BI solutions encompassing dimensional modeling, analytics and multi-source data integration. The Business Systems Analyst II will perform in depth data analysis and collaborate closely with reporting team to implement requirements in an efficient, accurate and timely manner. The ideal candidate will also provide enterprise level ETL solutions and will be actively involved with huge volume of data from various technology platform and implement complex business logic into required result. Conduct test plans, test case development, unit testing and user acceptance testing. Participate in code reviews and ensure high quality of product is delivered. Provide scalable solution to complex technical issues. Responsible for performance tune long running and inefficient queries. Responsible for ad hoc reports and dashboard development and responsible for production support and resolve issues. Participate in creating details process documents and facilitate knowledge sharing sessions.


Skills required:

  •  Experience in all phases of SDLC and have development methodologies including Agile, Scrum, or Waterfall
  • Experience applying advanced mathematical concepts and developing simulation models to provide improved analytical insights to service based operations
  • Experience with architecting highly performant databases using the following platforms: ORACLE, SQL SERVER,DB2, MS Access, TERADATA, My SQL, Sybase, and Informix
  • Database experience with advanced SAS/SQL/PLSQL
  • Experience researching and manipulating large data sets and performance analysis
  • Experience with data analysis and synthesizing information across multiple platforms, systems, and organizations
  • Experience scaling and performance tuning of high volume OLTP and OLAP and data warehousing environments
  • Must have experience in data warehousing
  • Must have demonstrated knowledge of release management process, process automation BMC, Windows scheduler
  • Experience in testing and defect tracking
  • Experience in performance tuning
  • Minimum experience required: 1 year of experience in Data Architecture, Data Analytics, Call Center, Business Intelligence, or related experience
  • Minimum education required: Master's degree or bachelors plus 5 years IT experience
Apply Now    
Link for schema

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.