Business Analytics Lead - Regulatory Reporting

PNC; Pittsburgh (Allegheny County); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical coverage

401(k) with match

Educational assistance

Paid time off

Job summary

PNC is looking for a Business Analytics Lead in Pittsburgh, PA. This role focuses on regulatory reporting automation and improving data quality. Candidates should have a Bachelor's degree in Finance or related fields and strong SQL skills for data analysis.

Responsibilities include designing automated data pipelines, performing data reconciliations, and supporting regulatory reporting initiatives. PNC offers a comprehensive benefits package, including health coverage and paid time off.

Qualifications

• Bachelor’s degree in Finance, Accounting, Information Systems, Data Analytics, or equivalent experience.
• Strong SQL skills for querying and analyzing large datasets.
• Experience in data analysis, reconciliations, and QA/testing.

Responsibilities

• Design and enhance automated data pipelines for regulatory reports.
• Perform data analysis and reconciliations for accuracy.
• Support development of reporting logic within Axiom.

Skills

SQL skills

Data analysis

Problem-solving skills

Attention to detail

Collaboration

Education

Bachelor’s degree in Finance, Accounting, Information Systems, or related field

Tools

Axiom

Python

Job description

Position Overview

Business Analytics Lead – Regulatory Reporting (PNC Finance Regulatory Reporting). Based in Pittsburgh, PA, this role focuses on advancing regulatory reporting automation and data quality initiatives. The primary emphasis is on enhancing data processes, improving reporting efficiency, and supporting strategic regulatory reporting objectives while maintaining post‑conversion cleanup responsibilities related to prior acquisitions.

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

Required Qualifications

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

Preferred Qualifications

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

Benefits

PNC offers a comprehensive range of benefits including medical, prescription drug, dental and vision coverage, life insurance, short and long‑term disability protection, 401(k) with PNC match, pension and stock purchase plans, dependent‑care reimbursement account, backup child/elder care, adoption, surrogacy, and doula reimbursement, educational assistance, wellness programs, and paid time off (maternity and/or parental leave; up to 11 paid holidays; 9 occasional absence days; 15‑25 vacation days depending on career level).

Legal and Equal Opportunity Statements

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. This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

Disability Accommodations

If an accommodation is required to participate in the application process, please contact us via email at [e-mail]. Include “accommodation request” in the subject line and your name, the job ID, and preferred method of contact. Emails unrelated to accommodation requests will not receive responses. Applicants may also call 877‑968‑7762 and say "Workday" for accommodation assistance. All information provided will be kept confidential and used only to the extent required to provide necessary accommodations.