Portfolio Analytics & 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 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. 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. 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