Apply Now    

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

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 Client Service group within Commercial Banking is a ~700FTE national organization that provides dedicated client service across all CB lines of business. 
A strategic priority for the organization is to ensure that we have best-in-class operational data, reporting, and business analytics programs that will drive continuous improvements in client experience, control, and efficiency while streamlining the management reporting cycle for maximum efficiency & value.
The successful candidate will learn core business processes while leveraging strong technical business intelligence reporting skillsets and tools to develop data and reporting programs. 
Primary Responsibilities
  • Develop a deep understanding of systems and processes in order to extract insights from existing data while identifying and recommending source system enhancements to improve data quality 
  • Extract and load new data sources into SQL data mart environments using primarily the SSIS toolset, ensuring that strong data quality controls are in place 
  • Define, monitor, and report key business metrics; implement and manage various reporting processes and dashboards using primarily SSRS, Tableau, and/or Qlikview toolsets 
  • Provide a high level of responsiveness to ad-hoc requests, “what-if” scenario modeling, and regulatory inquiries 
  • Utilize project management best practices to track book of work priorities, communicate updates, and manage projects to successful completion; explain data concepts & challenges clearly to non-technical stakeholders
  • 5 years of total experience within MIS/Analytics roles (or 3+ years with MS degree); must have expert knowledge of data & business intelligence concepts (e.g., SQL, Data Modeling) with ability to communicate programs and challenges to non-technical stakeholders
  • Proven experience delivering timely, high-quality, senior manager-level reporting and analyses from diverse, complex data sources. Attention to detail a must with a focus on executive level presentation quality
  • Self-starter; demonstrated ability to complete assigned tasks independently
  • Team player with excellent communication, project management, and client partnership ability
  • Expert-level ability expected in SQL query development.  Expert in all MS Office tools (Excel, Pivot Tables, Access, VBA, PowerPoint)
  • 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
  • BS/BA preferred; prefer quantitative focus; advanced study a plus
Req #: 160031577
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.