Portfolio Analyst and Strategy Specialist

Job ID: R229622Posted: 2026-07-22Location: OH - Cleveland (44114); NC - Raleigh; PA - Pittsburgh; CO - Denver (80005); NC - Charlotte; TX - HoustonSalary: $91,000.00 - $202,800.00Type: Full timeCountry: United States of AmericaCompany: PNCPosition OverviewAt 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 Analyst and Strategy Specialist within PNC's Risk Operations & Quantitative Strategy organization, you will be based in Pittsburgh, PA / Cleveland, OH / Charlotte, NC / Raleigh, NC / Houston, TX / Denver, CO.We are seeking a highly motivated Portfolio Analyst & Strategy Specialist to support critical regulatory reporting, risk management, data provisioning, and strategic automation initiatives across the organization. This individual will play a key role in automating risk metrics, streamlining manual processes, and delivering high-quality data solutions that improve operational efficiency, reporting accuracy, and business decision-making.The ideal candidate possesses advanced SQL and Python skills, a strong understanding of PNC's data ecosystem, and the ability to navigate and analyze data across multiple platforms throughout the bank. This role requires a combination of technical expertise, analytical curiosity, strategic thinking, and business partnership skills to support regulatory reporting needs, including Prudential Regulation initiatives, while driving continuous process improvement and innovation.Key Responsibilities· Support data provisioning, portfolio analysis, and automation efforts for regulatory reporting initiatives, including Prudential Regulation and other enterprise reporting requirements.· Design, develop, and maintain automated solutions that improve the efficiency, accuracy, and scalability of risk metric calculations, portfolio monitoring, and reporting processes.· Leverage advanced SQL skills to source, transform, validate, and analyze large and complex datasets across multiple banking data platforms.· Develop and maintain Python-based automation, analytical models, and reporting solutions that reduce manual effort and enhance operational effectiveness.· Build a deep understanding of data lineage, data quality, and business definitions across various systems and platforms within the bank.· Create and maintain Business Intelligence solutions, dashboards, and reporting capabilities using Power BI, Power BI Publisher, and Tableau.· Partner with business stakeholders to develop insightful visualizations and reporting solutions that support risk management, regulatory compliance, portfolio management, and strategic decision-making.· Research, analyze, and resolve complex data issues while ensuring the integrity, consistency, and accuracy of reporting outputs.· Collaborate closely with Risk, Finance, Regulatory Reporting, Technology, Data Management, and business partners to gather requirements and deliver actionable data-driven solutions.· Identify opportunities to simplify, standardize, and modernize existing processes through automation, analytics, and innovative approaches.· Support the development of controls, documentation, and validation procedures for regulatory and risk-related reporting processes.· Conduct ad hoc analyses, data investigations, and strategic research to support business initiatives and executive management requests.· Manage multiple priorities while delivering high-quality results under tight deadlines and evolving business requirements.Qualifications required; · Advanced proficiency in SQL, including complex query development, data manipulation, performance optimization, and troubleshooting.· Strong proficiency in Python for data analysis, automation, process improvement, and reporting solutions.· Experience working with large-scale enterprise data environments and multiple data platforms.· Strong familiarity with PNC's data ecosystem, key data repositories, and enterprise data architecture.· Experience developing dashboards, reports, and visual analytics using Power BI, Power BI Publisher, and Tableau.· Strong analytical, problem-solving, data research, and data validation skills.· Ability to understand and interpret data across diverse systems and platforms within a complex banking environment.· Experience supporting risk management, regulatory reporting, finance, portfolio management, or governance functions.· Strong communication and relationship management skills with the ability to effectively engage business and technology stakeholders.· Demonstrated ability to work effectively under tight deadlines and manage competing priorities.· Proven ability to challenge existing processes and recommend innovative, efficient solutions.· Self-motivated with a passion for data analysis, research, and continuous learning.Preferred skills; · Experience supporting Prudential Regulation reporting or other regulatory reporting programs.· Knowledge of banking risk management concepts, methodologies, and regulatory requirements.· Experience with data governance, data lineage, metadata management, and data quality frameworks.· Familiarity with cloud-based data platforms and modern data engineering practices.· Experience creating executive-level dashboards and management reporting packages.· Knowledge of risk metrics, balance sheet reporting, capital, liquidity, stress testing, or portfolio management frameworks.Success FactorsThe successful candidate will:· Be passionate about data analysis, research, and uncovering insights from complex datasets.· Continuously seek opportunities to automate manual processes and improve operational efficiency.· Leverage technical expertise to deliver innovative reporting, analytics, and visualization solutions.· Build strong relationships and effectively communicate with business and technology partners.· Thrive in a fast-paced environment that requires adaptability, accountability, and attention to detail.· Embrace new ideas, technologies, and ways of working to drive continuous improvement and strategic value.· Deliver high-quality, accurate results while balancing multiple priorities and challenging deadlines.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 DescriptionProvides 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 conclusions. Synthesizes analytical results and develops, recommends, and implements business strategies that improve lending decisions, assist in managing risk, increase revenues, reduce exposure to losses, meet business goals, and improve performance. Establishes baselines for strategies and tracks actual performance to expectations.Applies predictive models, third party data, and other tools to develop and execute appropriate segmentation and targeting for acquisition and portfolio strategies to provide insight into portfolio risk. Manages engagements with internal and external information suppliers ensuring solution is fit for purpose while maintaining appropriate governance and oversight.Works with business, credit, data, and model development partners to design, develop, and monitor test designs and analytical reporting to track and enhance strategies. Designs / enhances standard reporting suites for regular product / portfolio reviews.Collaborates with the line of business, Finance, and Risk partners to assess and establish credit risk appetite and to understand its implications, as well as to establish policies and procedures governing the identification, monitoring, and management of risk appetite.PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.QualificationsSuccessful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.Preferred SkillsAnalytical Thinking, Credit Risks, Data Analytics, Financial Analysis, Model Development, Operational Risks, Quantitative Models, Risk AppetiteCompetenciesAnalytical 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, Regulatory Environment - Financial Services, Risk Management BankingWork ExperienceRoles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.EducationBachelorsCertificationsNo Required Certification(s)LicensesNo Required License(s)Pay TransparencyBase Salary: $91,000.00 – $202,800.00Salaries may vary based on geographic location, market data and on individual skills, experience, and education. This role is incentive eligible with the payment based upon company, business and/or individual performance.Application WindowGenerally, this opening is expected to be posted for two business days from 07/21/2026, although it may be longer with business discretion.BenefitsPNC offers a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include: medical/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 and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption, surrogacy, and doula reimbursement; educational assistance, including select programs fully paid; a robust wellness program with financial incentives.In addition, PNC generally provides the following paid time off, depending on your eligibility: maternity and/or parental leave; up to 11 paid holidays each year; 9 occasional absence days each year, unless otherwise required by law; between 15 to 25 vacation days each year, depending on career level; and years of service.To learn more about these and other programs, including benefits for full time and part-time employees, visit pncthrive.com.Disability Accommodations StatementIf an accommodation is required to participate in the application process, please contact us via email at View email address on click.appcast.io. Please include “accommodation request” in the subject line title and be sure to include your name, the job ID, and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses. Applicants may also call View phone number on click.appcast.io and say "Workday" for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. At PNC we foster an inclusive and accessible workplace. We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.Equal Employment Opportunity (EEO)PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.California Residents Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.