Portfolio Analytics & Strategy Specialist - Consumer Data Solutions & Analytics

PNC; Pittsburgh (Allegheny County); On-site; USD 120,000 - 160,000; Full time

Job summary

PNC seeks a Portfolio Analytics & Strategy Specialist to lead data-driven decision making and insights across customer-focused initiatives. Based in multiple city options, you will partner with risk, compliance, technology and business teams to deliver actionable insights and ensure regulatory alignment.

The role requires extensive analytics experience, strong SQL/Python skills, and proficiency in Tableau or Power BI to develop dashboards and reporting solutions.

Qualifications

• 5+ years in data analytics, BI, or data-driven decision support.
• Experience presenting complex analytics to senior stakeholders.
• Proven ability to work with cross-functional teams and manage risk-focused initiatives.
• Strong SQL proficiency with data validation and performance optimization.
• Proficient Python for data analysis, manipulation, and reporting automation.
• Experience building dashboards and visualizations in Tableau/Power BI.

Responsibilities

• Lead analytics initiatives supporting business strategy, customer experience, risk management, and operational effectiveness.
• Analyze large consumer datasets to provide actionable insights and recommendations.
• Use sandbox environments to explore, validate, and transform data for insights, reporting, and business recommendations.
• Collaborate with stakeholders to identify opportunities, define analytical requirements, and prioritize initiatives.
• Develop and maintain dashboards, scorecards, and analytical solutions using Python, SQL, Tableau, and Power BI.
• Communicate findings and data-driven recommendations to senior leadership and executives.
• Measure business performance via KPIs, trend analysis, forecasting, and performance monitoring.
• Translate complex technical results into clear business guidance for non-technical audiences.
• Collaborate across Analytics, Technology, Product, Risk, Compliance, Governance, and Operations.
• Support regulatory and risk management initiatives through data analysis and reporting.

Skills

Data analytics

Stakeholder management

Communication

Analytical thinking

Risk management experience

Problem solving

Data storytelling

Cross-functional collaboration

Executive presentation

Tools

SQL

Python

Tableau

Power BI

Job description

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 Consumer Data Solutions & Analytics organization, you will be based in Pittsburgh, or Philadelphia, PA; Cleveland, OH; Wilmington, DE; East Brunswick, NJ; or Tyson's Corner, VA.

Job Overview

The Consumer Data Solutions & Analytics team is seeking a highly motivated and strategic Portfolio Analytics & Strategy Specialist to lead data-driven decision making, business insights generation, and analytical solution development across customer-focused initiatives. This role will leverage advanced analytics, business intelligence, and stakeholder engagement to drive business performance, risk management, regulatory compliance, and customer data strategy.

The ideal candidate brings extensive experience in data analytics, business analytics, stakeholder management, and risk-focused environments, along with strong technical expertise in SQL, Python, and data visualization tools. Experience working with sandbox data environments is a strong plus. This individual will partner with business leaders, risk teams, technology teams, and compliance stakeholders to deliver actionable insights that support strategic business objectives.

Key Responsibilities

• Lead complex analytics initiatives that support business strategy, customer experience, risk management, and operational effectiveness.
• Analyze large and diverse consumer datasets to provide actionable business insights and recommendations.
• Leverage sandbox environments to explore, analyze, validate, and transform large consumer datasets, enabling efficient development of analytical insights, reporting solutions, and business recommendations.
• Partner with business stakeholders to identify opportunities, define analytical requirements, and prioritize initiatives.
• Develop and maintain advanced reporting, dashboards, scorecards, and analytical solutions using Python, SQL, Tableau, and Power BI.
• Communicate analytical findings and data-driven recommendations to senior leadership and executive stakeholders.
• Drive business performance measurement through KPI development, trend analysis, forecasting, and performance monitoring.
• Translate complex technical findings into clear, concise business recommendations for non-technical audiences.
• Collaborate across Analytics, Technology, Product, Risk, Compliance, Governance, and Operations teams.
• Support regulatory, governance, compliance, and risk management initiatives through data analysis and reporting.
• Identify opportunities to automate reporting, improve data quality, and enhance decision-making processes.
• Ensure alignment with enterprise data governance, regulatory requirements, and risk management frameworks.
• Mentor junior analysts and provide guidance on analytical best practices and business intelligence solutions.

Required Experience & Skills

• 5+ years of experience in: Data Analytics, Business Analytics, Business Intelligence, and/or Data-Driven Decision Support.
• Strong experience presenting complex analytical findings to business and executive stakeholders.
• Demonstrated success communicating with cross-functional teams and senior leadership.
• Strong analytical thinking and problem-solving abilities.
• Experience leveraging sandbox data environments to perform data exploration, validation, analysis, and solution development for business and risk management initiatives.
• Experience supporting Risk Management, Governance, Compliance, or Regulatory-focused initiatives.
• Advanced SQL expertise including: Complex Queries, Joins, Aggregations, Subqueries, Data Validation, and Performance Optimization.
• Strong Python programming and coding experience including: Data Analysis, Data Manipulation, Reporting Automation, Data Quality Monitoring, and Predictive Analytics.
• Experience developing dashboards and visualizations using Tableau or Power BI.
• Experience working within customer-focused data environments and consumer data domains.
• Strong presentation, communication, and stakeholder management skills.
• Ability to influence business decisions through analytics and data storytelling.

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 financi