Apply Now    

Commercial Bank- Business Analysis & Reporting Analyst (SQL exp.) -Chicago

Job Description

Business Analysis & Reporting Analyst


Commercial Banking (CB) delivers extensive industry knowledge, local expertise and dedicated service to more than 24,000 global clients, including corporations, municipalities, financial institutions and not-for-profit organizations along with nearly 35,000 real estate investors/owners. 
The Business Analysis & Reporting Analyst will join a global Management Reporting & Analytics group, leading a data & management reporting development agenda with high visibility to senior executives.  The successful candidate will learn core business processes, launch a new data mart environment, develop metrics/management reporting, and provide decision support via data analytics. She/he will partner with senior managers, Finance teams, and global MIS team resources to define and execute on a strategic roadmap.
  • Develop a deep understanding of systems and processes in order to extract insights from existing data while identifying and recommending IT enhancements to improve data quality
  • Define, monitor, and report key operational metrics; implement and manage balanced scorecards and dashboards at the employee, team, and department levels
  • Provide a high level of responsiveness to executive ad-hoc requests, “what-if” scenario modeling, and regulatory inquiries
  • Data mining and analytical projects as assigned by program executives, with goal of reducing errors or proactively identifying process risks
  • Where applicable, develop volume capacity and forecasting models to ensure appropriate staffing levels in anticipation of expected volume patterns
  • Mentor junior staff and provide technical training in advanced data concepts
  • 7+ years of total experience within MIS/Analytics roles; must have expert-level, demonstrated knowledge of data & business intelligence concepts with ability to provide design guidance and architecture review in support of junior staff 
  • Proven experience delivering timely, high quality, senior manager-level reporting and analysis from diverse, complex data sources.  Attention to detail a must with focus on executive quality presentation 
  • Self-starter; demonstrated ability to complete assigned tasks independently with minimum supervision 
  • Team player; Excellent communication, project management, and client partnership ability 
  • Expert-level ability expected in SQL query and database development.  Expert in all MS Office tools (Excel, Pivot Tables, Access, VBA, PowerPoint) 
  • Experience developing complex business analysis models, preferably in support of volume capacity and forecasting initiatives 
  • Demonstrated knowledge of data warehousing concepts and exposure to one or more Business Intelligence toolsets and database platforms: SQL Server Reporting Services (SSRS), Tableau, Analysis Services (SSAS), Qlikview, Business Objects, SAS, Crystal, R, SQL/Oracle/Teradata, etc.  Experience with Tableau, Qlikview a plus 
  • BS/BA required; quantitative focus / advanced study a plus
Req #: 160009793
Location: Chicago, IL US
Job Category: Operations
Employment Type: Full Time
Potential Referral Amount: 0 US Dollar (USD)

Apply Now    

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.

Join Now

Privacy Statement

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please contact us by calling (US and Canada Only) 1-866-777-4690. Please indicate the specifics of the assistance needed.

Keep in touch

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