Portfolio Risk Analytics Strategist

PNC

Pittsburgh (Allegheny County)

On-site

USD 91,000 - 203,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
401(k) with match
Paid holidays
Dental and vision coverage
Parental leave

Job summary

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.

Responsibilities

  • 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.

Skills

Advanced SQL
Python
Power BI
Tableau
Banking knowledge
Risk management

Education

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

Tools

EDW
SQL Development Tools

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Portfolio Risk Analytics & Strategy Lead
Portfolio Risk Analytics & Strategy Lead

PNC • Charlotte (NC)

On-site
USD 91,000 - 203,000
Portfolio Analytics & Strategy Architect
Portfolio Analytics & Strategy Architect

PNC Financial Services • Raleigh (NC)

Hybrid
USD 91,000 - 203,000
Medical benefits
401(k) with match
Paid time off
Senior Portfolio Analytics & Risk Strategy Lead
Senior Portfolio Analytics & Risk Strategy Lead

PNC • Birmingham (AL)

On-site
USD 86,000 - 173,000
Senior Portfolio Analytics & Strategy Analyst
Senior Portfolio Analytics & Strategy Analyst

PNC • Pittsburgh

On-site
USD 86,000 - 173,000
Portfolio Analytics & Strategy Architect
Portfolio Analytics & Strategy Architect

PNC • Pittsburgh

On-site
USD 86,250 - 158,125
Senior Portfolio Analytics & Risk Strategy Lead
Senior Portfolio Analytics & Risk Strategy Lead

Habitat For Humanity Of Durham • Raleigh (NC)

On-site
USD 86,000 - 173,000
Enterprise Risk Analytics Consultant — Data & BI Solutions
Enterprise Risk Analytics Consultant — Data & BI Solutions

PNC Business Credit • Charlotte (NC), Raleigh (NC), Pittsburgh, Cleveland (OH)

On-site
USD 64,000 - 117,000
Medical/dental/vision benefits
401(k) with company match
Paid time off
Senior Portfolio Analytics & Strategy Lead
Senior Portfolio Analytics & Strategy Lead

PNC • United States

On-site
USD 40,000 - 173,000
Medical/prescription coverage
Dental and vision options
401(k) with PNC match
+1
Strategic Portfolio Analytics Lead
Strategic Portfolio Analytics Lead

PNC • Pittsburgh

On-site
USD 91,000 - 203,000
Portfolio Analytics & Strategy Architect
Portfolio Analytics & Strategy Architect

PNC • Portage (MI)

On-site
USD 91,000 - 202,800
Medical coverage
401(k) with match
Paid holidays