PNC Business Analytics Consultant - Financial Regulatory 

United States, Pennsylvania, Pittsburgh 

63216612

This position is primarily based in a PNC location. Responsibilities require time in the office or in the field on a regular basis. Some responsibilities may be performed remotely, at manager’s discretion.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.•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.
• At least two 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 analytical tools to provide business and technical expertise for the analytics process, tools and applications for a business function or business unit to create data driven solutions.
• Recommending appropriate performance measures to be produced including lifts, efficiencies, confidence intervals, and other statistical metrics.
• Analyzing and processing data, building and maintaining models and report templates, and developing dynamic, data-driven solutions.
• Providing business clients with detailed, actionable reports documenting the findings from, data processing, and data analysis.
• Consulting on using business intelligence data for predictive analytics and facilitating implementation of new tools and data marts.

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 customized customer solutions.
• Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and requiredneeded to be successful in this position.

Roles at this level typically require a university / college degree, with 2+ years of relevant professional experience. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)
California Residents

Refer to the