Portfolio Analyst and Strategy Specialist

** 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 Analyst and Strategy Specialist within PNC's Risk Operations & Quantitative Strategy organization, you will be based in Pittsburgh, PA / Cleveland, OH / Charlotte, NC / Raleigh, NC / Houston, TX / Denver, CO.

We are seeking a highly motivated Portfolio Analyst & Strategy Specialist to support critical regulatory reporting, risk management, data provisioning, and strategic automation initiatives across the organization. This individual will play a key role in automating risk metrics, streamlining manual processes, and delivering high-quality data solutions that improve operational efficiency, reporting accuracy, and business decision-making.

The ideal candidate possesses advanced SQL and Python skills, a strong understanding of PNC's data ecosystem, and the ability to navigate and analyze data across multiple platforms throughout the bank. This role requires a combination of technical expertise, analytical curiosity, strategic thinking, and business partnership skills to support regulatory reporting needs, including Prudential Regulation initiatives, while driving continuous process improvement and innovation.

Key Responsibilities

· Support data provisioning, portfolio analysis, and automation efforts for regulatory reporting initiatives, including Prudential Regulation and other enterprise reporting requirements.

· Design, develop, and maintain automated solutions that improve the efficiency, accuracy, and scalability of risk metric calculations, portfolio monitoring, and reporting processes.

· Leverage advanced SQL skills to source, transform, validate, and analyze large and complex datasets across multiple banking data platforms.

· Develop and maintain Python-based automation, analytical models, and reporting solutions that reduce manual effort and enhance operational effectiveness.

· Build a deep understanding of data lineage, data quality, and business definitions across various systems and platforms within the bank.

· Create and maintain Business Intelligence solutions, dashboards, and reporting capabilities using Power BI, Power BI Publisher, and Tableau.

· Partner with business stakeholders to develop insightful visualizations and reporting solutions that support risk management, regulatory compliance, portfolio management, and strategic decision-making.

· Research, analyze, and resolve complex data issues while ensuring the integrity, consistency, and accuracy of reporting outputs.

· Collaborate closely with Risk, Finance, Regulatory Reporting, Technology, Data Management, and business partners to gather requirements and deliver actionable data-driven solutions.

· Identify opportunities to simplify, standardize, and modernize existing processes through automation, analytics, and innovative approaches.

· Support the development of controls, documentation, and validation procedures for regulatory and risk-related reporting processes.

· Conduct ad hoc analyses, data investigations, and strategic research to support business initiatives and executive management requests.

· Manage multiple priorities while delivering high-quality results under tight deadlines and evolving business requirements.

Qualifications required;

· Advanced proficiency in SQL, including complex query development, data manipulation, performance optimization, and troubleshooting.

· Strong proficiency in Python for data analysis, automation, process improvement, and reporting solutions.

· Experience working with large-scale enterprise data environments and multiple data platforms.

· Strong familiarity with PNC's data ecosystem, key data repositories, and enterprise data architecture.

· Experience developing dashboards, reports, and visual analytics using Power BI, Power BI Publisher, and Tableau.

· Strong analytical, problem-solving, data research, and…