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 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, driven, and comfortable operating in a fast-paced, evolving environment
• Strong communication skills with the ability to clearly articulate technical concepts to non-technical audiences
• Collaborative team player who can influence outcomes and drive initiatives across cross-functional teams
• Detail-oriented with a commitment to data quality, accuracy, and governance

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.

• Provides financial and regulatory reporting and analyses to maintain adequate controls over the financial and regulatory reporting processes. Responsible for running complex business performance, risk and operational analytics. May include the development of analytical methods/models to assess market, credit and/or operational risk of new and existing financial products.
• Leverages business / product expertise to rigorously analyze large datasets, improve risk adjusted returns, deliver profitable growth, and communicate…