PNC · 10 hours ago
Business Analytics Consultant Senior- Lending Analytics & Tableau
Pittsburgh, PA
Full-time
Onsite
Mid, Senior Level
$55K/yr - $120K/yr
3+ years expPNC is a company that values its employees as its greatest differentiator and competitive advantage. As a Business Analytics Consultant Senior within PNC's Retail Lending organization, you will enhance data engineering and reporting capabilities while supporting critical Tableau dashboards and analytics solutions.
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
Leverages complex analytical tools to provide business and technical expertise for the analytics process, tools and useful applications across multiple functions or business units to create data driven solutions
Consulting to clients on tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product / solution development
Determining the optimal analytic approach and supporting development, implementation and enhancements
Conceptualizing, developing and continuously optimizing analytical solutions for business leadership to enable data driven decision making
Analyze results and make recommendations for key business partners and senior management or communicate conclusions from complex analytical solutions to a wide range of audiences
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
In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered
Bachelors
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