Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Sr. Business Analytics Consultant within PNC's Regulatory Reporting organization, housed within the Office of the Corporate Controller, you will can be based in Pittburgh, PA or Cleveland, OH.

We are seeking a bank regulatory reporting analyst with a focus on automation to enhance efficiency, accuracy, and compliance. This role involves using technology to streamline report preparation, ensuring timely and accurate data submission to a variety of regulatory agencies. The ideal candidate will have regulatory reporting experience with a large financial institution, experience with analyzing large data sets, and has experience with automating regulatory reports.

Key Responsibilities:
• Automate regulatory reporting including but not limited to FR-Y9C, FFIEC-031, FR-Y14Q, FR-Y14M
• Analyzing regulatory reports to ensure understanding of requirements to aid in automation efforts.
• Analyzing large data sets, sourcing new information, working with Source-to-Target (STM) documents.
• Developing business requirements to correct existing logic, or to build out new reporting functionality.
• Collaboration with internal technology teams, to assist with technology development lifecycle.
• Perform Quality Assurance testing (QA)/regression testing to ensure accuracy of new automation efforts.
• Ability to work with a variety of internal stakeholders to better understand different products, processes, etc.
• Ability to proactively identify further automation efforts, process efficiencies, enhancements, etc.
•Creation of data quality rules to analyze data to identify missing data, inconsistences, etc.

Qualifications/Skills:
Education: Bachelor’s degree in accounting, finance, data science, information systems, or related field. Ideal candidate would have a combination of accounting and data science/technology.
Experience:
At least three years of experience in regulatory reporting, financial reporting, or report automation within the banking industry or similar field.
Strong understanding of bank regulations and reporting requirements.
Strong knowledge of the components of a bank’s balance sheet
Strong data skills, including the ability to write SQL code to analyze large data sets to support the development of business requirements, QA validation, etc.
Experience working with bank regulatory reporting applications (ie. AxiomSL)
Ability to understanding complex reporting applications, to analyze existing configuration to assist in modification/creation of new configuration.
Experience working with Alteryx is a plus.
CPA certification is a plus, but not required.

Job Description

• Leverages complex analytical tools to provide business and technical expertise for the analytics process, tools and useful applications across multiple functions or business units to create data driven solutions.
• Consulting to clients on tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product / solution development.
• Determining the optimal analytic approach and supporting development, implementation and enhancements.
• Conceptualizing, developing and continuously optimizing analytical solution for operations and executive management to enable data driven decision making.
• Analyze results and make recommendations for key business partners and senior management or communicate conclusions from complex analytical solutions to a wide range of audiences.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating