Senior Business Analytics Consultant – Lending Analytics, Tableau

PNC

. Own, enhance, and maintain data pipelines powering Tableau data sources and Lending dashboards .

Posted 9/24/2026full-timeUnited StatesSenior💰 $75,000 - $125,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL, Python, and Tableau for developing and optimizing data pipelines and analytical solutions. Proven ability to translate business requirements into effective analytics strategies while ensuring data quality and performance.

Highest-signal resume keywords

Expert SQL SkillsPython Database ConnectivityTableau Desktop/Server ExperienceData Modeling and Performance OptimizationAnalytics and Business Intelligence Expertise

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonTableauData EngineeringData ManagementRelational ModelingComplex Query OptimizationData Pipeline DevelopmentAnalytical Solution DevelopmentPerformance Tuning

Soft Skills

Strong CommunicationAnalytical Reasoning

Tools & Technologies

MS SQL ServerTeradataOracleHadoopImpalaSharePointTableau Hyper API

Industry Keywords

Lending Sales DataKPI ReportingBusiness IntelligenceData QualityFDIASAFE ActFINRA

Tech Stack

Tools & technologies

HadoopMS SQL ServerOraclePythonSQLTableau

About the role

Key responsibilities & impact

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
Maintain consistency across environments using version-controlled SQL
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 subject-matter expert for lending sales data, KPIs, and reporting structures
Provide business and technical expertise for analytics processes, tools, and applications
Consult with clients on tool and strategy implementation, monitoring, statistical scoring, business intelligence, data quality, and analytical product/solution development
Determine optimal analytic approaches and support development, implementation, and enhancements
Develop and continuously optimize analytical solutions for business leadership
Analyze results, make recommendations, and communicate conclusions from complex analytical solutions

Requirements

What you’ll need

3+ years of relevant analytics, BI, data engineering, or data management experience
Expert SQL skills, including diagnosing, optimizing, and documenting complex queries
Strong experience with MS SQL Server, Teradata, Oracle, Hadoop/Impala, and 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
Familiarity with lending platforms preferred
Strong communication and analytical reasoning
Bachelor's degree; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree
No employment visa sponsorship or STEM OPT participation
Ability to meet applicable FDIA, SAFE Act, and/or FINRA requirements for registered roles

Benefits

Comp & perks

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 plan
Stock purchase plan
Dependent care reimbursement account
Back-up child/elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select programs fully paid
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
15 to 25 vacation days each year, depending on career level and years of service
Incentive eligible, with payment based upon company, business and/or individual performance