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

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
Preferred Qualifications:
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.

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythondata analysisdata validationdata reconciliationQA testingdata migrationdata mappingregulatory reportingdata pipelines

Soft Skills

analytical skillsproblem-solving skillsattention to detailcollaborationcommunication