Portfolio Analytics & Strategy Specialist

PNC•Raleigh, NC

1d•$91,000 - $202,800•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 data 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 reliable datasets and reporting, develops and maintains complex queries and data processes, and performs data quality checks and reconciliations. The role also documents sourcing methods, business rules, lineage, and reporting processes; investigates data anomalies; and partners with stakeholders across Risk, Finance, Technology, Data Management, and business teams. The position contributes to process automation, reporting modernization, risk data architecture, and other strategic initiatives. It also supports portfolio and business analytics, risk reporting frameworks, and analytical capabilities. The broader job description includes financial and regulatory reporting, business performance and risk analytics, strategy measurement, portfolio risk analysis, and collaboration with business, credit, data, model development, Finance, and Risk partners to assess risk appetite and monitor strategies.

Requirements

Bachelor’s degree in Finance, Economics, Mathematics, Statistics, Information Systems, Computer Science, or a related field.
At least 5 years of experience within the banking industry.
Ability to manage multiple priorities and meet deadlines in a fast-paced environment.
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 and analyzing data trends.
Experience with Power BI and reporting-based applications.
Working knowledge of Python, Power BI, and Tableau for data analysis, automation, and reporting support.
Strong analytical, problem-solving, and critical-thinking skills.
Excellent attention to detail and commitment to data accuracy.
Candidates must demonstrate the knowledge, skills, and abilities appropriate for the role.
Specific certifications may often be required at this job level, but no certification is required for this position.
No license is required for this position.

Nice To Haves

Analytical thinking.
Credit risk knowledge.
Data analytics.
Financial analysis.
Model development.
Operational risk knowledge.
Quantitative models.
Risk appetite knowledge.
Competencies in analytical approach, 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, the financial services regulatory environment, and banking risk management.

Responsibilities

Serve as a primary data resource for the ROQS team, delivering accurate, timely, and reliable datasets for risk reporting and analytics.
Extract, transform, validate, and analyze data from the Enterprise Data Warehouse and other enterprise sources to support risk management activities.
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 reporting accuracy and consistency.
Support production of risk-related reports, dashboards, portfolio analyses, and management information.
Develop understanding of banking risk concepts, including credit, liquidity, market, and operational risk, and regulatory reporting requirements.
Translate reporting and analytical requirements from risk business stakeholders into data solutions.
Document data sourcing methodologies, business rules, data lineage, and reporting processes.
Identify data anomalies and investigate root causes to ensure 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 involving risk data architecture, reporting modernization, and operational improvements.
Recommend approaches to business problems and improve data delivery capabilities.
Contribute to continuous enhancement 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.
Run complex business performance, risk, and operational analytics and provide financial and regulatory reporting and analyses.
Analyze large datasets and communicate conclusions to improve risk-adjusted returns, profitable growth, risk management, and business and portfolio decisions.
Establish strategy baselines and track actual performance against expectations.
Apply predictive models, third-party data, and other tools to quantify portfolio risks and support segmentation and targeting for acquisition and portfolio strategies.
Manage engagements with internal and external information suppliers while 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.

Benefits

Medical and prescription drug coverage, with a Health Savings Account feature, subject to eligibility.
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.
9 occasional absence days each year, unless otherwise required by law.
Between 15 and 25 vacation days each year, depending on career level and years of service.
Incentive-eligible compensation based on company, business, and/or individual performance.