Portfolio Analytics & Strategy Specialist

PA - Pittsburgh (15222)

OH - Brecksville

NC - Charlotte (28210)

NC - Raleigh (27601)

TX - Houston

Full time

R238936

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

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.

R…