Apply Now    

Business Analyst I - Data Analysis & Reporting

Req #: 170109437
Location: Columbus, OH, US
Job Category: Operations
Job Description:
Please note that this position is not eligible for Visa sponsorship 
Job Description:
Centralized Transaction Operations (CTO), which is aligned under Consumer and Community Banking Operations, provides a wide range of global operational support and services for retail, commercial, treasury, asset wealth management and credit card customers.  The BCS (Banking Center Services) group within CTO has needs in Data Mining, Analysis and Reporting functions primarily focused towards measuring, reporting and improving their business performance and client profitability through data analysis and process improvement initiatives related to ATM and Branch Performance, focusing on Hardware performance monitoring.  This analyst will support in the following:
  • Identify areas of opportunity through rigorous analysis of key performance metrics/indicators for each unit of Operations
  • Perform data analysis by mining information from various data sources and construction of that data into meaningful, actionable information
  • Develop reports and structure presentations to present key messages to senior management
  • Develop streamlined reporting and automated scorecards from various systems, including the ICDW (data warehouse)
Responsibilities
  • Gather, research, classify and evaluate data to provided analytical support for Business as Usual and ad hoc projects in the line of business
  • Generate detailed reports focusing on financial information, call volumes, staffing information, production performance and more
  • Partner with business unit operations to troubleshoot production issues related to end reporting
  • Interact with senior leadership to transfer and clarify various types of business data into meaningful information
Qualifications - Required
  • Experience analyzing data, preparing reports and making presentations in an ever-changing business environment.
  • Minimum 1 year experience working for a financial/retail loan or credit granting institution
  • Minimum of 2 years work experience using Excel. Strong proficiency in creating and managing complex, connected workbooks/sheets, manipulating/segmenting data (e.g., pivot tables, filtering, vlookups), constructing macros, and generating complex formulas and calculations.
  • Minimum of 2 years work experience with object-oriented databases (e.g., Access).  Strong skills including maintaining/modifying new database links and queries, along with the ability to troubleshoot VBA macro errors.
 Qualifications - Preferred
  • Experience with Data Mining development, data extraction using data warehouses
  • Experience in SAS/SQL
  • Experience in Hyperion/Brio
  • Bachelor's degree in Business or a related discipline
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.

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.