Senior Investment Data & Analytics Lead

PNC; Pittsburgh (Allegheny County); On-site; USD 140,000 - 190,000; Full time

Job summary

PNC is seeking a Business Analytics Lead Senior to drive the development of a centralized investment data warehouse and scalable data architecture in a multi-city footprint (Pittsburgh, Philadelphia, Cleveland, Tyson's Corner, DC). You will oversee data pipelines, governance, and data products powering executive decisions.

The role requires deep experience in investment management data, enterprise data platforms, API development, and analytics visualization tools.

Qualifications

• Experience in Investment Management or Financial Services data ecosystems.
• Deep understanding of the investment lifecycle and data governance.
• Proven ability to design and manage enterprise-scale data warehouses and platforms.

Responsibilities

• Lead development of centralized investment data warehouse as a single source of truth.
• Design scalable data architecture with governance, quality, lineage and lifecycle management.
• Build data pipelines for ingestion, transformation and distribution from multiple sources.
• Develop analytical solutions for senior leadership to enable data-driven decisions.
• Partner with Technology on data rollouts (asset master, portfolio, risk, ESG).
• Translate business requirements into reusable data models and data products for enterprise use.
• Lead data-driven apps, APIs, and front-ends for analytics and automation.
• Identify and adopt emerging tech (AI/ML, modern data platforms) to enhance capabilities.

Skills

Investment data platforms

SQL

Python

PySpark

AI/ML

Tableau/Power BI

Executive messaging

Education

Bachelor's degree in CS/IT/Data Science/Engineering/Finance/Business

Master's degree in CS/IT/Data Science/Engineering/Finance/Business

Associate's degree + 10+ years of experience

PhD in CS/IT/Data Science/Engineering/Finance/Business

No Degree + 12+ years data experience

Tools

Oracle

Hadoop

Teradata

Trino

Apache Iceberg

Databricks

Azure/AWS data platforms

Job description

PNC is seeking a Business Analytics Lead Senior to drive the development of a centralized investment data warehouse and scalable data architecture in a multi-city footprint (Pittsburgh, Philadelphia, Cleveland, Tyson's Corner, DC). You will oversee data pipelines, governance, and data products powering executive decisions.

The role requires deep experience in investment management data, enterprise data platforms, API development, and analytics visualization tools.