Senior Portfolio Analytics & Strategy Analyst

PNC

. Lead identification, definition, and delivery of data requirements .

Posted 9/23/2026full-timeUnited StatesSenior💰 $86,250 - $158,125 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data provisioning, validation, and analytics, with a strong focus on risk and financial reporting. Proficient in SQL and experienced in collaborating with cross-functional teams to develop scalable data solutions.

Highest-signal resume keywords

SQLData ProvisioningData ValidationRisk AnalyticsJira

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills

Data AnalysisData Quality AssessmentPredictive ModelingData RemediationData Lineage DocumentationFinancial ReportingRegulatory ReportingOperational AnalyticsLarge Dataset ManagementBusiness Rule Mapping

Soft Skills

CollaborationProblem SolvingCommunication

Tools & Technologies

JiraTeradataHadoopPythonPandasPySparkPower AppsPower AutomatePower BI

Industry Keywords

Risk ManagementFinanceCECLStress TestingPortfolio Analytics

Tech Stack

Tools & technologies

HadoopPandasPySparkPythonSQL

About the role

Key responsibilities & impact

Lead identification, definition, and delivery of data requirements
Partner with modeling, business, technology, and data consumer teams to translate requirements into provisioning solutions
Source or develop data assets and address data quality issues
Develop, test, and document prototype logic for new data attributes and remediation solutions
Collaborate with technology teams on enhancements, data issues, and production deployments
Document data lineage, business rules, and mapping specifications
Manage Jira work items
Perform data validation, reconciliation, and quality assessments
Identify opportunities to automate processes and improve operational efficiency
Participate in testing and validation activities
Provide financial and regulatory reporting and analyses
Run complex business performance, risk, and operational analytics
Develop analytical methods/models for market, credit, and operational risk
Analyze large datasets and develop strategies to improve lending decisions, manage risk, increase revenue, and reduce losses
Apply predictive models and third-party data for segmentation and targeting of acquisition and portfolio strategies
Manage engagements with internal and external information suppliers
Design, develop, and monitor test designs and analytical reporting
Design and enhance standard reporting suites for product and portfolio reviews
Collaborate with line of business, Finance, and Risk partners to establish credit risk appetite, policies, and procedures

Requirements

What you’ll need

Bachelor's degree / university or college degree
3+ years of relevant/direct industry experience
In lieu of a degree, a comparable combination of education, job-specific certification(s), and experience, including military service, may be considered
Experience provisioning data for risk, finance, CECL, stress testing, regulatory reporting, or portfolio analytics
Strong SQL skills
Experience validating and reconciling large datasets
Experience working with enterprise data warehouses and distributed data environments
Ability to translate business requirements into scalable data solutions
Experience partnering with business and technology teams throughout the data lifecycle
Preferred skills: Jira, SQL, Teradata, Hadoop, Python, Pandas, and PySpark
Experience with Power Apps, Power Automate, Power BI, and AI agent development is a plus
No required certifications
No required licenses
No required or preferred language assessments
Must be eligible to work without employment visa sponsorship; PNC will not provide sponsorship or participate in STEM OPT

Benefits

Comp & perks

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 plan
Stock purchase plan
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
15 to 25 vacation days each year, depending on career level and years of service
Incentive-eligible compensation based on company, business and/or individual performance