Senior Portfolio Insights & Strategy Analyst

PNC Financial Services Group, Inc.; Pennsylvania; On-site; USD 86,000 - 158,000; Full time

Benefits offered by this job

Medical/dental/vision coverage

401(k) with PNC match

Pension and stock purchase plans

Educational assistance

Job summary

PNC Financial Services Group, Inc. is seeking a Sr Portfolio Analytics & Strategy Analyst to lead data requirements, provisioning, and governance. You will work with data, business, and technology partners to source assets, ensure quality, and deliver solutions aligned with standards.

The role supports risk, finance and portfolio analytics with a strong SQL and data warehouse emphasis. The position offers locations in Cleveland, OH; Pittsburgh, PA; or Dallas, TX, with a comprehensive benefits

Qualifications

• University degree required with 3+ years of relevant experience.
• Strong SQL skills and experience validating large datasets.
• Experience with enterprise data warehouses and distributed environments.
• Ability to translate business requirements into scalable data solutions.
• Experience partnering with business and technology teams across the data lifecycle.

Responsibilities

• Translate data requirements into provisioning solutions with cross‑functional teams.
• Develop, test and document prototype logic for new data attributes and remediation.
• Collaborate with technology to implement enhancements and support deployments.
• Document data lineage, rules and mappings; manage Jira items and data validation.
• Identify automation opportunities to improve operational efficiency.
• Design and monitor analytics reporting to track portfolio strategies.

Skills

SQL

Data analysis

Data modeling

Communication

Problem solving

Education

Bachelor’s Degree

Tools

Jira

Teradata

Hadoop

Python

Pandas

PySpark

Job description

PNC Financial Services Group, Inc. is seeking a Sr Portfolio Analytics & Strategy Analyst to lead data requirements, provisioning, and governance. You will work with data, business, and technology partners to source assets, ensure quality, and deliver solutions aligned with standards.

The role supports risk, finance and portfolio analytics with a strong SQL and data warehouse emphasis. The position offers locations in Cleveland, OH; Pittsburgh, PA; or Dallas, TX, with a comprehensive benefits