Portfolio Analytics & Strategy Specialist

PNC Bank NA; Pittsburgh (Allegheny County); Sur place; USD 91 000 - 203 000; Plein temps

Avantages offerts par ce poste

Health insurance

401(k) with match

Paid holidays

Dental and vision coverage

Parental leave

Résumé du poste

PNC is seeking a Portfolio Analytics & Strategy Specialist to support the ROQS team with risk data provisioning, transformation, and analysis. The role will source data from the EDW and internal systems to enable regulatory reporting, risk management, and portfolio insights.

The ideal candidate has banking risk knowledge, strong SQL, and experience with Python, Power BI and Tableau. This in-office position spans Pittsburgh, Brecksville, Charlotte, Houston and Raleigh, offering visibility across

Qualifications

• Bachelor's degree in Finance, Economics, Mathematics, Statistics, Information Systems, Computer Science, or related field.
• Minimum 5 years of banking industry experience.
• Advanced SQL skills with experience querying large data warehouses.
• Experience with Power BI and Tableau for reporting.
• Strong analytical, problem-solving, and attention to detail.

Responsabilités

• Serve as primary data resource for ROQS, delivering accurate risk datasets.
• Extract, transform, validate, and analyze data from EDW and other sources.
• Develop, maintain, and optimize complex SQL queries.
• Create and maintain data pipelines and processes to improve efficiency.
• Perform data quality checks and validation to ensure accuracy.
• Support production of risk reports, dashboards, and analyses.

Connaissances

Advanced SQL

Python

Power BI

Tableau

Banking knowledge

Risk management

Formation

Bachelor's degree in Finance, Economics, Mathematics, Statistics, Information Systems, Computer Science, or related field

Outils

EDW

SQL Development Tools

Description du poste

Position Overview

Position Overview 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 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. 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. PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be: Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions. Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

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.

Preferred Skills

• Analytical Thinking
• Credit Risks
• Data Analytics
• Financial Analysis
• Model Development
• Operational Risks
• Quantitative Models
• Risk Appetite Competencies

Preferred Competencies

• Analytical 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 Experience
• Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience.
• Specific certifications are often required.

Education

Bachelors Certifications No Required Certification(s) Licenses No Required License(s) Language Assessments No Required or Preferred Language Assessments

Pay Transparency

Base 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 Window

Generally, this opening is expected to be posted for two business days from 11/04/2026, although it may be longer with business discretion.

Benefits

Benefits PNC 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
• 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

To learn more about these and other programs, including benefits for full time and part-time employees, visit pncthrive.com.

Disability Accommodations Statement

If an accommodation is required to participate in the application process, please contact us via email at [e-mail]. Please include "accommodation request" in the subject line title and be sure to include your name, the job ID, and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses. Applicants may also call 877-968-7762 and say "Workday" for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. At PNC we foster an inclusive and accessible workplace. We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.

Equal Employment Opportunity (EEO)

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law. This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.