Business Analytics Lead - Regulatory Reporting

PNC • Pittsburgh, PA

12d • $65,000 - $161,000 • Onsite

About The Position

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 Lead within PNC's Regulatory Reporting organization, you can be based in Pittsburgh, PA or Denver, Co.

Position Overview:

This position sits within the Finance Regulatory Reporting organization and will play a critical role during an interim period focused on acquisition integration. The primary emphasis during this phase will be on data and system integration activities required to onboard acquired entities into PNC’s regulatory reporting environment.

Over time, the role will evolve to support broader regulatory reporting initiatives, including report automation, data analysis, and other strategic projects within the Regulatory Reporting function. The ideal candidate is hands-on, technically skilled, and comfortable working across data, systems, and regulatory requirements.

Key Responsibilities:

Acquisition Integration (Initial Focus)
• Support data and system integration efforts related to bank acquisitions, ensuring accurate and complete migration of data into PNC source systems.
• Perform hands-on testing of migrated data to validate completeness, accuracy, and alignment with regulatory reporting requirements.
• Analyze data flows from source systems through downstream regulatory reporting processes to ensure data is properly mapped and transformed.
• Conduct data analysis, reconciliations, and variance investigations to identify and resolve data quality or integration issues.
• Partner with technology, data, and regulatory reporting teams to support system updates, fixes, and enhancements required for successful integration.
• Execute and document QA testing to confirm regulatory reporting readiness post-migration.
Ongoing / Evolving Responsibilities
• Contribute to regulatory reporting automation initiatives, including enhancements to data pipelines, controls, and reporting processes.
• Perform ad hoc and recurring data analysis in support of regulatory reporting, quality assurance, and control activities.
• Support other regulatory reporting–related projects, including process improvements, system enhancements, and remediation efforts.
• Assist with documentation related to data lineage, controls, and regulatory reporting processes, as needed.
• Collaborate with regulatory reporting SMEs to interpret reporting requirements and translate them into data and system needs.

Job Description
Leads the analytics processes across multiple functions or business units leveraging an array of complex analytical tools to create data driven solutions. Serves as mentor to more junior employees.
Consults with clients and mentors consultants 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.
Assists peers with guidance on analytic approaches related to more complex solutions.
Conceptualizing, developing and continuously optimizing analytical solutions for business leadership 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.

Requirements

• Bachelor’s degree in Finance, Accounting, Information Systems, Data Analytics, or a related field (or equivalent experience).
• Strong hands-on experience with SQL for data querying, analysis, and reconciliation.
• Working knowledge of Python for data analysis, automation, or testing activities.
• Experience performing data validation, reconciliations, and QA testing in a financial or data-intensive environment.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to work effectively across business, data, and technology teams.
• Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role.
• Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Nice To Haves

• Prior experience with bank regulatory reporting (e.g., Call Reports, FR Y-9C, 14M/Q, or similar).
• Familiarity with regulatory reporting systems, data warehouses, or source-to-target data mappings.
• Experience supporting system conversions, acquisitions, or large-scale data migrations.
• Knowledge of internal controls, data quality frameworks, or regulatory reporting governance.

Responsibilities

• Support data and system integration efforts related to bank acquisitions, ensuring accurate and complete migration of data into PNC source systems.
• Perform hands-on testing of migrated data to validate completeness, accuracy, and alignment with regulatory reporting requirements.
• Analyze data flows from source systems through downstream regulatory reporting processes to ensure data is properly mapped and transformed.
• Conduct data analysis, reconciliations, and variance investigations to identify and resolve data quality or integration issues.
• Partner with technology, data, and regulatory reporting teams to support system updates, fixes, and enhancements required for successful integration.
• Execute and document QA testing to confirm regulatory reporting readiness post-migration.
• Contribute to regulatory reporting automation initiatives, including enhancements to data pipelines, controls, and reporting processes.
• Perform ad hoc and recurring data analysis in support of regulatory reporting, quality assurance, and control activities.
• Support other regulatory reporting–related projects, including process improvements, system enhancements, and remediation efforts.
• Assist with documentation related to data lineage, controls, and regulatory reporting processes, as needed.
• Collaborate with regulatory reporting SMEs to interpret reporting requirements and translate them into data and system needs.
• Leads the analytics processes across multiple functions or business units leveraging an array of complex analytical tools to create data driven solutions.
• Serves as mentor to more junior employees.
• Consults with clients and mentors consultants 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.
• Assists peers with guidance on analytic approaches related to more complex solutions.
• Conceptualizing, developing and continuously optimizing analytical solutions for business leadership 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.

Benefits

• PNC offers 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; 401(k) with PNC match, pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption, surrogacy, and doula reimbursement; educational assistance, including select programs fully paid; a robust wellness program with financial incentives.
• In addition, PNC generally provides the following paid time off, depending on your eligibility: maternity and/or parental leave; up to 11 paid holidays each year; 9 occasional absence days each year, unless otherwise required by law; between 15 to 25 vacation days each year, depending on career level; and years of service.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees