PNC · 1 hour ago
Business Analytics Consultant Senior- Lending Analytics & Tableau
PA - Pittsburgh (15222)
Full-time
Onsite
Mid, Senior Level
$55K/yr - $120K/yr
3+ years expPNC is a leading financial services company dedicated to delivering the best experience for its customers. They are seeking a Business Analytics Consultant Senior to support the Retail Lending Reporting and Analytics organization, focusing on enhancing data pipelines and analytics solutions for business leadership. This role involves working with complex SQL and Tableau to optimize reporting capabilities and ensure data-driven decision making.
BankingFinanceFinancial Services
No H1B
Responsibilities
Own, enhance, and maintain data pipelines powering Tableau data sources and Lending dashboards
Run, analyze, troubleshoot, and optimize complex SQL across MS SQL Server, Teradata, Oracle, Impala/Hadoop, and SharePoint
Use internal Python libraries to connect to databases and generate hyper extracts via the 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
Qualification
Required
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
Strong communication and analytical reasoning
3+ years of relevant analytics, BI, data engineering, or data management experience
Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience
Preferred
Lending platforms familiarity preferred
Analytical Thinking
Business Intelligence (BI)
Concept Development
Data-Driven Decision Making
Data Integration
Market Research
Performance Metrics
Qualitative Research
Strategic Planning
Benefits
Medical/prescription drug coverage (with a Health Savings Account feature)
Dental and vision options
Employee and spouse/child life insurance
Short and long-term disability protection
401(k) with PNC match
Pension and stock purchase plans
Dependent care reimbursement account
Back-up child/elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select programs fully paid
A robust wellness program with financial incentives
Maternity and/or parental leave
Up to 11 paid holidays each year
9 occasional absence days each year, unless otherwise required by law
Between 15 to 25 vacation days each year, depending on career level and years of service
Company
PNC
PNC is a financial service company providing bank deposits products and services to its community.
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
unknown1975-11-17IPO
Leadership Team
Keith Hayes
SVP, PNC Aviation Finance
M
Michael Gaber
Senior Vice President - Originations
Recent News
Bizjournals.com Feed (2025-11-12 15:43:17)
2026-01-22
Bizjournals.com Feed (2025-11-12 15:43:17)
2026-01-17
The Orlando Sentinel
2026-01-17
Company data provided by crunchbase