Portfolio Analytics & Strategy Specialist - Consumer Data Solutions & Analytics
PNC Financial Services Group, Inc.
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
PNC Financial Services Group, Inc. seeks a Portfolio Analytics & Strategy Specialist to lead data-driven decision making across consumer data solutions.
Based in Pittsburgh, Philadelphia, PA; Cleveland, OH; Wilmington, DE; East Brunswick, NJ; or Tyson's Corner, VA, you will partner with risk, technology, and business leaders to deliver insights that influence strategic decisions. You will develop advanced reporting, dashboards, and analytics using Python, SQL, Tableau, and Power BI, guiding
Qualifications
- 5+ years of experience in Data Analytics, Business Analytics, BI, or Data-Driven Decision Support.
- Strong track record presenting complex analytics to executives and stakeholders.
- Experience with sandbox data environments and cross-functional collaboration.
- Experience in Risk Management, Governance, Compliance, or Regulatory initiatives is preferred.
- Advanced SQL with complex queries and performance optimization.
- Strong Python skills for data analysis, manipulation, and automation.
- Experience building dashboards with Tableau or Power BI.
Responsibilities
- Lead analytics initiatives that support business strategy, customer experience, risk management, and operational effectiveness.
- Analyze large consumer datasets to provide actionable insights and recommendations.
- Leverage sandbox environments to develop analytical insights, reporting solutions, and business recommendations.
- Partner with stakeholders to define requirements and prioritize initiatives.
- Develop and maintain dashboards, scorecards, and analytical solutions using Python, SQL, Tableau, and Power BI.
- Communicate findings to senior leadership and executives.
- Drive KPI development, forecasting, and performance monitoring.
- Translate technical findings into clear business recommendations 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.
- Identify opportunities to automate reporting and improve data quality.
Skills
Education
Tools
Job description
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(n) [position title] within PNC's [name of division] organization, you will be based in [city/state location of position].
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.
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.
- 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.
- 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.
- Provides 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.
Successful 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.
Analytical Thinking, Credit Risks, Data Analytics, Financial Analysis, Model Development, Operational Risks, Quantitative Models, Risk Appetite
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, Regulatory Environment - Financial Services, Risk Management Banking
Roles 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.
Bachelors
No Required Certification(s)
No Required License(s)
No Required or Preferred Language Assessments
Base Salary: $91,000.00 - $202,800.00
Salaries 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.
Generally, this opening is expected to be posted for two business days from 07/30/2026, although it may be longer with business discretion.
PNC 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.
If an accommodation is required to participate in the application process, please contact us via email at AccommodationRequest@pnc.com. 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 877-968-7762 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.
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.
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
