Senior Portfolio Analytics & Strategy Analyst

PNC; Pittsburgh (Allegheny County); On-site; USD 110,000 - 170,000; Full time

Job summary

PNC is seeking a Portfolio Analytics & Strategy Analyst Senior in Pittsburgh, PA to design data pipelines, model outcomes, and deliver actionable analytics for risk and portfolio decisions. You will work across business, credit, data, and IT teams, using Python, SQL, dashboards, and cloud platforms in an Agile setting.

The role emphasizes governance, testing, and communicating complex results to stakeholders while contributing to strategic initiatives and reporting accuracy.

Qualifications

• Design and develop data pipelines and analytics using Python, Hadoop, and Spark (PySpark).
• Proficient SQL with complex joins, window functions, performance tuning, and data quality validation.
• Experience designing dashboards with Tableau/Power BI/Elastic Stack.
• Experience with cloud-based data platforms and distributed systems.
• Configure and maintain business rules engines like FICO PowerCurve or Experian.
• Develop, test, and maintain APIs.
• Active participation in Agile ceremonies and sprints.
• Work with Swagger, Kafka schemas, JSON Schema, XML, and XSD.
• Experience testing services with Postman/SoapUI.
• Familiar with CI/CD tools like Jenkins, Git, Bitbucket, Jira, Confluence.
• Perform data validation pre- and post-deployment using Hadoop and monitoring tools.
• Able to communicate technical results clearly to business and cross-functional stakeholders.

Responsibilities

• Provide financial and regulatory analytics to support reporting controls and risk assessment.
• Leverage domain knowledge to analyze large datasets, improve risk-adjusted returns, and communicate actionable insights.
• Apply predictive models and external data to drive portfolio strategies and risk management.
• Collaborate with business, credit, data, and model development teams to design and monitor tests and reporting.
• Create and enhance standard reporting suites for regular product and portfolio reviews.
• Partner with Finance and Risk to set risk appetite and governance policies.

Skills

Python

SQL

Analytics

APIs

Agile

Data validation

Postman/SoapUI

CI/CD

Swagger/Kafka/JSON

Education

Bachelors

Tools

Tableau

Power BI

Elastic Stack

FICO Decision Modeler

Experian PowerCurve

Jenkins

Git

Bitbucket

Jira

Confluence

Postman

SoapUI

Swagger

Kafka schemas

Job description

PNC is seeking a Portfolio Analytics & Strategy Analyst Senior in Pittsburgh, PA to design data pipelines, model outcomes, and deliver actionable analytics for risk and portfolio decisions. You will work across business, credit, data, and IT teams, using Python, SQL, dashboards, and cloud platforms in an Agile setting.

The role emphasizes governance, testing, and communicating complex results to stakeholders while contributing to strategic initiatives and reporting accuracy.