Portfolio Analytics – Strategy Specialist

PNC

. Serve as a primary data resource for the Risk Operations & Quantitative Strategy team .

Posted 11/4/2026full-timeUnited StatesMid-LevelSenior💰 $91,000 - $202,800 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in data extraction, transformation, and analysis, with advanced SQL skills for managing large-scale data warehouses. Proficient in risk management concepts and capable of communicating complex analyses to diverse audiences.

Highest-signal resume keywords

Advanced SQL SkillsData Analysis with PythonExperience with Power BIRisk Management Data ConceptsData Quality Assurance

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 ExtractionData TransformationData ValidationComplex SQL QueriesData Pipeline DevelopmentPredictive ModelingData ReportingData ReconciliationStatistical AnalysisData Quality Checks

Soft Skills

Analytical SkillsProblem-Solving SkillsAttention to DetailTime ManagementCommunication Skills

Tools & Technologies

Power BITableauEnterprise Data WarehouseRelational DatabasesData Management Tools

Industry Keywords

Banking IndustryRisk OperationsQuantitative StrategyMarket RiskCredit RiskOperational RiskFinancial ProductsData GovernancePortfolio AnalysisBusiness Performance

Tech Stack

Tools & technologies

PythonSQLTableau

About the role

Key responsibilities & impact

Serve as a primary data resource for the Risk Operations & Quantitative Strategy team
Extract, transform, validate, and analyze data from the Enterprise Data Warehouse and other enterprise sources
Develop, maintain, and optimize complex SQL queries for recurring and ad hoc reporting
Create and maintain data pipelines and processes to improve efficiency, scalability, and data quality
Perform data quality checks, reconciliations, and validation routines
Support risk-related reports, dashboards, portfolio analyses, and management information
Analyze market, credit, and operational risk for new and existing financial products
Improve risk-adjusted returns, portfolio decisions, revenues, exposure to losses, and business performance
Apply predictive models, third-party data, segmentation, and targeting for acquisition and portfolio strategies
Manage engagements with internal and external information suppliers while maintaining governance and oversight
Design, develop, and monitor test designs and analytical reporting
Design and enhance standard reporting suites for product and portfolio reviews
Collaborate with Risk, Finance, Technology, Data Management, Business, credit, data, and model development partners
Assess and establish credit risk appetite and related policies and procedures
Communicate analyses, findings, issues, and recommendations to technical and non-technical audiences

Requirements

What you’ll need

Bachelor's degree in Finance, Economics, Mathematics, Statistics, Information Systems, Computer Science, or a related field
Minimum 5 years of experience within the banking industry
Demonstrated understanding of banking and risk management data concepts
Advanced SQL skills with experience querying and understanding large-scale data warehouses and relational databases
Experience sourcing and manipulating data
Experience in reporting and analysis of data trends
Experience with Power BI and report-based applications
Working knowledge of Python, Power BI, and Tableau for data analysis, automation, and reporting support
Strong analytical, problem-solving, and critical-thinking skills
Excellent attention to detail and commitment to data accuracy
Ability to manage multiple priorities and meet deadlines in a fast-paced environment
No employment visa sponsorship or STEM OPT participation provided
In lieu of a degree, a comparable combination of education, job-specific certification(s), and experience, including military service, may be considered

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, unless otherwise required by law
15 to 25 vacation days each year, depending on career level
Incentive eligible, with payment based upon company, business and/or individual performance