Position OverviewAs a Portfolio Analytics & Strategy Specialist within PNC's Risk Operations and Quant Strategy organization, you will be based in Pittsburgh, PA / Brecksville, OH / Charlotte, NC / Houston, TX / Raleigh, NC.
The Portfolio Analytics & Strategy Specialist will play a critical role in supporting the Risk Operations & Quantitative Strategy (ROQS) team through the provisioning, transformation, and analysis of risk-related data. This position is responsible for sourcing data from the Enterprise Data Warehouse (EDW) and other internal banking systems to support regulatory, risk management, portfolio monitoring, and executive reporting needs.
The ideal candidate possesses strong banking and risk management knowledge, advanced SQL development skills, and working experience with Python, PowerBI and Tableau. This individual is intellectually curious, highly self-motivated, and capable of developing innovative solutions to complex data challenges. Success in this role requires a strong understanding of risk data concepts, attention to detail, and the ability to partner effectively with business, risk, and technology stakeholders.
Key Responsibilities
Data Provisioning & Risk Analytics
• Serve as a primary data resource for the ROQS team, delivering accurate, timely, and reliable datasets for risk reporting and analytics.
• Extract, transform, validate, and analyze data from EDW and other enterprise data sources to support ongoing risk management activities.
• Develop, maintain, and optimize complex SQL queries to support recurring and ad hoc reporting needs.
• Create and maintain data pipelines and processes that improve efficiency, scalability, and data quality.
• Perform data quality checks, reconciliations, and validation routines to ensure reporting accuracy and consistency.
• Support the production of risk-related reports, dashboards, portfolio analyses, and management information.
Risk Data Management
• Develop an understanding of key banking risk concepts, including credit risk, liquidity risk, market risk, operational risk, and regulatory reporting requirements.
• Partner with risk business stakeholders to translate reporting and analytical requirements into data solutions.
• Document data sourcing methodologies, business rules, data lineage, and reporting processes.
• Identify data anomalies and proactively investigate root causes to ensure data integrity.
Process Improvement & Strategy Support
• Identify opportunities to automate manual processes and improve reporting workflows using SQL, Python, PowerBI, and Tableau and other analytical tools.
• Support strategic initiatives involving risk data architecture, reporting modernization, and operational improvements.
• Recommend innovative approaches to solving business problems and improving data delivery capabilities.
• Contribute to the continuous enhancement of risk reporting frameworks and analytical capabilities.
Collaboration & Communication
• Work closely with Risk, Finance, Technology, Data Management, and Business teams to deliver high-quality solutions.
• Clearly communicate analyses, findings, issues, and recommendations to both technical and non-technical audiences.
• Support project work related to risk data sourcing, reporting enhancements, and regulatory initiatives.
Required Qualifications
• 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.
• Ability to manage multiple priorities and meet deadlines in a fast-paced environment.
• 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 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.
PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals.
PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.
Job Description- Provides financial and regulatory reporting and analyses to maintain adequate controls over the financial and regulatory reporting processes. This role is responsible for running complex business performance, risk, and operational analytics. May develop analytical methods and models to assess market, credit, and/or operational risk of new and existing financial products.
- Leverages business and product expertise to rigorously analyze large datasets, improve risk-adjusted returns, deliver profitable growth, and communicate conclusions. Synthesizes analytical results and develops, recommends, and implements business strategies that improve business and portfolio decisions, assist in managing risk, increase revenues, reduce exposure to losses, meet business goals, and improve performance. Establishes baselines for strategies and tracks actual performance to expectations.
- Applies predictive models, third-party data, and other tools to quantify portfolio risks and develop and execute appropriate segmentation and targeting for acquisition and portfolio strategies. Manages engagements with internal and external information suppliers, ensuring the solution is fit for purpose while maintaining appropriate governance and oversight.
- Works with business, credit, data, and model development partners to design, develop, and monitor test designs and analytical reporting to track and enhance strategies. Designs and enhances standard reporting suites for regular product and portfolio reviews.
- Collaborates with the line of business, Finance, and Risk partners to assess and establish credit risk appetite and to understand its implications, as well as to establish policies and procedures governing the identification, monitoring, and management of risk appetite.
QualificationsSuccessful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.
Preferred SkillsAnalytical Thinking, Credit Risks, Data Analytics, Financial Analysis, Model Development, Operational Risks, Quantitative Models, Risk Appetite
CompetenciesAnalytical Approach, Banking Products, Big Data Management and Analytics, Business Analytics, Credit Risk, Mathematics of Financial Instruments, Operational Risk, Performance Measurement, Predictive Analytics, Pricing Models and Analytics, Regulatory Environment - Financial Services, Risk Management Banking
Work ExperienceRoles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.
EducationBachelors
CertificationsNo Required Certification(s)
LicensesNo Required License(s)
Language AssessmentsNo Required or Preferred Language Assessments
Pay TransparencyBase Salary: $91,000.00 - $202,800.00
Salaries may vary based on geographic location, market data and on individual skills, experience, and education. This role is incentive eligible with the payment based upon company, business and/or individual performance.
Application WindowGenerally, this opening is expected to be posted for two business days from 11/04/2026, although it may be longer with business discretion.
BenefitsPNC offers a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include: 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.
In addition, PNC generally provides the following paid time off, depending on your eligibility: 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.
To learn more about these and other programs, including benefits for full time and part-time employees, visit pncthrive.com.
