Business Analytics Lead - Regulatory Reporting

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 could be based in Pittsburgh, PA, Cleveland, OH or Birmingham, AL. 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.

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

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; Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience; In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered

Nice to have

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; Analytical Thinking; Business Intelligence (BI); Concept Development; Data-Driven Decision Making; Data Integration; Market Research; Performance Metrics; Qualitative Research; Strategic Planning

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; robust wellness program with financial incentives; maternity and/or parental leave; up to 11 paid holidays each year; 9 occasional absence days each year; between 15 to 25 vacation days each year depending on career level and years of service