Portfolio Analytics and Strategy Analyst Senior - Enterprise Risk

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(n) [position title] within PNC's [name of division] organization, you will be based in [city/state location of position].

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 and Strategy Analyst Senior within PNC's Enterprise Risk organization, you will be based in Pittsburgh, PA / Charlotte, NC / Cleveland, OH / Raleigh, NC / Birmingham, AL / Houston, TX / Dallas, TX / Chicago, IL.

Key Responsibilities & Qualifications include, but not limited to;

• Maintain strong working knowledge of banking data ecosystems, including key systems of record, upstream/downstream data flows, and how data is captured, transformed, and consumed
• Understand relationships across multiple data sources and ensure alignment with business definitions and reporting needs
• Analyze existing applications, code logic, and data pipelines to identify how data is sourced, transformed, and utilized across the organization
• Trace data lineage from source systems through business processes and reporting solutions to document data usage and dependencies

• Demonstrate advanced proficiency in SQL for data extraction, transformation, and performance optimization
• Leverage analytical techniques to explore data, identify trends, and validate outputs across complex datasets
• Working knowledge of Python (or similar language) for automation, data processing, and advanced analytics is a strong plus
• Review and interpret complex queries, stored procedures, views, and ETL processes to determine data sourcing, transformation logic, and business usage
• Ability to deconstruct technical solutions and document data flows, business logic, and system dependencies

• Partner directly with business stakeholders to gather, clarify, and document requirements
• Translate technical findings from code analysis and data discovery efforts into clear business requirements and actionable implementation plans
• Serve as the primary liaison between business teams, data teams, and application development teams to ensure required data elements are successfully integrated into Risk applications
• Lead requirement definition sessions, document functional specifications, and support prioritization of data integration efforts
• Drive onboarding of newly identified data sources into Risk applications and ensure alignment with business and governance requirements

• Independently triage data issues, discrepancies, and system challenges, driving root cause analysis and resolution
• Operate effectively with minimal supervision, demonstrating strong judgment and accountability
• Proactively identify risks, inefficiencies, and opportunities for improvement

• Exhibit curiosity and a willingness to experiment with new tools, techniques, and approaches to problem-solving
• Stay current with emerging data, analytics, and automation technologies and recommend adoption where appropriate

• Highly self-motivated,…