Business Analytics Consultant Senior- Transaction Testing

Job Profile

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 Business Analytics Consultant Senior in PNC's Finance organization, you will be based in Pittsburgh, PA.

This position is primarily based in a location within PNC’s footprint. Preferred locations are listed in this requisition. Responsibilities require time in the office or in the field on a regular basis. Some responsibilities can be performed remotely. Additional locations may be considered.

The position will support PNC’s Regulatory Reporting department which is responsible for the statutory filings with regulatory agencies focusing on PNC’s several foreign entities.

The position offers the opportunity to navigate the multi-faceted and demanding regulatory landscape while partnering with experienced and diverse line of business contacts within PNC. As PNC embarks upon full scale transaction testing effort, this role will be an integral contributor in the validating the integrity of the reporting data specifically related to FRY-14M & FRY -14Q. This position offers a critical role in the planning and development stages of technological solution implemented for data analytics of large-scale data. The role will also be responsible for monthly and quarterly production of regulatory filings.

The role partners closely with various areas within Finance, Operations, Technology, and Treasury. Responsibilities will grow and change over time. There will be considerable interaction with all levels of various departments across PNC. Duties and responsibilities may include the following:
• Preparation of regulatory reporting filings and ad hoc reporting.
• Work closely with the Technology team to identify defects, resolves issues, coordinate releases, and test defects/system changes.
• Internal/External Audit, SOX, and Risk Management compliance.
• Participation on project teams dealing with system conversions and enhancements.
• Special projects.
• Communicate information to Senior Management.
• Identify opportunities for automation and work with Technology and management to implement solutions

Additionally, you will contribute to the continued automation of regulatory reporting which includes: 1) using SQL and Teradata technology to query, identify and analyze automation opportunities, and 2) defining scope of activities, requirements definition, process review, impact assessment and operational streamlining.

Skills and Abilities:
•Quickly learn organizational structure, business strategies and processes.
•Work independently and manage multiple assignments in a fast-paced environment.
•Write clear and well-structured business requirements documents.
•Resolve minor data conflicts/issues using different tactics.
•Demonstrated problem solving and critical thinking skills.
•Solid Microsoft Excel and Word skills.
•Basic SQL and Teradata querying skills.
•Strong verbal and written communication skills.

Competencies utilized in this position include:
•Create accurate and thorough financial reports in accordance with GAAP/IFRS and regulatory requirements.
•Ensure processes, procedures and workpapers adequately support reporting requirements and filed results.
•Interpret and implement instructions from the various regulators.
•Able to apply advanced accounting and/or finance concepts in performing complex analysis.
•Gather, document and update business requirements.
•Develop business testing strategies and work with project members to execute test plans, recommend preferred solutions, and implement recommendations.
•Develop and maintain strong relationship with business partners and internal/external team members.
•Effective communication with both regulatory reporting team and LOBs to fully understand processes and results.
•Identify issues and escalates/manages resolution as required.

Education:
•Bachelor’s degree in Accounting, Finance, or Information Technology is desirable or equivalent work experience 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 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.

Competencies

Analytical Thinking – Knowledge of techniques and tools that promote effective analysis and the ability to determine the root cause of organizational problems and create alternative solutions that resolve the problems in the best interest of the business.Business Acumen – Knowledge, insight, and understanding of business concepts, tools, and processes that are needed for making sound decisions in the context of the company's business; ability to apply this knowledge appropriately to diverse situations.Business Analytics – Knowledge of technologies, techniques and practices for the evaluation of business performance data; ability to analyze business performance using advanced statistical methods to justify and drive future business planning decisions.Consulting – Knowledge of techniques, roles, and responsibilities in providing technical or business guidance to clients, both internal and external; ability to apply this knowledge appropriately to diverse situations.Decision Making and Critical Thinking – Understanding of the issues related to the decision-making process; ability to analyze situations fully and accurately, and reach productive decisions.Effective Communications – Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.Emerging Technologies – Knowledge of and ability to design, apply and evaluate new information technologies for business environments in order to improve work productivity and accuracy.

Work Experience

Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors

Additional Job Description

Base Salary: Commensurate with skills and experience.

Benefits

PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include medical/prescription drug coverage (with a Health Savings Account feature); dental and vision options; employee and spouse/child life insurance; short- and long-term disability protection; maternity and parental leave; paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives. To learn more about these and other programs, including benefits for part-time employees, visit pncbenefits.com > New to PNC.

Disability Accommodations Statement:

The PNC workplace is inclusive and supportive of individual needs. If you have a physical or other impairment that might require an accommodation, including technical assistance with the PNC Careers website or submission process, please call 877-968-7762 and select Option 4: Recruiting or contact us via email at [email protected] 

The Human Resources Service Center hours of operation are Monday - Friday 9:00 AM to 5:00 PM ET.

Equal Employment Opportunity (EEO):

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.