Strategic Portfolio Analytics Senior Analyst

PNC Financial Services Group, Inc.; Northern (KY); Hybrid; USD 86,000 - 158,000; Full time

Job summary

PNC Financial Services Group, Inc. is seeking a Sr Portfolio Analytics & Strategy Analyst to lead data requirements, provisioning and quality across risk and portfolio analytics.

Based in Cleveland, OH, Pittsburgh, PA or Dallas, TX, you will partner with business, data, and technology teams to source assets, document lineage, and implement enhanced data solutions. You will leverage SQL, Teradata, Hadoop and Python to develop analytical methods, validate data, and support regulatory reporting.

Qualifications

• University degree required with 3+ years of relevant industry experience.
• Strong SQL skills and experience validating and reconciling large datasets.
• Experience provisioning data for risk, finance, CECL, stress testing, or portfolio analytics.

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 tech teams to implement enhancements and support deployments.
• Document data lineage, business rules and mapping specifications.
• Manage Jira work items and perform data validation and quality assessments.
• Identify opportunities to automate processes and improve efficiency.
• Participate in testing and validation to ensure data solutions meet requirements.

Skills

Analytical Thinking

Data Governance

Stakeholder Management

Technical Documentation

Risk Management

Education

Bachelor's Degree

Tools

Jira

SQL

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 quality across risk and portfolio analytics.

Based in Cleveland, OH, Pittsburgh, PA or Dallas, TX, you will partner with business, data, and technology teams to source assets, document lineage, and implement enhanced data solutions. You will leverage SQL, Teradata, Hadoop and Python to develop analytical methods, validate data, and support regulatory reporting.