Portfolio Analytics & Strategy Specialist

PNC Bank•Pittsburgh, PA

1d•Onsite

About The Position

The Portfolio Analytics & Strategy Specialist supports PNC’s Risk Operations & Quantitative Strategy (ROQS) team by provisioning, transforming, and analyzing risk-related data. The role sources information from the Enterprise Data Warehouse and other internal banking systems to support regulatory reporting, risk management, portfolio monitoring, and executive reporting. It requires banking and risk management knowledge, advanced SQL skills, and working knowledge of Python, Power BI, and Tableau. The position is based in Pittsburgh, Pennsylvania; Brecksville, Ohio; Charlotte, North Carolina; Houston, Texas; or Raleigh, North Carolina, and PNC describes itself as an in-office company. The specialist provides accurate and timely datasets, develops and optimizes SQL queries and data processes, performs data quality checks and reconciliations, and supports risk reports, dashboards, portfolio analyses, and management information. The role partners with business, risk, finance, technology, and data stakeholders to turn analytical and reporting needs into data solutions; documents sourcing methods, business rules, lineage, and processes; investigates anomalies; and helps automate workflows and modernize reporting. The broader role description includes financial and regulatory reporting, complex business performance, risk, and operational analytics, and analysis of large datasets to improve risk-adjusted returns and portfolio decisions. The specialist may contribute to analytical methods and models, strategy development and performance tracking, portfolio risk quantification, segmentation and targeting, reporting-suite improvements, and work to establish and monitor credit risk appetite. The position is incentive eligible. PNC will not provide employment visa sponsorship or participate in STEM OPT for this position.

Requirements

Bachelor’s degree in Finance, Economics, Mathematics, Statistics, Information Systems, Computer Science, or a related field; the broader qualifications section lists a bachelor’s degree and allows a comparable combination of education, job-specific certifications, and experience in lieu of a degree.
At least 5 years of experience within the banking industry; the broader work-experience section specifies 5+ years of industry-relevant experience.
Demonstrated understanding of banking and risk management data concepts.
Advanced SQL skills, including experience querying and understanding large-scale data warehouses and relational databases.
Experience sourcing and manipulating data.
Experience reporting on and analyzing 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.
Ability to manage multiple priorities and meet deadlines in a fast-paced environment.
Strong analytical, problem-solving, and critical-thinking skills.
Excellent attention to detail and commitment to data accuracy.
Customer focus and ability to use customer needs and satisfaction considerations in business decisions and customized solutions.
Ability to assess and manage risks associated with business objectives and activities.

Nice To Haves

Analytical thinking.
Credit risk knowledge.
Data analytics.
Financial analysis.
Model development.
Operational risk knowledge.
Quantitative models.
Risk appetite knowledge.
Knowledge of banking products, big data management and analytics, business analytics, mathematics of financial instruments, performance measurement, predictive analytics, pricing models and analytics, and the financial-services regulatory environment.

Responsibilities

Deliver accurate, timely, and reliable datasets for ROQS risk reporting and analytics.
Extract, transform, validate, and analyze data from the Enterprise Data Warehouse and other enterprise data sources.
Develop, maintain, and optimize complex SQL queries for recurring and ad hoc reporting.
Create and maintain data pipelines and processes to improve efficiency, scalability, and data quality.
Perform data quality checks, reconciliations, and validation routines to ensure accurate and consistent reporting.
Support the production of risk reports, dashboards, portfolio analyses, and management information.
Build understanding of banking risk concepts, including credit, liquidity, market, and operational risk, and regulatory reporting requirements.
Partner with risk business stakeholders to translate analytical and reporting requirements into data solutions.
Document data sourcing methods, business rules, data lineage, and reporting processes.
Identify data anomalies and investigate root causes to maintain data integrity.
Identify opportunities to automate manual processes and improve reporting workflows using SQL, Python, Power BI, Tableau, and other analytical tools.
Support strategic initiatives concerning risk data architecture, reporting modernization, and operational improvements.
Recommend approaches to business problems and improvements to data delivery capabilities.
Contribute to the continuous improvement of risk reporting frameworks and analytical capabilities.
Collaborate with Risk, Finance, Technology, Data Management, and Business teams to deliver solutions.
Communicate analyses, findings, issues, and recommendations to technical and non-technical audiences.
Support projects involving risk data sourcing, reporting enhancements, and regulatory initiatives.
Provide financial and regulatory reporting and analyses to maintain controls over reporting processes.
Run complex business performance, risk, and operational analytics; analyze large datasets and communicate conclusions.
Develop, recommend, and implement strategies to improve portfolio and business decisions, manage risk, increase revenues, reduce loss exposure, meet goals, and improve performance.
Establish strategy baselines and track actual results against expectations.
Use predictive models, third-party data, and other tools to quantify portfolio risks and develop segmentation and targeting for acquisition and portfolio strategies.
Manage engagements with internal and external information suppliers, ensuring solutions are fit for purpose and appropriately governed.
Work with business, credit, data, and model development partners to design, develop, and monitor test designs and analytical reporting.
Design and 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 and related policies and procedures.
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, including 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 and 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, depending on eligibility.
Up to 11 paid holidays each year, depending on eligibility.
Nine 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.