Senior Lending Analytics & Tableau Specialist

PNC; Pittsburgh (Allegheny County); On-site; USD 95,000 - 135,000; Full time

Benefits offered by this job

On-site work

Job summary

PNC is seeking a Senior Business Analytics Consultant to join the Retail Lending Reporting and Analytics team, based in Pittsburgh, PA or Cleveland, OH. You will own data pipelines powering Tableau dashboards and a reporting portal, collaborating with stakeholders to translate requirements into analytics solutions.

The role emphasizes building scalable, accurate analytics ecosystems with hands-on work across SQL, Python, and Tableau, supporting multiple databases and data models.

Qualifications

• Expert SQL skills with ability to diagnose, optimize, and document complex queries.
• Strong experience with MS SQL Server, Teradata, Oracle, Hadoop/Impala, SharePoint.
• Python experience including database connectivity and extract automation.
• Tableau Desktop/Server experience including data modeling and performance best practices.
• Understanding of relational modeling, joins, and Tableau query generation.
• Lending platforms familiarity preferred.
• Strong communication and analytical reasoning.
• 3+ years of relevant analytics, BI, data engineering, or data management experience.

Responsibilities

• Own, enhance, and maintain data pipelines powering Tableau data sources and Lending dashboards.
• Run, analyze, troubleshoot, and optimize complex SQL across SQL Server, Teradata, Oracle, Hadoop/Impala, and SharePoint.
• Use Python libraries to connect to databases and generate hyper extracts via Tableau Hyper API.
• Work with version controlled SQL to maintain consistency across environments.
• Support Tableau Server data sources, extracts, permissions, and performance tuning.
• Develop and optimize Tableau data models, including relational and multi fact structures.
• Partner with business stakeholders to translate requirements into analytics solutions.
• Serve as SME for lending sales data, KPIs, and reporting structures.

Skills

SQL

MS SQL Server

Teradata

Oracle

Hadoop/Impala

SharePoint

Python

Tableau

Relational modeling

Lending data familiarity

Communication

Analytical reasoning

Tools

MS SQL Server

Teradata

Oracle

Hadoop/Impala

SharePoint

Tableau Desktop/Server

Tableau Hyper API

SQL version control

Job description

PNC is seeking a Senior Business Analytics Consultant to join the Retail Lending Reporting and Analytics team, based in Pittsburgh, PA or Cleveland, OH. You will own data pipelines powering Tableau dashboards and a reporting portal, collaborating with stakeholders to translate requirements into analytics solutions.

The role emphasizes building scalable, accurate analytics ecosystems with hands-on work across SQL, Python, and Tableau, supporting multiple databases and data models.