Senior Business Analytics Consultant advancing data engineering and reporting capabilities at PNC. Maintaining data pipelines powering critical Tableau dashboards for Retail Lending.
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.
Requirements
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.
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
Job title
Senior Business Analytics Consultant – Lending Analytics, Tableau
Delivery Consultant supporting customers in EMEA region for Plex Smart Manufacturing Platform. Responsibilities include implementation, consulting leadership, and customer relationship management.
Senior SharePoint Consultant consulting on Microsoft SharePoint engagements for enterprise and public sector clients. Leading service delivery functions and providing technical expertise in SharePoint solutions.
Client Experience Consultant with Cigna Healthcare enhancing client value through product and service support. Collaborating with Account Executives and internal teams to ensure client satisfaction and product optimization.
Senior Mechanical Consultant ensuring power generation design efficacy and serving as a technical liaison. Leading design projects and mentoring junior engineers in a hybrid work environment.
Senior Practice Consultant enhancing engagement and coaching with HNW Advisory teams at TD Wealth. Consulting on practice management initiatives and supporting Advisor growth through efficiency.
M&A Consultant identifying and analyzing M&A transactions aligned with company growth strategy. Collaborating with teams for successful execution in a dynamic environment.
Technology Consultant enhancing customer recognition of product value and improving sales effectiveness at Caterpillar. Collaborating with customers and industry associations for product feedback.
Cloud Consultant specializing in AWS with flexibility for remote work and engaging enterprise projects. Collaborating on cloud architecture and consulting at Netlution with a dynamic team.
Consultant for strategic planning and business restructuring at Heartman House. Collaborating with teams to generate insights and lead projects in a dynamic environment.
Project Management Consultant managing product development projects across E - Mobility and digital transformation sectors. Collaborating with agile and classic teams while ensuring quality and timely delivery.