Portfolio Analytics & Strategy Specialist - Consumer Data Solutions & Analytics

PNC•Tysons, VA

9d•$91,000 - $202,800•Onsite

About The Position

The Portfolio Analytics & Strategy Specialist works within PNC's Consumer Data Solutions & Analytics organization and is based in one of the listed offices: Pittsburgh or Philadelphia, Pennsylvania; Cleveland, Ohio; Wilmington, Delaware; East Brunswick, New Jersey; or Tyson's Corner, Virginia. The role leads data-driven decision making, business insight generation, and analytical solution development for customer-focused initiatives. It applies advanced analytics, business intelligence, and stakeholder engagement to support business performance, risk management, regulatory compliance, and customer data strategy. The position conducts complex business performance, risk, and operational analytics and provides financial and regulatory reporting. It uses business and product expertise to analyze large datasets, improve risk-adjusted returns, support profitable growth, and communicate findings. The specialist develops and implements business strategies, establishes baselines, and monitors performance. The work also involves predictive models, segmentation and targeting, portfolio risk analysis, reporting design, and collaboration with business, Finance, Risk, data, model development, Technology, Product, Compliance, Governance, and Operations partners. PNC describes itself as an in-office company. The position is incentive eligible, with compensation based on company, business, and/or individual performance. PNC does not provide employment visa sponsorship or participate in STEM OPT for this position.

Requirements

At least 5 years of experience in data analytics, business analytics, business intelligence, and/or data-driven decision support.
Experience presenting complex analytical findings to business and executive stakeholders.
Demonstrated ability to communicate with cross-functional teams and senior leadership.
Strong analytical thinking and problem-solving abilities.
Experience using sandbox data environments for exploration, validation, analysis, and solution development for business and risk management initiatives.
Experience supporting risk management, governance, compliance, or regulatory-focused initiatives.
Advanced SQL skills, 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 with 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.
University or college degree; the posting lists a bachelor's degree. A comparable combination of education, job-specific certifications, and experience, including military service, may be considered in lieu of a degree.
Must meet applicable requirements of Section 19 of the Federal Deposit Insurance Act and, for any registered role, applicable SAFE Act and/or FINRA requirements.

Nice To Haves

Experience with sandbox data environments is described as a strong plus.
Preferred skills include analytical thinking, credit risks, data analytics, financial analysis, model development, operational risks, quantitative models, and risk appetite.
Relevant competencies include banking products, big data management and analytics, business analytics, credit risk, mathematics of financial instruments, operational risk, performance measurement, predictive analytics, pricing models and analytics, financial-services regulatory environment, and banking risk management.

Responsibilities

Lead complex analytics initiatives supporting business strategy, customer experience, risk management, and operational effectiveness.
Analyze large and diverse consumer datasets and provide actionable insights and recommendations.
Use sandbox environments to explore, analyze, validate, and transform consumer datasets for 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.
Develop KPIs and conduct trend analysis, forecasting, and performance monitoring.
Translate technical findings into clear business recommendations for non-technical audiences.
Collaborate with 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.
Align work with enterprise data governance, regulatory requirements, and risk management frameworks.
Mentor junior analysts and provide guidance on analytical practices and business intelligence solutions.
Provide financial and regulatory reporting and analyses to maintain controls over reporting processes.
Develop analytical methods or models to assess market, credit, and/or operational risk for financial products.
Synthesize analytical results and develop, recommend, and implement strategies to improve lending decisions, manage risk, increase revenues, reduce loss exposure, meet business goals, and improve performance.
Establish strategy baselines and track actual performance against expectations.
Apply predictive models, third-party data, and other tools to develop segmentation and targeting for acquisition and portfolio strategies and provide insight into portfolio risk.
Manage engagements with internal and external information suppliers, ensuring solutions are fit for purpose and appropriately governed and overseen.
Work with business, credit, data, and model development partners to design, develop, and monitor test designs and analytical reporting.
Design or enhance standard reporting suites for regular product and portfolio reviews.
Collaborate with line-of-business, Finance, and Risk partners to assess and establish credit risk appetite, understand its implications, and establish policies and procedures for identifying, monitoring, and managing risk appetite.
Assess and manage risks associated with business objectives and activities in accordance with PNC's Enterprise Risk Management Framework.

Benefits

Medical and prescription drug coverage, with a Health Savings Account feature
Dental and vision options
Employee and spouse/child life insurance
Short- and long-term disability protection
401(k) with PNC match
Pension plan
Stock purchase plans
Dependent care reimbursement account
Back-up child and elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select fully paid programs
Wellness program with financial incentives
Maternity and/or parental leave
Up to 11 paid holidays each year
9 occasional absence days each year, unless otherwise required by law
15 to 25 vacation days each year, depending on career level and years of service
Incentive-eligible compensation based on company, business, and/or individual performance