Business Analytics Lead Senior - Investment Data & Innovations

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

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 Business Analytics Lead Senior within PNC's Investment Data and Innovation organization, you will be based in Pittsburgh, or Philadelphia, PA; Cleveland, OH; Tyson's Corner, VA; or Washington, D.C.

Key Responsibilities:

• Lead the development of a centralized investment data warehouse, delivering a governed single source of truth for investment data that supports multiple functions or business units
• Design and implement scalable data architecture ensuring strong data governance, quality, lineage, and lifecycle management across the investment data warehouse
• Build and oversee data pipelines supporting ingestion, transformation, and distribution from internal and external sources
• Conceptualizing, developing and continuously optimizing analytical solutions for business leadership to enable more complex, data driven decision making
• Partner with Technology teams on domain-based data rollouts (e.g., asset master, portfolio, risk, ESG) aligned to business priorities
• Influence business requirements into reusable data models and data products enabling enterprise consumption
• Lead development of data-driven applications, APIs, and user interfaces to support analytics and workflow automation
• Identify and implement emerging technologies (AI/ML, advanced analytics, modern data platforms) to enhance capabilities

Required Qualifications & Skills:

• Experience with Investment Management, Asset Management, Wealth Management, or Financial Services environments.
• Deep understanding of the full investment lifecycle, including investment research, due diligence, portfolio management, performance measurement, risk management, reporting, and data governance.
• Proven experience designing, implementing, and managing enterprise-scale data warehouses and investment data platforms.
• Expertise in Oracle Database Management and Oracle-based data warehousing environments.
• Strong experience with Hadoop and/or modern big data technologies including Teradata, Trino, Apache Iceberg, or similar platforms.
• Experience with Data Domain Management, master data management, metadata management, and enterprise data governance.
• Strong experience with API development, integration frameworks, and data services.
• Hands-on experience with: SQL, Python, PySpark, Java, or ETL/ELT Development
• Experience designing, developing, and implementing: Artificial Intelligence (AI) solutions, Machine Learning (ML) models, Generative AI capabilities, and/or Large Language Models (LLMs)
• Experience developing dashboards, visualization solutions, and analytics applications using: Tableau, Power BI, Angular or comparable front-end technologies
• Demonstrated ability to identify challenges, recommend solutions, and drive measurable business outcomes.
• Strong analytical, problem-solving, and strategic thinking capabilities.
• Exceptional verbal and written communication skills.
• Strong presentation and executive-level stakeholder management skills.

Preferred Qualifications & Skills:

• Previous people leadership and management experience.
• Direct Investment Management industry experience.
• Extensive Investment Data Management experience.
• Proven ability to build relationships, influence business partners, and drive cross-functional collaboration.
• Experience leading enterprise data transformation and modernization initiatives.
• Experience with cloud-based data platforms such as Azure, AWS, Snowflake, Databricks, or Microsoft Fabric.
• Experience working within Agile and product-oriented delivery models.

Education & Experience Requirements:

• Associate's degree in computer science, Information Technology, Data Science, Engineering, Finance, Business, or related field and 10+ years of relevant experience.
• Bachelor's degree in computer science, Information Technology, Data Science, Engineering, Finance, Business, or related field and 8+ years of relevant experience.
• Master's degree in computer science, Information Technology, Data Science, Engineering, Finance, Business, or related field and 6+ years of relevant experience.
• PhD in Computer Science, Information Technology, Data Science, Engineering, Finance, Business, or related field and 3+ years of relevant experience.
• No Degree and 12+ years of progressively responsible experience in data engineering, analytics, investment data management, enterprise data management, or related disciplines.

PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to