Business Analytics Consultant Senior- Transaction Testing

PNC Financial Services Group


Pittsburgh, PA

Why you should apply for a job to PNC Financial Services Group:

  • 4.1/5 in supportive management

  • 74% say women are treated fairly and equally to men

  • 80% say the CEO supports gender diversity

  • Ratings are based on anonymous reviews by Fairygodboss members.
  • Tuition-free and other education options available

  • Up to 40 Hours Paid Time Off to Volunteer with Grow up Great®

  • Access to Progyny fertility coverage

  • #R136986

    Position summary

    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.

    •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.


    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.



    Additional Job Description

    Base Salary: Commensurate with skills and experience.


    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 > 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.

    Get jobs straight to your inbox

    Anonymous company reviews, virtual recruiting events, and a supportive community for women when you sign up.

    What are PNC Financial Services Group perks and benefits

    Lactation facilities

    Post maternity

    Backup child care

    Onsite child care

    Child care subsidies

    Elder care

    Sponsorship program


    Diversity recruiting

    Unconscious bias training

    Remote work policy

    Part time policy

    Paid maternity

    Unpaid maternity

    Paid paternity

    Unpaid paternity

    Paid adoptive

    About the company

    Industry: Finance: Personal & Commercial Banking

    For more than 160 years, we have been committed to supporting our customers, communities, employees and shareholders. At PNC, we are proud of our longstanding history of building strong communities that create financial opportunities for individuals, families and businesses. The commitment to creating a differentiated experience for our customers is driven by our commitment ...

    Why you should apply for a job to PNC Financial Services Group:

  • 4.1/5 in supportive management

  • 74% say women are treated fairly and equally to men

  • 80% say the CEO supports gender diversity

  • Ratings are based on anonymous reviews by Fairygodboss members.
  • Tuition-free and other education options available

  • Up to 40 Hours Paid Time Off to Volunteer with Grow up Great®

  • Access to Progyny fertility coverage

  • Advertisement