Business Analytics Consultant Senior- Lending Analytics & Tableau
PNC, Strongsville, OH, United States
Position Overview
As a Business Analytics Consultant Senior within PNC's Retail Lending organization, you will be based in Pittsburgh or Philadelphia, PA; Brecksville or Strongsville, OH; or Wilmington, DE. Your role focuses on advancing our data engineering and reporting capabilities, ensuring our analytics ecosystem is accurate, high‑performing, scalable, and strategically aligned with enterprise priorities.
Key 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.
Required Skills & Experience
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 platform familiarity preferred.
Strong communication and analytical reasoning.
3+ years of relevant analytics, BI, data engineering, or data management experience.
Education & Certifications Bachelor’s degree or equivalent combination of education, certification, and experience (including military service) may be considered. No certifications are required.
Salary Base Salary: $55,000.00 – $120,450.00 (may vary by location, market data and individual experience).
Visa and Sponsorship PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.
Benefits PNC offers a comprehensive benefits package, including 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; a robust wellness program with financial incentives; paid time off (maternity, 11 paid holidays, 9 occasional absence days, 15–25 vacation days), and more.
Equal Employment Opportunity (EEO) PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other protected categories. This position is subject to FDIA, SAFE Act, and/or FINRA regulations regarding hiring of individuals with certain criminal histories.
Disability Accommodations Statement If an accommodation is required to participate in the application process, please contact us via email at AccommodationRequest@pnc.com. Include “accommodation request” in the subject line, your name, job ID, and preferred contact method. Applicants may also call 877‑968‑7762 and say “Workday” for assistance. All information supplied will be kept confidential and used only to provide reasonable accommodations. PNC offers accommodations to qualified individuals with disabilities who require them to perform essential job functions.
California Residents Refer to the California Consumer Privacy Act Privacy Notice to understand how PNC may use or disclose your personal information in our hiring practices.
#J-18808-Ljbffr
Key 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.
Required Skills & Experience
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 platform familiarity preferred.
Strong communication and analytical reasoning.
3+ years of relevant analytics, BI, data engineering, or data management experience.
Education & Certifications Bachelor’s degree or equivalent combination of education, certification, and experience (including military service) may be considered. No certifications are required.
Salary Base Salary: $55,000.00 – $120,450.00 (may vary by location, market data and individual experience).
Visa and Sponsorship PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.
Benefits PNC offers a comprehensive benefits package, including 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; a robust wellness program with financial incentives; paid time off (maternity, 11 paid holidays, 9 occasional absence days, 15–25 vacation days), and more.
Equal Employment Opportunity (EEO) PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other protected categories. This position is subject to FDIA, SAFE Act, and/or FINRA regulations regarding hiring of individuals with certain criminal histories.
Disability Accommodations Statement If an accommodation is required to participate in the application process, please contact us via email at AccommodationRequest@pnc.com. Include “accommodation request” in the subject line, your name, job ID, and preferred contact method. Applicants may also call 877‑968‑7762 and say “Workday” for assistance. All information supplied will be kept confidential and used only to provide reasonable accommodations. PNC offers accommodations to qualified individuals with disabilities who require them to perform essential job functions.
California Residents Refer to the California Consumer Privacy Act Privacy Notice to understand how PNC may use or disclose your personal information in our hiring practices.
#J-18808-Ljbffr