Business Analytics Lead - Regulatory Reporting

PNC•Pittsburgh, PA

2d•Onsite

About The Position

This position sits within the Finance Regulatory Reporting organization and plays a key role in advancing regulatory reporting automation and data quality initiatives. While there will be some continued focus on post-conversion cleanup activities related to prior acquisitions, the primary emphasis of the role is on enhancing data processes, improving reporting efficiency, and supporting strategic regulatory reporting objectives. The role requires a hands-on, technically strong individual who can work across data, systems, and regulatory requirements to deliver scalable automation and high-quality reporting outcomes.

Requirements

Bachelor’s degree in Finance, Accounting, Information Systems, Data Analytics, or related field (or equivalent experience).
Strong SQL skills with the ability to query, transform, and analyze large datasets.
Experience in data analysis, 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.

Nice To Haves

Experience with bank regulatory reporting (e.g., FFIEC 031, FR Y-9C, FR Y-15, TIC, FR 009 or similar).
Familiarity with Axiom or other regulatory reporting platforms.
Working knowledge of Python for data automation, analysis, or testing.
Experience with data warehousing concepts, data lineage, and source-to-target mapping.
Understanding of regulatory reporting controls, governance, and data quality frameworks.
Experience supporting data cleanup, remediation, or post-integration activities.

Responsibilities

Design, develop, and enhance automated data pipelines and reporting processes supporting key regulatory reports (e.g., FFIEC 031, FR Y-9C, FR Y-15, TIC, FR 009).
Perform data analysis, reconciliations, and variance investigations to ensure accuracy, completeness, and consistency of regulatory reporting data.
Translate regulatory reporting requirements into data and system solutions in partnership with subject matter experts.
Support development and enhancement of reporting logic within Axiom or similar regulatory reporting platforms.
Identify and implement process improvements to strengthen data quality, controls, and reporting efficiency.
Contribute to documentation of data lineage, business rules, and control frameworks to support audit and regulatory expectations.
Support targeted data cleanup and remediation activities following prior acquisition integrations.
Validate and reconcile legacy and integrated data to ensure alignment with regulatory reporting requirements.
Partner with technology and data teams to resolve outstanding integration-related issues impacting reporting.
Collaborate cross-functionally with technology, data, and regulatory reporting teams to support system enhancements and issue resolution.
Execute and document testing (QA/UAT) to validate changes impacting regulatory reporting outputs.
Support broader regulatory reporting initiatives, including remediation efforts, control enhancements, and strategic projects.

Benefits

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