Portfolio Analytics & Strategy Architect

PNC Financial Services

Raleigh (NC)

Hybrid

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

Medical benefits
401(k) with match
Paid time off

Job summary

PNC is seeking a Portfolio Analytics & Strategy Specialist to support ROQS with data provisioning, transformation and risk analytics. You will source data from EDW and internal systems to support regulatory, risk, and portfolio reporting needs.

The ideal candidate has strong banking/risk management knowledge, advanced SQL, and experience with Python, Power BI and Tableau. Collaboration with risk, finance, and technology teams is essential.

Qualifications

  • Bachelor's degree in Finance, Economics, Math, Statistics, IS, CS, or related field.
  • Minimum 5 years of experience within the banking industry.
  • Advanced SQL with large-scale data warehouses.
  • Experience sourcing and manipulating data.
  • Experience in reporting and data trend analysis.
  • Working knowledge of Python, Power BI and Tableau for data analysis.

Responsibilities

  • Provide data resources for risk reporting and analytics.
  • Extract, transform, and analyze data from EDW and other sources.
  • Develop and optimize complex SQL queries for reporting needs.
  • Create and maintain data pipelines and data quality checks.
  • Support production of risk reports, dashboards, and analyses.

Skills

Advanced SQL
Python
Data analysis
Risk concepts
Sourcing data
Reporting

Education

Bachelor's degree

Tools

Power BI
Tableau

Job description

PNC is seeking a Portfolio Analytics & Strategy Specialist to support ROQS with data provisioning, transformation and risk analytics. You will source data from EDW and internal systems to support regulatory, risk, and portfolio reporting needs.

The ideal candidate has strong banking/risk management knowledge, advanced SQL, and experience with Python, Power BI and Tableau. Collaboration with risk, finance, and technology teams is essential.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Portfolio Risk Analytics Strategist
Portfolio Risk Analytics Strategist

PNC • Pittsburgh

On-site
USD 91,000 - 203,000
Health insurance
401(k) with match
Paid holidays
+2
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 • Pittsburgh

On-site
USD 86,250 - 158,125
Portfolio Analytics & Strategy Architect
Portfolio Analytics & Strategy Architect

PNC • Pittsburgh

On-site
USD 90,000 - 120,000
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
Strategic Portfolio Analytics Lead
Strategic Portfolio Analytics Lead

PNC • Pittsburgh

On-site
USD 91,000 - 203,000
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
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
Portfolio Analytics & Strategy Specialist
Portfolio Analytics & Strategy Specialist

PNC Bank NA • Pittsburgh

On-site
USD 91,000 - 203,000
Health insurance
401(k) with match
Paid holidays
+2